【SpreadJS】出现无法插入新的单元格报错

收藏

本帖最后由 Clark.Pan 于 2023-1-10 12:19 编辑

gc.spread.sheets.all.min.js:81398 Uncaught Error: 无法插入新的单元格，因为它会导致某些非空单元格移出工作表。您可以尝试删除行或列来保证有足够的区域可以插入。

复制代码

let myTemplate={"version":"15.2.2","docProps":{"docPropsCore":{"creator":"guangrongyang","lastModifiedBy":"光荣的最后一枪","created":"2022-12-22T15:07:55Z","modified":"2022-12-22T15:08:30Z"},"docPropsApp":{"Application":"WPS 文字","HeadingPairs":{"size":2,"baseType":"variant","workbookInfoArray":[{"elementType":"vt:lpstr","value":"工作表"},{"elementType":"vt:i4","value":"2"}]},"TitlesOfParts":{"size":2,"baseType":"lpstr","sheetsNameArray":["BGCLYSB1 办公车辆预算表","Sheet1"]}},"docPropsCustom":[{"fmtid":"{D5CDD505-2E9C-101B-9397-08002B2CF9AE}","pid":"2","name":"ICV","propertyItemChildElement":{"vt:lpwstr":"1527F3C9EC722B9F4B02A463563BF1C7"}},{"fmtid":"{D5CDD505-2E9C-101B-9397-08002B2CF9AE}","pid":"3","name":"KSOProductBuildVer","propertyItemChildElement":{"vt:lpwstr":"2052-4.6.1.7467"}}]},"sheetCount":2,"tabStripRatio":0.6,"iterativeCalculation":false,"iterativeCalculationMaximumIterations":100,"iterativeCalculationMaximumChange":0.001,"customList":[],"sheets":{"BGCLYSB1 办公车辆预算表":{"name":"BGCLYSB1 办公车辆预算表","isSelected":true,"rowCount":21,"columnCount":11,"activeRow":12,"activeCol":4,"visible":1,"frozenTrailingRowStickToEdge":true,"frozenTrailingColumnStickToEdge":true,"theme":"Office","data":{"dataTable":{"0":{"0":{"style":"__builtInStyle3"},"1":{"style":"__builtInStyle3"},"2":{"style":"__builtInStyle3"},"3":{"style":"__builtInStyle3"},"4":{"style":"__builtInStyle3"},"5":{"value":"办公车辆预算表","style":"__builtInStyle19"},"6":{"style":"__builtInStyle3"},"7":{"style":"__builtInStyle3"},"8":{"style":"__builtInStyle3"},"9":{"style":"__builtInStyle3"},"10":{"style":"__builtInStyle3"}},"1":{"0":{"style":"__builtInStyle3"},"1":{"style":"__builtInStyle3"},"2":{"style":"__builtInStyle3"},"3":{"style":"__builtInStyle3"},"4":{"style":"__builtInStyle3"},"5":{"style":"__builtInStyle3"},"6":{"style":"__builtInStyle3"},"7":{"style":"__builtInStyle3"},"8":{"style":"__builtInStyle3"},"9":{"style":"__builtInStyle3"},"10":{"value":"金额单位：万元","style":"__builtInStyle23"}},"2":{"0":{"value":"编制单位：中铁开发投资有限公司（管理口径）","style":"__builtInStyle4"},"1":{"style":"__builtInStyle5"},"2":{"style":"__builtInStyle5"},"3":{"style":"__builtInStyle5"},"4":{"style":"__builtInStyle5"},"5":{"style":"__builtInStyle5"},"6":{"style":"__builtInStyle5"},"7":{"style":"__builtInStyle5"},"8":{"style":"__builtInStyle5"},"9":{"style":"__builtInStyle5"},"10":{"value":"报表编号：20","style":"__builtInStyle24"}},"3":{"0":{"value":"填表人：","style":"__builtInStyle6"},"1":{"style":"__builtInStyle7","bindingPath":"userName"},"2":{"value":"所属部门：","style":"__builtInStyle6"},"3":{"style":"__builtInStyle7","bindingPath":"departmentName"},"4":{"value":"座机号（带区号）：","style":"__builtInStyle6"},"5":{"style":"__builtInStyle7","bindingPath":"phone"},"6":{"value":"手机号：","style":"__builtInStyle6"},"7":{"style":"__builtInStyle20","bindingPath":"字段-0"},"8":{"style":"__builtInStyle25"},"9":{"style":"__builtInStyle25"},"10":{"style":"__builtInStyle25"}},"4":{"0":{"style":"__builtInStyle8"},"1":{"style":"__builtInStyle9"},"2":{"value":"二级机关本部","style":"__builtInStyle8"},"3":{"value":"所有三级机关本部","style":"__builtInStyle8"},"4":{"value":"所有四级及以下机关本部","style":"__builtInStyle8"},"5":{"value":"所有项目部/指挥部","style":"__builtInStyle8"},"6":{"value":"办公车辆保有数量合计","style":"__builtInStyle8"},"7":{"style":"__builtInStyle21"},"8":{"style":"__builtInStyle22"},"9":{"style":"__builtInStyle22"},"10":{"style":"__builtInStyle22"}},"5":{"0":{"value":"截至上年末实际办公车辆保有数量","style":"__builtInStyle10"},"1":{"value":"截至上年末实际办公车辆保有数量","style":"__builtInStyle11"},"2":{"style":"__builtInStyle12","bindingPath":"secondNum"},"3":{"style":"__builtInStyle12","bindingPath":"threeNum"},"4":{"style":"__builtInStyle12","bindingPath":"fourNum"},"5":{"style":"__builtInStyle12","bindingPath":"allNum"},"6":{"value":0,"style":"__builtInStyle17","formula":"SUM(C6:F6)"},"7":{"style":"__builtInStyle22"},"8":{"style":"__builtInStyle22"},"9":{"style":"__builtInStyle22"},"10":{"style":"__builtInStyle22"}},"6":{"0":{"value":"项目","style":"__builtInStyle13"},"1":{"value":"项目名称","style":"__builtInStyle13"},"2":{"value":"现有办公车辆数量","style":"__builtInStyle13"},"3":{"value":"报废更新购车数量","style":"__builtInStyle13"},"4":{"value":"保有不足购车数量","style":"__builtInStyle13"},"5":{"value":"新增项目购车数量","style":"__builtInStyle13"},"6":{"value":"新设机构购车数量","style":"__builtInStyle13"},"7":{"value":"其他购车数量","style":"__builtInStyle13"},"8":{"value":"购车数量合计","style":"__builtInStyle13"},"9":{"value":"购置金额","style":"__builtInStyle13"},"10":{"value":"备注","style":"__builtInStyle13"}},"7":{"0":{"value":"项目","style":"__builtInStyle14"},"1":{"value":"1","style":"__builtInStyle15"},"2":{"value":"2","style":"__builtInStyle15"},"3":{"value":"3","style":"__builtInStyle15"},"4":{"value":"4","style":"__builtInStyle15"},"5":{"value":"5","style":"__builtInStyle15"},"6":{"value":"6","style":"__builtInStyle15"},"7":{"value":"7","style":"__builtInStyle15"},"8":{"value":"8","style":"__builtInStyle15"},"9":{"value":"9","style":"__builtInStyle15"},"10":{"value":"10","style":"__builtInStyle15"}},"8":{"0":{"value":"序号","style":"__builtInStyle13"},"1":{"style":"__builtInStyle16"},"2":{"style":"__builtInStyle17"},"3":{"style":"__builtInStyle17"},"4":{"style":"__builtInStyle17"},"5":{"style":"__builtInStyle17"},"6":{"style":"__builtInStyle17"},"7":{"style":"__builtInStyle17"},"8":{"style":"__builtInStyle17"},"9":{"style":"__builtInStyle26"},"10":{"style":"__builtInStyle16"}},"9":{"0":{"value":"1","style":"__builtInStyle18"},"1":{"style":"__builtInStyle7"},"2":{"style":"__builtInStyle12"},"3":{"style":"__builtInStyle12"},"4":{"style":"__builtInStyle12"},"5":{"style":"__builtInStyle12"},"6":{"style":"__builtInStyle12"},"7":{"style":"__builtInStyle12"},"8":{"style":"__builtInStyle17"},"9":{"style":"__builtInStyle27"},"10":{"style":"__builtInStyle18"}},"10":{"0":{"value":"2","style":"__builtInStyle18"},"1":{"style":"__builtInStyle7"},"2":{"style":"__builtInStyle12"},"3":{"style":"__builtInStyle12"},"4":{"style":"__builtInStyle12"},"5":{"style":"__builtInStyle12"},"6":{"style":"__builtInStyle12"},"7":{"style":"__builtInStyle12"},"8":{"style":"__builtInStyle17"},"9":{"style":"__builtInStyle27"},"10":{"style":"__builtInStyle18"}},"11":{"0":{"value":"3","style":"__builtInStyle18"},"1":{"style":"__builtInStyle7"},"2":{"style":"__builtInStyle12"},"3":{"style":"__builtInStyle12"},"4":{"style":"__builtInStyle12"},"5":{"style":"__builtInStyle12"},"6":{"style":"__builtInStyle12"},"7":{"style":"__builtInStyle12"},"8":{"style":"__builtInStyle17"},"9":{"style":"__builtInStyle27"},"10":{"style":"__builtInStyle18"}},"12":{"0":{"value":"4","style":"__builtInStyle18"},"1":{"style":"__builtInStyle7"},"2":{"style":"__builtInStyle12"},"3":{"style":"__builtInStyle12"},"4":{"style":"__builtInStyle12"},"5":{"style":"__builtInStyle12"},"6":{"style":"__builtInStyle12"},"7":{"style":"__builtInStyle12"},"8":{"style":"__builtInStyle17"},"9":{"style":"__builtInStyle27"},"10":{"style":"__builtInStyle18"}},"13":{"0":{"value":"5","style":"__builtInStyle18"},"1":{"style":"__builtInStyle7"},"2":{"style":"__builtInStyle12"},"3":{"style":"__builtInStyle12"},"4":{"style":"__builtInStyle12"},"5":{"style":"__builtInStyle12"},"6":{"style":"__builtInStyle12"},"7":{"style":"__builtInStyle12"},"8":{"style":"__builtInStyle17"},"9":{"style":"__builtInStyle27"},"10":{"style":"__builtInStyle18"}},"14":{"0":{"value":"6","style":"__builtInStyle18"},"1":{"style":"__builtInStyle7"},"2":{"style":"__builtInStyle12"},"3":{"style":"__builtInStyle12"},"4":{"style":"__builtInStyle12"},"5":{"style":"__builtInStyle12"},"6":{"style":"__builtInStyle12"},"7":{"style":"__builtInStyle12"},"8":{"style":"__builtInStyle17"},"9":{"style":"__builtInStyle27"},"10":{"style":"__builtInStyle18"}},"15":{"0":{"value":"7","style":"__builtInStyle18"},"1":{"style":"__builtInStyle7"},"2":{"style":"__builtInStyle12"},"3":{"style":"__builtInStyle12"},"4":{"style":"__builtInStyle12"},"5":{"style":"__builtInStyle12"},"6":{"style":"__builtInStyle12"},"7":{"style":"__builtInStyle12"},"8":{"style":"__builtInStyle17"},"9":{"style":"__builtInStyle27"},"10":{"style":"__builtInStyle18"}},"16":{"0":{"value":"8","style":"__builtInStyle18"},"1":{"style":"__builtInStyle7"},"2":{"style":"__builtInStyle12"},"3":{"style":"__builtInStyle12"},"4":{"style":"__builtInStyle12"},"5":{"style":"__builtInStyle12"},"6":{"style":"__builtInStyle12"},"7":{"style":"__builtInStyle12"},"8":{"style":"__builtInStyle17"},"9":{"style":"__builtInStyle27"},"10":{"style":"__builtInStyle18"}},"17":{"0":{"value":"9","style":"__builtInStyle18"},"1":{"style":"__builtInStyle7"},"2":{"style":"__builtInStyle12"},"3":{"style":"__builtInStyle12"},"4":{"style":"__builtInStyle12"},"5":{"style":"__builtInStyle12"},"6":{"style":"__builtInStyle12"},"7":{"style":"__builtInStyle12"},"8":{"style":"__builtInStyle17"},"9":{"style":"__builtInStyle27"},"10":{"style":"__builtInStyle18"}},"18":{"0":{"value":"10","style":"__builtInStyle18"},"1":{"style":"__builtInStyle7"},"2":{"style":"__builtInStyle12"},"3":{"style":"__builtInStyle12"},"4":{"style":"__builtInStyle12"},"5":{"style":"__builtInStyle12"},"6":{"style":"__builtInStyle12"},"7":{"style":"__builtInStyle12"},"8":{"style":"__builtInStyle17"},"9":{"style":"__builtInStyle27"},"10":{"style":"__builtInStyle18"}},"19":{"0":{"value":"11","style":"__builtInStyle18"},"1":{"style":"__builtInStyle7"},"2":{"style":"__builtInStyle12"},"3":{"style":"__builtInStyle12"},"4":{"style":"__builtInStyle12"},"5":{"style":"__builtInStyle12"},"6":{"style":"__builtInStyle12"},"7":{"style":"__builtInStyle12"},"8":{"style":"__builtInStyle17"},"9":{"style":"__builtInStyle27"},"10":{"style":"__builtInStyle18"}},"20":{"0":{"value":"12","style":"__builtInStyle18"},"1":{"value":"汇总","style":"__builtInStyle7"},"2":{"style":"__builtInStyle12"},"3":{"style":"__builtInStyle12"},"4":{"style":"__builtInStyle12"},"5":{"style":"__builtInStyle12"},"6":{"style":"__builtInStyle12"},"7":{"style":"__builtInStyle12"},"8":{"style":"__builtInStyle17"},"9":{"style":"__builtInStyle27"},"10":{"value":0,"style":"__builtInStyle18","formula":"SUBTOTAL(109,gcTable0[remark])"}}},"defaultDataNode":{"style":{"themeFont":"Body"}}},"rowHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"colHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"rows":[{"size":43},{"size":15},{"size":15},{"size":30},{"size":30},{"size":30},{"size":30},{"size":30},{"size":30},{"size":30},{"size":30},{"size":30},{"size":30},{"size":30},{"size":30},{"size":30},{"size":30},{"size":30},{"size":30},{"size":30},{"size":30}],"columns":[{"size":93},{"size":230},{"size":157},{"size":157},{"size":157},{"size":157},{"size":157},{"size":157},{"size":157},{"size":157},{"size":212}],"leftCellIndex":0,"topCellIndex":6,"spans":[{"row":4,"rowCount":1,"col":0,"colCount":2},{"row":5,"rowCount":1,"col":0,"colCount":2},{"row":6,"rowCount":2,"col":0,"colCount":1},{"row":4,"rowCount":2,"col":7,"colCount":4}],"selections":{"0":{"row":12,"rowCount":1,"col":4,"colCount":1},"length":1},"defaults":{"colHeaderRowHeight":20,"colWidth":69,"rowHeaderColWidth":40,"rowHeight":16},"rowOutlines":{"items":[],"direction":0},"columnOutlines":{"items":[],"direction":0},"cellStates":{},"states":{},"outlineColumnOptions":{},"autoMergeRangeInfos":[],"tables":[{"name":"gcTable0","row":9,"col":1,"rowCount":12,"colCount":10,"showFooter":true,"useFooterDropDownList":true,"bandRows":false,"style":{"buildInName":"Medium2"},"autoGenerateColumns":false,"bindingPath":"project","rowFilter":{"range":{"row":10,"rowCount":10,"col":1,"colCount":10},"typeName":"HideRowFilter","dialogVisibleInfo":{},"filterButtonVisibleInfo":{"0":true,"1":true,"2":true,"3":true,"4":true,"5":true,"6":true,"7":true,"8":true,"9":true},"showFilterButton":true,"filteredOutRows":[],"tableName":"gcTable0"},"columns":[{"id":0,"name":"projectName","dataField":"projectName","footerValue":"汇总"},{"id":1,"name":"havaCarNum","dataField":"havaCarNum"},{"id":2,"name":"badCarNum","dataField":"badCarNum"},{"id":3,"name":"lessCarNum","dataField":"lessCarNum"},{"id":4,"name":"addCarnum","dataField":"addCarnum"},{"id":5,"name":"newSetNum","dataField":"newSetNum"},{"id":6,"name":"otherCarNum","dataField":"otherCarNum"},{"id":7,"name":"purchasedNum","dataField":"purchasedNum"},{"id":8,"name":"purchasedAmount","dataField":"purchasedAmount"},{"id":9,"name":"remark","dataField":"remark","footerFormula":"SUBTOTAL(109,gcTable0[remark])"}]}],"shapeCollectionOption":{"snapMode":0},"printInfo":{"pageHeaderFooter":{},"margin":{"top":96,"bottom":96,"left":72,"right":72,"header":48,"footer":48},"pageOrder":1,"fitPagesTall":1,"fitPagesWide":1,"paperSize":{"width":850,"height":1100,"kind":1}},"index":0},"Sheet1":{"name":"Sheet1","isSelected":false,"rowCount":7,"columnCount":7,"activeRow":6,"activeCol":6,"visible":1,"frozenTrailingRowStickToEdge":true,"frozenTrailingColumnStickToEdge":true,"theme":"Office","data":{"columnDataArray":[{"style":"__builtInStyle2"},{"style":"__builtInStyle2"},{"style":"__builtInStyle2"},{"style":"__builtInStyle2"},{"style":"__builtInStyle2"},{"style":"__builtInStyle2"},{"style":"__builtInStyle2"}],"defaultDataNode":{"style":{"backColor":null,"foreColor":"Text 1 0","vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"diagonalDown":null,"diagonalUp":null,"fontForColumnWidth":"normal normal 14.7px Calibri"}},"dataTable":{}},"rowHeaderData":{},"colHeaderData":{},"leftCellIndex":0,"topCellIndex":0,"selections":{"0":{"row":6,"rowCount":1,"col":6,"colCount":1},"length":1},"defaults":{"colHeaderRowHeight":20,"colWidth":65,"rowHeaderColWidth":40,"rowHeight":22.4},"rowOutlines":{"items":[]},"columnOutlines":{"items":[]},"cellStates":{},"states":{},"outlineColumnOptions":{},"autoMergeRangeInfos":[],"shapeCollectionOption":{"snapMode":0},"printInfo":{"pageHeaderFooter":{},"margin":{"top":96,"bottom":96,"left":72,"right":72,"header":48,"footer":48},"pageOrder":1,"paperSize":{"width":850,"height":1100,"kind":1}},"index":1}},"sheetTabCount":0,"namedStyles":[{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Normal","diagonalDown":null,"diagonalUp":null},{"backColor":"Accent 6 40","foreColor":"Background 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"60% - Accent6","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"Accent 4 80","foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"20% - Accent4","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"Accent 4 0","foreColor":"Background 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Accent4","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"#ffcc99","foreColor":"#3f3f76","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#7f7f7f","style":1},"borderTop":{"color":"#7f7f7f","style":1},"borderRight":{"color":"#7f7f7f","style":1},"borderBottom":{"color":"#7f7f7f","style":1},"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Input","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"Accent 3 60","foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"40% - Accent3","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"Accent 3 80","foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"20% - Accent3","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","formatter":"_ "￥"* #,##0.00_ ;_ "￥"* \\-#,##0.00_ ;_ "￥"* "-"??_ ;_ @_ ","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Currency","diagonalDown":null,"diagonalUp":null,"applyFont":false,"applyFill":false,"applyAlignment":false,"applyBorder":false,"applyProtection":false},{"backColor":"Accent 3 0","foreColor":"Background 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Accent3","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","formatter":"0%","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Percent","diagonalDown":null,"diagonalUp":null,"applyFont":false,"applyFill":false,"applyAlignment":false,"applyBorder":false,"applyProtection":false},{"backColor":"Accent 2 40","foreColor":"Background 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"60% - Accent2","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"Accent 5 40","foreColor":"Background 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"60% - Accent5","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"Accent 2 0","foreColor":"Background 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Accent2","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"Accent 1 40","foreColor":"Background 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"60% - Accent1","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"Accent 4 40","foreColor":"Background 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"60% - Accent4","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"#f2f2f2","foreColor":"#fa7d00","hAlign":3,"vAlign":1,"font":"normal bold 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#7f7f7f","style":1},"borderTop":{"color":"#7f7f7f","style":1},"borderRight":{"color":"#7f7f7f","style":1},"borderBottom":{"color":"#7f7f7f","style":1},"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Calculation","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"Accent 1 0","foreColor":"Background 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Accent1","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"#ffeb9c","foreColor":"#9c6500","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Neutral","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"Accent 5 80","foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"20% - Accent5","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"#c6efce","foreColor":"#006100","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Good","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"Accent 1 80","foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"20% - Accent1","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal bold 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":{"color":"Accent 1 0","style":1},"borderRight":null,"borderBottom":{"color":"Accent 1 0","style":6},"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Total","diagonalDown":null,"diagonalUp":null,"applyFill":false,"applyAlignment":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"#ffc7ce","foreColor":"#9c0006","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Bad","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"#a5a5a5","foreColor":"#ffffff","hAlign":3,"vAlign":1,"font":"normal bold 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#3f3f3f","style":6},"borderTop":{"color":"#3f3f3f","style":6},"borderRight":{"color":"#3f3f3f","style":6},"borderBottom":{"color":"#3f3f3f","style":6},"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Check Cell","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"#f2f2f2","foreColor":"#3f3f3f","hAlign":3,"vAlign":1,"font":"normal bold 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#3f3f3f","style":1},"borderTop":{"color":"#3f3f3f","style":1},"borderRight":{"color":"#3f3f3f","style":1},"borderBottom":{"color":"#3f3f3f","style":1},"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Output","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":null,"foreColor":"Text 2 0","hAlign":3,"vAlign":1,"font":"normal bold 20px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":{"color":"Accent 1 0","style":2},"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Heading 1","diagonalDown":null,"diagonalUp":null,"applyFill":false,"applyAlignment":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":null,"foreColor":"#7f7f7f","hAlign":3,"vAlign":1,"font":"italic normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Explanatory Text","diagonalDown":null,"diagonalUp":null,"applyFill":false,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"Accent 2 80","foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"20% - Accent2","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":null,"foreColor":"Text 2 0","hAlign":3,"vAlign":1,"font":"normal bold 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Heading 4","diagonalDown":null,"diagonalUp":null,"applyFill":false,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","formatter":"_ "￥"* #,##0_ ;_ "￥"* \\-#,##0_ ;_ "￥"* "-"_ ;_ @_ ","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Currency [0]","diagonalDown":null,"diagonalUp":null,"applyFont":false,"applyFill":false,"applyAlignment":false,"applyBorder":false,"applyProtection":false},{"backColor":"Accent 4 60","foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"40% - Accent4","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","formatter":"_ * #,##0.00_ ;_ * \\-#,##0.00_ ;_ * "-"??_ ;_ @_ ","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Comma","diagonalDown":null,"diagonalUp":null,"applyFont":false,"applyFill":false,"applyAlignment":false,"applyBorder":false,"applyProtection":false},{"backColor":null,"foreColor":"#800080","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":1,"name":"已访问的超链接","diagonalDown":null,"diagonalUp":null,"applyFill":false,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":null,"foreColor":"Text 2 0","hAlign":3,"vAlign":1,"font":"normal bold 24px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Title","diagonalDown":null,"diagonalUp":null,"applyFill":false,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"Accent 2 60","foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"40% - Accent2","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":null,"foreColor":"#ff0000","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Warning Text","diagonalDown":null,"diagonalUp":null,"applyFill":false,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"Accent 3 40","foreColor":"Background 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"60% - Accent3","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"#ffffcc","foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":{"color":"#b2b2b2","style":1},"borderTop":{"color":"#b2b2b2","style":1},"borderRight":{"color":"#b2b2b2","style":1},"borderBottom":{"color":"#b2b2b2","style":1},"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Note","diagonalDown":null,"diagonalUp":null,"applyFont":false,"applyAlignment":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"Accent 6 80","foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"20% - Accent6","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"Accent 5 0","foreColor":"Background 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Accent5","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"Accent 6 60","foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"40% - Accent6","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":null,"foreColor":"#0000ff","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":1,"name":"超链接","diagonalDown":null,"diagonalUp":null,"applyFill":false,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","formatter":"_ * #,##0_ ;_ * \\-#,##0_ ;_ * "-"_ ;_ @_ ","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Comma [0]","diagonalDown":null,"diagonalUp":null,"applyFont":false,"applyFill":false,"applyAlignment":false,"applyBorder":false,"applyProtection":false},{"backColor":null,"foreColor":"Text 2 0","hAlign":3,"vAlign":1,"font":"normal bold 17.3px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":{"color":"Accent 1 0","style":2},"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Heading 2","diagonalDown":null,"diagonalUp":null,"applyFill":false,"applyAlignment":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"Accent 5 60","foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"40% - Accent5","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":null,"foreColor":"Text 2 0","hAlign":3,"vAlign":1,"font":"normal bold 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":{"color":"Accent 1 50","style":2},"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Heading 3","diagonalDown":null,"diagonalUp":null,"applyFill":false,"applyAlignment":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"Accent 6 0","foreColor":"Background 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Accent6","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":"Accent 1 60","foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"40% - Accent1","diagonalDown":null,"diagonalUp":null,"applyAlignment":false,"applyBorder":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":null,"foreColor":"#fa7d00","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":{"color":"#ff8001","style":6},"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"Linked Cell","diagonalDown":null,"diagonalUp":null,"applyFill":false,"applyAlignment":false,"applyNumberFormat":false,"applyProtection":false},{"backColor":null,"foreColor":"Text 1 0","hAlign":3,"vAlign":1,"font":"normal normal 14.7px Calibri","themeFont":"Body","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"__builtInStyle1","diagonalDown":null,"diagonalUp":null},{"backColor":null,"foreColor":null,"hAlign":3,"vAlign":2,"font":"normal normal 13.3px Arial","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"__builtInStyle2","diagonalDown":null,"diagonalUp":null},{"backColor":"#ffffff","foreColor":null,"hAlign":0,"vAlign":1,"font":"normal normal 12px 宋体","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"__builtInStyle3","diagonalDown":null,"diagonalUp":null},{"backColor":"#ffffff","foreColor":"#000000","hAlign":0,"vAlign":1,"font":"normal normal 12px 宋体","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"__builtInStyle4","diagonalDown":null,"diagonalUp":null},{"backColor":"#ffffff","foreColor":null,"hAlign":0,"vAlign":1,"font":"normal normal 12px 宋体","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"__builtInStyle5","diagonalDown":null,"diagonalUp":null},{"backColor":"#c0c0c0","foreColor":null,"hAlign":2,"vAlign":1,"font":"normal bold 13.3px 宋体","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"__builtInStyle6","diagonalDown":null,"diagonalUp":null},{"backColor":"#ffffff","foreColor":null,"hAlign":0,"vAlign":1,"font":"normal normal 13.3px 宋体","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"textDecoration":0,"name":"__builtInStyle7","diagonalDown":null,"diagonalUp":null},{"backColor":"#c0c0c0","foreColor":null,"hAlign":1,"vAlign":1,"font":"normal bold 13.3px 宋体","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"textDecoration":0,"name":"__builtInStyle8","diagonalDown":null,"diagonalUp":null},{"backColor":null,"foreColor":null,"hAlign":1,"vAlign":1,"font":"normal bold 13.3px 宋体","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"textDecoration":0,"name":"__builtInStyle9","diagonalDown":null,"diagonalUp":null},{"backColor":"#c0c0c0","foreColor":null,"hAlign":0,"vAlign":1,"font":"normal bold 13.3px 宋体","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"textDecoration":0,"name":"__builtInStyle10","diagonalDown":null,"diagonalUp":null},{"backColor":null,"foreColor":null,"hAlign":0,"vAlign":1,"font":"normal bold 13.3px 宋体","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"textDecoration":0,"name":"__builtInStyle11","diagonalDown":null,"diagonalUp":null},{"backColor":"#ffffff","foreColor":null,"hAlign":2,"vAlign":1,"font":"normal normal 13.3px 宋体","formatter":"#,##0","borderLeft":null,"borderTop":null,"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"shrinkToFit":true,"textDecoration":0,"name":"__builtInStyle12","diagonalDown":null,"diagonalUp":null},{"backColor":"#c0c0c0","foreColor":null,"hAlign":1,"vAlign":1,"font":"normal bold 13.3px 宋体","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"__builtInStyle13","diagonalDown":null,"diagonalUp":null},{"backColor":null,"foreColor":null,"hAlign":1,"vAlign":1,"font":"normal bold 13.3px 宋体","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"__builtInStyle14","diagonalDown":null,"diagonalUp":null},{"backColor":"#c0c0c0","foreColor":null,"hAlign":1,"vAlign":1,"font":"normal normal 13.3px 宋体","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"__builtInStyle15","diagonalDown":null,"diagonalUp":null},{"backColor":"#ffffff","foreColor":null,"hAlign":1,"vAlign":1,"font":"normal normal 13.3px 宋体","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"__builtInStyle16","diagonalDown":null,"diagonalUp":null},{"backColor":"#00ff00","foreColor":null,"hAlign":2,"vAlign":1,"font":"normal normal 13.3px 宋体","formatter":"#,##0","borderLeft":null,"borderTop":null,"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"shrinkToFit":true,"textDecoration":0,"name":"__builtInStyle17","diagonalDown":null,"diagonalUp":null},{"backColor":"#ffffff","foreColor":null,"hAlign":0,"vAlign":1,"font":"normal normal 13.3px 宋体","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"__builtInStyle18","diagonalDown":null,"diagonalUp":null},{"backColor":"#ffffff","foreColor":"#000000","hAlign":1,"vAlign":1,"font":"normal bold 34.7px 宋体","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"__builtInStyle19","diagonalDown":null,"diagonalUp":null},{"backColor":"#ffffff","foreColor":null,"hAlign":0,"vAlign":1,"font":"normal normal 13.3px 宋体","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"shrinkToFit":true,"textDecoration":0,"name":"__builtInStyle20","diagonalDown":null,"diagonalUp":null},{"backColor":"#c0c0c0","foreColor":null,"hAlign":1,"vAlign":1,"font":"normal normal 13.3px 宋体","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"textDecoration":0,"name":"__builtInStyle21","diagonalDown":null,"diagonalUp":null},{"backColor":null,"foreColor":null,"hAlign":1,"vAlign":1,"font":"normal normal 13.3px 宋体","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":true,"textDecoration":0,"name":"__builtInStyle22","diagonalDown":null,"diagonalUp":null},{"backColor":"#ffffff","foreColor":"#000000","hAlign":2,"vAlign":1,"font":"normal normal 12px 宋体","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":null,"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"__builtInStyle23","diagonalDown":null,"diagonalUp":null},{"backColor":"#ffffff","foreColor":"#000000","hAlign":2,"vAlign":1,"font":"normal normal 12px 宋体","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":null,"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"__builtInStyle24","diagonalDown":null,"diagonalUp":null},{"backColor":"#c0c0c0","foreColor":null,"hAlign":0,"vAlign":1,"font":"normal normal 13.3px 宋体","formatter":"General","borderLeft":null,"borderTop":null,"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"textDecoration":0,"name":"__builtInStyle25","diagonalDown":null,"diagonalUp":null},{"backColor":"#00ff00","foreColor":null,"hAlign":2,"vAlign":1,"font":"normal normal 13.3px 宋体","formatter":"#,##0.00","borderLeft":null,"borderTop":null,"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"shrinkToFit":true,"textDecoration":0,"name":"__builtInStyle26","diagonalDown":null,"diagonalUp":null},{"backColor":"#ffffff","foreColor":null,"hAlign":2,"vAlign":1,"font":"normal normal 13.3px 宋体","formatter":"#,##0.00","borderLeft":null,"borderTop":null,"borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1},"locked":true,"textIndent":0,"wordWrap":false,"shrinkToFit":true,"textDecoration":0,"name":"__builtInStyle27","diagonalDown":null,"diagonalUp":null}],"pivotCaches":{},"dataManager":{"tables":[{"name":"表1","dataSourceOption":{"data":null,"remote":{"read":{"url":"https://demodata.grapecity.com/northwind/api/v1/Orders","method":"GET","dataType":"json"},"create":{"url":"","method":"POST","dataType":"json"},"update":{"url":"","method":"PUT","dataType":"json"},"delete":{"url":"","method":"DELETE","dataType":"json"},"batch":{"url":"","method":"POST","dataType":"json"}},"autoSync":false,"batch":false,"schema":{"type":"json","countPath":"","dataPath":""}},"primaryKey":"","views":[]}],"relationships":[]},"designerBindingPathSchema":{"$schema":"http://json-schema.org/draft-04/schema#","properties":{"userName":{"dataFieldType":"text","type":"string"},"departmentName":{"dataFieldType":"text","type":"string"},"phone":{"dataFieldType":"text","type":"string"},"secondNum":{"dataFieldType":"text","type":"string"},"threeNum":{"dataFieldType":"text","type":"string"},"fourNum":{"dataFieldType":"text","type":"string"},"allNum":{"dataFieldType":"text","type":"string"},"project":{"dataFieldType":"table","type":"array","items":{"type":"object","properties":{"projectName":{"type":"string"},"havaCarNum":{"type":"string"},"badCarNum":{"type":"string"},"lessCarNum":{"type":"string"},"addCarnum":{"type":"string"},"newSetNum":{"type":"string"},"otherCarNum":{"type":"string"},"purchasedNum":{"type":"string"},"purchasedAmount":{"type":"string"},"remark":{"type":"string"}}}}},"type":"object"}}
// let spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"));
this.spread.fromJSON(myTemplate);
let sheet = this.spread.getActiveSheet();
let dbSource3={
"project":[
{"projectName":"公司本部"},
{"projectName":"重庆分公司"},
{"projectName":"湖北分公司"},
{"projectName":"贵州分公司"},
{"projectName": "云南分公司"},
{"projectName":"跨境经营中心"},
{"projectName":"贵阳地铁3号线"},
{"projectName":"昆倘指挥部"},
{"projectName":"总部大厦"},
{"projectName":"东格高速"},
{"projectName": "玉楚项目公司"},
{"projectName": "宜昌指挥部"}
]
}
let dataSource = new GC.Spread.Sheets.Bindings.CellBindingSource(dbSource3);
sheet.setDataSource(dataSource);
}

复制代码

如代码所示，设置了dbSource3 就报错

Richard.Ma · Richard.Ma

麻烦把你这边的“myTemplate”json字符串存到文件中上传一下，我在这边来复现一下问题

直接复制字符串会有问题。可能是符号有丢失

热点科技 · 热点科技

本帖最后由热点科技于 2022-12-23 10:38 编辑

PreViewTemplate.js (92.48 KB, 下载次数: 53)

热点科技 · 热点科技

本帖最后由热点科技于 2022-12-23 10:55 编辑

热点科技发表于 2022-12-23 10:36

dbSource3 只保留一个对象，就不会保存。
我想加载所以对象数据（每个{"projectName":"xxxxxx"}）就会报错

let dbSource3={
"project":[
{"projectName":"公司本部"},
// {"projectName":"重庆分公司"},
// {"projectName":"湖北分公司"},
// {"projectName":"贵州分公司"},
// {"projectName": "云南分公司"},
// {"projectName":"跨境经营中心"},
// {"projectName":"贵阳地铁3号线"},
// {"projectName":"昆倘指挥部"},
// {"projectName":"总部大厦"},
// {"projectName":"东格高速"},
// {"projectName": "玉楚项目公司"},
// {"projectName": "宜昌指挥部"}
]
}

复制代码

Richard.Ma · Richard.Ma

本帖最后由 Richard.Ma 于 2022-12-23 11:19 编辑

我看到你发的js中代码挺全的，执行了一下并没有发现你说的错误
目前这边测试用的是官网的在线表格编辑器demo，版本15.2.2

不知道你那边是不是用的更早的版本

这个是设置数据源后的截图
image.png733224487.png

热点科技 · 热点科技

Richard.Ma 发表于 2022-12-23 11:18
我看到你发的js中代码挺全的，执行了一下并没有发现你说的错误
目前这边测试用的是官网的在线表格编辑器de ...

let dbSource3={
"project":[
{"projectName":"公司本部"},
{"projectName":"重庆分公司"},
{"projectName":"湖北分公司"},
{"projectName":"贵州分公司"},
{"projectName": "云南分公司"},
{"projectName":"跨境经营中心"},
{"projectName":"贵阳地铁3号线"},
{"projectName":"昆倘指挥部"},
{"projectName":"总部大厦"},
{"projectName":"东格高速"},
{"projectName": "玉楚项目公司"},
{"projectName": "宜昌指挥部"}
]
}

复制代码

用这个代码试一下就会报错了

Richard.Ma · Richard.Ma

本帖最后由 Richard.Ma 于 2022-12-26 11:06 编辑

好的，问题可以重现，问题的原因是sheet的行数不够，导致绑定后，汇总行就超出了，这个也是提示的“因为它会导致某些非空单元格移出工作表”原因

解决办法也简单，在绑定数据前，设置下面的代码

table1.expandBoundRows(true);

复制代码

这样在绑定数据时如果行不够的话，会自动扩展

		自动登录	找回密码
密码			立即注册

[已处理] 【SpreadJS】出现无法插入新的单元格报错

6 个回复

SpreadJS 认证

SpreadJS 高级认证

讲师达人

悬赏达人