本帖最后由 Clark.Pan 于 2021-10-20 16:50 编辑
{
"cmd": "renameSheet",
"sheetName": "Sheet666",
"name": "Sheet666",
"xC": {
"GLc": [
{
"row": 3,
"rowCount": 1,
"col": 3,
"colCount": 1
}
],
"HLc": {
"row": 3,
"col": 3
}
},
"FA": "Sheet3",
"changesSheet666": [
{
"type": "setName",
"value": "Sheet3"
}
],
"sheetId": 2
}
使用spread.commandManager.execute()执行上面这个重命名sheetName的命令,会报错,报错信息如下
但使用spread.commandManager.execute()执行列如改值的操作则可以执行
{ "cmd": "editCell", "sheetName": "Sheet666", "row": 3, "col": 6, "newValue": "444", "autoFormat": true, "xC": { "GLc": [ { "row": 3, "rowCount": 1, "col": 6, "colCount": 1 } ], "HLc": { "row": 3, "col": 6 } }, "applyResult": 0, "changesSheet666": [ [ [ "sheetModels", 3, "dataTable", 3, 6, "value" ], null ], { "sheetArea": 3, "type": "updateDirty", "row": 3, "col": 6, "isEmptyRow": true }, [ [ "sheetModels", 3, "dataTable", 3, 6, "style" ], null ] ], "sheetId": 14}
|