找回密码
 立即注册

QQ登录

只需一步,快速开始

远光软件

初级会员

47

主题

119

帖子

378

积分

初级会员

积分
378

活字格认证

远光软件
初级会员   /  发表于:2017-3-22 16:04  /   查看:7198  /  回复:14
在javascript中设置printInfo:printInfo.showBorder(true),printInfo.showGridLine(true),然后再调用SpreadJS的dll生成pdf,showBorder有效果,而gridLine的表格最后一行的加粗无效果,请帮忙解决一下。


1.jpg
2.jpg

14 个回复

倒序浏览
dexteryao讲师达人认证 悬赏达人认证 SpreadJS 开发认证
超级版主   /  发表于:2017-3-22 17:10:31
沙发
可否将您您spread导出个JSON,方便我这里重现问题。
回复 使用道具 举报
远光软件
初级会员   /  发表于:2017-3-22 17:27:33
板凳
{"version":"9.40.20153.0",sheets:{"":{"name":"附加项目13","selections":{"0":{"row":6,"rowCount":1,"col":4,"colCount":1}},"defaults":{"rowHeight":19,"colWidth":64,"colHeaderRowHeight":20,"rowHeaderColWidth":40},"columns":[{"size":0},{"size":215},{"size":42},{"size":142},{"size":142},{"size":73},{"size":74},{"size":73},{"size":73},{"size":73},{"size":73},{"size":73},{"size":73},{"size":73},{"size":73},{"size":73},{"size":73},{"size":73},{"size":73},{"size":73}],"rows":[{"size":4},{"size":41.609375},{"size":24},{"size":24},{"size":24},{"size":24},{"size":24},{"size":24},{"size":24},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19},{"size":19}],"rowCount":58,"columnCount":20,"comments":[{"text":"双击可打开附加项目数据","width":270,"locked":false,"padding":{"left":1,"top":1,"right":1,"bottom":1},"zIndex":893,"rowIndex":8,"colIndex":1},{"text":"运算公式1 : .(目录二_2,年末数_4)\r\n","width":270,"locked":false,"padding":{"left":1,"top":1,"right":1,"bottom":1},"zIndex":894,"rowIndex":5,"colIndex":4},{"text":"运算公式1 : .(附加项目_4,年末数_4)\r\n","width":270,"locked":false,"padding":{"left":1,"top":1,"right":1,"bottom":1},"zIndex":895,"rowIndex":8,"colIndex":3},{"text":"运算公式1 : .(目录二_2,年末数_4)\r\n","width":270,"locked":false,"padding":{"left":1,"top":1,"right":1,"bottom":1},"zIndex":896,"rowIndex":6,"colIndex":3},{"text":"运算公式1 : .(目录三_3,年末数_4)\r\n","width":270,"locked":false,"padding":{"left":1,"top":1,"right":1,"bottom":1},"zIndex":897,"rowIndex":7,"colIndex":3},{"text":"运算公式1 : .(目录一_1,年末数_4)\r\n","width":270,"locked":false,"padding":{"left":1,"top":1,"right":1,"bottom":1},"zIndex":898,"rowIndex":5,"colIndex":3}],"spans":[{"row":3,"rowCount":1,"col":2,"colCount":2},{"row":1,"rowCount":1,"col":1,"colCount":4}],"activeRow":6,"activeCol":4,"gridline":{"color":"rgba(208,215,229,1)","showVerticalGridline":false,"showHorizontalGridline":false},"allowCellOverflow":true,"theme":{"themeColor":{"background1":{},"background2":{},"text1":{"a":0,"r":0,"g":0,"b":0},"text2":{"a":0,"r":0,"g":0,"b":0},"accent1":{},"accent2":{},"accent3":{},"accent4":{},"accent5":{},"accent6":{},"hyperlink":{"a":0,"r":0,"g":0,"b":0},"followedHyperlink":{"a":0,"r":0,"g":0,"b":0}},"headingFont":"Calibri Light"},"isProtected":true,"protectionOption":{"allowResizeRows":true,"allowResizeColumns":true,"allowSelectLockedCells":true},"rowHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"colHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"data":{"dataTable":{"0":{"0":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"16px SimSun","locked":false,"wordWrap":false,"name":"__builtInStyle62"}},"1":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"16px SimSun","locked":true,"wordWrap":false}},"2":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"16px SimSun","locked":true,"wordWrap":false}},"3":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"16px SimSun","locked":true,"wordWrap":false}},"4":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"16px SimSun","locked":true,"wordWrap":false}},"5":{"style":"__builtInStyle62"},"6":{"style":"__builtInStyle62"},"7":{"style":"__builtInStyle62"},"8":{"style":"__builtInStyle62"},"9":{"style":"__builtInStyle62"},"10":{"style":"__builtInStyle62"},"11":{"style":"__builtInStyle62"},"12":{"style":"__builtInStyle62"},"13":{"style":"__builtInStyle62"},"14":{"style":"__builtInStyle62"},"15":{"style":"__builtInStyle62"},"16":{"style":"__builtInStyle62"},"17":{"style":"__builtInStyle62"},"18":{"style":"__builtInStyle62"},"19":{"style":"__builtInStyle62"}},"1":{"0":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"16px SimSun","locked":false,"wordWrap":false,"name":"__builtInStyle62"}},"1":{"value":"附加项目13","style":{"foreColor":"black","hAlign":1,"vAlign":1,"font":"bold 24px SimSun","formatter":"@","locked":true,"wordWrap":false,"name":"__builtInStyle85"}},"2":{"style":{"foreColor":"black","hAlign":1,"vAlign":1,"font":"bold 24px SimSun","formatter":"@","locked":true,"wordWrap":false,"name":"__builtInStyle86"}},"3":{"style":{"foreColor":"black","hAlign":1,"vAlign":1,"font":"bold 24px SimSun","formatter":"@","locked":true,"wordWrap":false,"name":"__builtInStyle86"}},"4":{"style":{"foreColor":"black","hAlign":1,"vAlign":1,"font":"bold 24px SimSun","formatter":"@","locked":true,"wordWrap":false,"name":"__builtInStyle86"}},"5":{"style":"__builtInStyle62"},"6":{"style":"__builtInStyle63"},"7":{"style":"__builtInStyle62"},"8":{"style":"__builtInStyle62"},"9":{"style":"__builtInStyle62"},"10":{"style":"__builtInStyle62"},"11":{"style":"__builtInStyle62"},"12":{"style":"__builtInStyle62"},"13":{"style":"__builtInStyle62"},"14":{"style":"__builtInStyle62"},"15":{"style":"__builtInStyle62"},"16":{"style":"__builtInStyle62"},"17":{"style":"__builtInStyle62"},"18":{"style":"__builtInStyle62"},"19":{"style":"__builtInStyle62"}},"2":{"0":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"16px SimSun","locked":false,"wordWrap":false,"name":"__builtInStyle62"}},"1":{"style":{"foreColor":"black","hAlign":3,"vAlign":2,"font":"15px SimSun","formatter":"@","locked":true,"wordWrap":false,"name":"__builtInStyle64"}},"2":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"15px SimSun","formatter":"@","locked":true,"wordWrap":false,"name":"__builtInStyle65"}},"3":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"15px SimSun","formatter":"@","locked":true,"wordWrap":false,"name":"__builtInStyle65"}},"4":{"value":"01表","style":{"foreColor":"black","hAlign":2,"vAlign":1,"font":"15px SimSun","formatter":"@","locked":true,"wordWrap":false,"name":"__builtInStyle66"}},"5":{"style":"__builtInStyle62"},"6":{"style":"__builtInStyle63"},"7":{"style":"__builtInStyle62"},"8":{"style":"__builtInStyle62"},"9":{"style":"__builtInStyle62"},"10":{"style":"__builtInStyle62"},"11":{"style":"__builtInStyle62"},"12":{"style":"__builtInStyle62"},"13":{"style":"__builtInStyle62"},"14":{"style":"__builtInStyle62"},"15":{"style":"__builtInStyle62"},"16":{"style":"__builtInStyle62"},"17":{"style":"__builtInStyle62"},"18":{"style":"__builtInStyle62"},"19":{"style":"__builtInStyle62"}},"3":{"0":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"16px SimSun","locked":false,"wordWrap":false,"name":"__builtInStyle62"}},"1":{"value":"编制单位:广西电网有限责任公司","style":{"foreColor":"black","hAlign":0,"vAlign":1,"font":"13px SimSun","formatter":"@","locked":true,"wordWrap":false,"name":"__builtInStyle67"}},"2":{"value":"2017年02月28日","style":{"foreColor":"black","hAlign":1,"vAlign":1,"font":"13px SimSun","formatter":"@","locked":true,"wordWrap":false,"name":"__builtInStyle87"}},"3":{"style":{"foreColor":"black","hAlign":0,"vAlign":1,"font":"15px SimSun","formatter":"@","locked":true,"wordWrap":false,"name":"__builtInStyle88"}},"4":{"value":"单位:元","style":{"foreColor":"black","hAlign":2,"vAlign":1,"font":"13px SimSun","formatter":"@","locked":true,"wordWrap":false,"name":"__builtInStyle66"}},"5":{"style":"__builtInStyle62"},"6":{"style":"__builtInStyle63"},"7":{"style":"__builtInStyle62"},"8":{"style":"__builtInStyle62"},"9":{"style":"__builtInStyle62"},"10":{"style":"__builtInStyle62"},"11":{"style":"__builtInStyle62"},"12":{"style":"__builtInStyle62"},"13":{"style":"__builtInStyle62"},"14":{"style":"__builtInStyle62"},"15":{"style":"__builtInStyle62"},"16":{"style":"__builtInStyle62"},"17":{"style":"__builtInStyle62"},"18":{"style":"__builtInStyle62"},"19":{"style":"__builtInStyle62"}},"4":{"0":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"16px SimSun","locked":false,"wordWrap":false,"name":"__builtInStyle62"}},"1":{"value":"项目","style":{"foreColor":"black","hAlign":1,"vAlign":1,"font":"15px SimSun","formatter":"@","locked":true,"wordWrap":false,"name":"__builtInStyle68","borderTop":{"color":"#000000","style":2},"borderBottom":{"color":"#000000","style":1}}},"2":{"value":"行次","style":{"foreColor":"black","hAlign":1,"vAlign":1,"font":"15px SimSun","formatter":"@","locked":true,"wordWrap":false,"name":"__builtInStyle68","borderLeft":{"color":"Text 1","style":1},"borderRight":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":2},"borderBottom":{"color":"#000000","style":1}}},"3":{"value":"年初数","style":{"foreColor":"black","hAlign":1,"vAlign":1,"font":"15px SimSun","formatter":"@","locked":true,"wordWrap":false,"name":"__builtInStyle68","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":2},"borderBottom":{"color":"#000000","style":1}}},"4":{"value":"年末数","style":{"foreColor":"black","hAlign":1,"vAlign":1,"font":"15px SimSun","formatter":"@","locked":true,"wordWrap":false,"name":"__builtInStyle69","borderLeft":{"color":"Text 1","style":1},"borderTop":{"color":"#000000","style":2},"borderBottom":{"color":"#000000","style":1}}},"5":{"style":"__builtInStyle62"},"6":{"style":{"foreColor":"#000000","hAlign":3,"vAlign":1,"font":"13px 'Times New Roman'","formatter":"@","locked":false,"wordWrap":false,"name":"__builtInStyle70"}},"7":{"style":"__builtInStyle62"},"8":{"style":"__builtInStyle62"},"9":{"style":"__builtInStyle62"},"10":{"style":"__builtInStyle62"},"11":{"style":"__builtInStyle62"},"12":{"style":"__builtInStyle62"},"13":{"style":"__builtInStyle62"},"14":{"style":"__builtInStyle62"},"15":{"style":"__builtInStyle62"},"16":{"style":"__builtInStyle62"},"17":{"style":"__builtInStyle62"},"18":{"style":"__builtInStyle62"},"19":{"style":"__builtInStyle62"}},"5":{"0":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"16px SimSun","locked":false,"wordWrap":false,"name":"__builtInStyle62"}},"1":{"value":"目录一","style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"15px SimSun","formatter":"@","locked":true,"wordWrap":false,"name":"__builtInStyle71","borderBottom":{"color":"#000000","style":1}},"tag":{"cellId":"c00001","cellDataVO":{"flagGather":0,"flagAddItemSumCell":false,"addItemSummethod":0,"readOnly":true,"row":1,"column":1,"cellId":"c00001","cellType":"I","len":0,"rec":0,"modelState":1},"flagAddItem":false,"modelState":1}},"2":{"value":1,"style":{"foreColor":"black","hAlign":1,"vAlign":1,"font":"15px SimSun","formatter":"0","locked":true,"wordWrap":false,"name":"__builtInStyle72","borderLeft":{"color":"Text 1","style":1},"borderRight":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1}},"tag":{"cellId":"c00002","cellDataVO":{"flagGather":0,"flagAddItemSumCell":false,"addItemSummethod":0,"readOnly":true,"row":1,"column":2,"cellId":"c00002","cellType":"R","len":0,"rec":0,"modelState":1},"flagAddItem":false,"modelState":1}},"3":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"15px SimSun","formatter":{"customerCultureName":"zh-CN","formatCached":"#,##0.00;-#,##0.00"},"locked":true,"wordWrap":false,"name":"__builtInStyle73","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1}},"tag":{"cellId":"c00003","cellDataVO":{"flagGather":0,"flagAddItemSumCell":false,"addItemSummethod":0,"readOnly":true,"row":1,"column":3,"cellId":"c00003","cellType":"N","displayInfo":"千分符=T,小数位数=2","len":21,"rec":2,"modelState":1},"flagAddItem":false,"modelState":1,"cellFormulaVO":{"jcls":"com.ygsoft.gris.statementmanage.spreadjs.service.model.formula.CellFormulaVO","cellId":"c00003","col":3,"color":"#FFFF80","computeType":0,"dispConditions":[""],"dispFormulas":[".(目录一_1,年末数_4)"],"editable":false,"flagParent":false,"formulaId":["B9D19375_5556_51B0_1A4F_992EB8CDD1AAAA"],"formulaType":1,"modelState":1,"range":"1","row":5,"__dynamic":1}}},"4":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"15px SimSun","formatter":{"customerCultureName":"zh-CN","formatCached":"#,##0.00;-#,##0.00"},"locked":true,"wordWrap":false,"name":"__builtInStyle74","borderLeft":{"color":"Text 1","style":1},"borderTop":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1}},"tag":{"cellId":"c00004","cellDataVO":{"flagGather":0,"flagAddItemSumCell":false,"addItemSummethod":0,"readOnly":true,"row":1,"column":4,"cellId":"c00004","cellType":"N","displayInfo":"千分符=T,小数位数=2","len":21,"rec":2,"modelState":1},"flagAddItem":false,"modelState":1,"cellFormulaVO":{"jcls":"com.ygsoft.gris.statementmanage.spreadjs.service.model.formula.CellFormulaVO","cellId":"c00004","col":4,"color":"#FFFF80","computeType":0,"dispConditions":[""],"dispFormulas":[".(目录二_2,年末数_4)"],"editable":false,"flagParent":false,"formulaId":["ED72688A_E29B_B05E_D87C_EEB2B72D797AAA"],"formulaType":1,"modelState":1,"range":"1","row":5,"__dynamic":1}}},"5":{"style":"__builtInStyle62"},"6":{"style":"__builtInStyle63"},"7":{"style":"__builtInStyle62"},"8":{"style":"__builtInStyle62"},"9":{"style":"__builtInStyle62"},"10":{"style":"__builtInStyle62"},"11":{"style":"__builtInStyle62"},"12":{"style":"__builtInStyle62"},"13":{"style":"__builtInStyle62"},"14":{"style":"__builtInStyle62"},"15":{"style":"__builtInStyle62"},"16":{"style":"__builtInStyle62"},"17":{"style":"__builtInStyle62"},"18":{"style":"__builtInStyle62"},"19":{"style":"__builtInStyle62"}},"6":{"0":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"16px SimSun","locked":false,"wordWrap":false,"name":"__builtInStyle62"}},"1":{"value":"目录二","style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"15px SimSun","formatter":"@","locked":true,"wordWrap":false,"name":"__builtInStyle71","imeMode":1,"borderBottom":{"color":"#000000","style":1}},"tag":{"cellId":"c00005","cellDataVO":{"flagGather":0,"flagAddItemSumCell":false,"addItemSummethod":0,"readOnly":true,"row":2,"column":1,"cellId":"c00005","cellType":"I","len":0,"rec":0,"modelState":1},"flagAddItem":false,"modelState":1}},"2":{"value":2,"style":{"foreColor":"black","hAlign":1,"vAlign":1,"font":"15px SimSun","formatter":"0","locked":true,"wordWrap":false,"name":"__builtInStyle72","imeMode":1,"borderLeft":{"color":"Text 1","style":1},"borderRight":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1}},"tag":{"cellId":"c00006","cellDataVO":{"flagGather":0,"flagAddItemSumCell":false,"addItemSummethod":0,"readOnly":true,"row":2,"column":2,"cellId":"c00006","cellType":"R","len":0,"rec":0,"modelState":1},"flagAddItem":false,"modelState":1}},"3":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"15px SimSun","formatter":{"customerCultureName":"zh-CN","formatCached":"#,##0.00;-#,##0.00"},"locked":true,"wordWrap":false,"name":"__builtInStyle73","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1}},"tag":{"cellId":"c00007","cellDataVO":{"flagGather":0,"flagAddItemSumCell":false,"addItemSummethod":0,"readOnly":true,"row":2,"column":3,"cellId":"c00007","cellType":"N","displayInfo":"千分符=T,小数位数=2","len":21,"rec":2,"modelState":1},"flagAddItem":false,"modelState":1,"cellFormulaVO":{"jcls":"com.ygsoft.gris.statementmanage.spreadjs.service.model.formula.CellFormulaVO","cellId":"c00007","col":3,"color":"#FFFF80","computeType":0,"dispConditions":[""],"dispFormulas":[".(目录二_2,年末数_4)"],"editable":false,"flagParent":false,"formulaId":["4C27FA4B_DC6F_9369_3B1E_C205C45609AAAA"],"formulaType":1,"modelState":1,"range":"1","row":6,"__dynamic":1}}},"4":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"15px SimSun","formatter":{"customerCultureName":"zh-CN","formatCached":"#,##0.00;-#,##0.00"},"locked":true,"wordWrap":false,"name":"__builtInStyle74","borderLeft":{"color":"Text 1","style":1},"borderTop":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1}},"tag":{"cellId":"c00008","cellDataVO":{"flagGather":0,"flagAddItemSumCell":false,"addItemSummethod":0,"readOnly":true,"row":2,"column":4,"cellId":"c00008","cellType":"N","displayInfo":"千分符=T,小数位数=2","len":21,"rec":2,"modelState":1},"flagAddItem":false,"modelState":1}},"5":{"style":"__builtInStyle62"},"6":{"style":"__builtInStyle63"},"7":{"style":"__builtInStyle62"},"8":{"style":"__builtInStyle62"},"9":{"style":"__builtInStyle62"},"10":{"style":"__builtInStyle62"},"11":{"style":"__builtInStyle62"},"12":{"style":"__builtInStyle62"},"13":{"style":"__builtInStyle62"},"14":{"style":"__builtInStyle62"},"15":{"style":"__builtInStyle62"},"16":{"style":"__builtInStyle62"},"17":{"style":"__builtInStyle62"},"18":{"style":"__builtInStyle62"},"19":{"style":"__builtInStyle62"}},"7":{"0":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"16px SimSun","locked":false,"wordWrap":false,"name":"__builtInStyle62"}},"1":{"value":"目录三","style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"15px SimSun","formatter":"@","locked":true,"wordWrap":false,"name":"__builtInStyle71","imeMode":1},"tag":{"cellId":"c00053","cellDataVO":{"flagGather":0,"flagAddItemSumCell":false,"addItemSummethod":0,"readOnly":true,"row":3,"column":1,"cellId":"c00053","cellType":"I","len":0,"rec":0,"modelState":1},"flagAddItem":false,"modelState":1}},"2":{"value":3,"style":{"foreColor":"black","hAlign":1,"vAlign":1,"font":"15px SimSun","formatter":"0","locked":true,"wordWrap":false,"name":"__builtInStyle72","imeMode":1,"borderLeft":{"color":"Text 1","style":1},"borderRight":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1}},"tag":{"cellId":"c00054","cellDataVO":{"flagGather":0,"flagAddItemSumCell":false,"addItemSummethod":0,"readOnly":true,"row":3,"column":2,"cellId":"c00054","cellType":"R","len":0,"rec":0,"modelState":1},"flagAddItem":false,"modelState":1}},"3":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"15px SimSun","formatter":{"customerCultureName":"zh-CN","formatCached":"#,##0.00;-#,##0.00"},"locked":true,"wordWrap":false,"name":"__builtInStyle73","borderLeft":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":1}},"tag":{"cellId":"c00055","cellDataVO":{"flagGather":0,"flagAddItemSumCell":false,"addItemSummethod":0,"readOnly":true,"row":3,"column":3,"cellId":"c00055","cellType":"N","displayInfo":"千分符=T,小数位数=2","len":21,"rec":2,"modelState":1},"flagAddItem":false,"modelState":1,"cellFormulaVO":{"jcls":"com.ygsoft.gris.statementmanage.spreadjs.service.model.formula.CellFormulaVO","cellId":"c00055","col":3,"color":"#FFFF80","computeType":0,"dispConditions":[""],"dispFormulas":[".(目录三_3,年末数_4)"],"editable":false,"flagParent":false,"formulaId":["49C4BC29_2989_FC11_FE2F_4EE6C6BBAAAAAA"],"formulaType":1,"modelState":1,"range":"1","row":7,"__dynamic":1}}},"4":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"15px SimSun","formatter":{"customerCultureName":"zh-CN","formatCached":"#,##0.00;-#,##0.00"},"locked":true,"wordWrap":false,"name":"__builtInStyle74","borderLeft":{"color":"Text 1","style":1},"borderTop":{"color":"#000000","style":1}},"tag":{"cellId":"c00056","cellDataVO":{"flagGather":0,"flagAddItemSumCell":false,"addItemSummethod":0,"readOnly":true,"row":3,"column":4,"cellId":"c00056","cellType":"N","displayInfo":"千分符=T,小数位数=2","len":21,"rec":2,"modelState":1},"flagAddItem":false,"modelState":1}},"5":{"style":"__builtInStyle62"},"6":{"style":"__builtInStyle62"},"7":{"style":"__builtInStyle62"},"8":{"style":"__builtInStyle62"},"9":{"style":"__builtInStyle62"},"10":{"style":"__builtInStyle62"},"11":{"style":"__builtInStyle62"},"12":{"style":"__builtInStyle62"},"13":{"style":"__builtInStyle62"},"14":{"style":"__builtInStyle62"},"15":{"style":"__builtInStyle62"},"16":{"style":"__builtInStyle62"},"17":{"style":"__builtInStyle62"},"18":{"style":"__builtInStyle62"},"19":{"style":"__builtInStyle62"}},"8":{"0":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"16px SimSun","locked":false,"wordWrap":false,"name":"__builtInStyle62"}},"1":{"value":"附加项目","style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"15px SimSun","formatter":"@","locked":true,"wordWrap":false,"name":"__builtInStyle71","imeMode":1,"borderLeft":{"color":"Text 1"},"borderRight":{"color":"Text 1","style":1},"borderTop":{"color":"Text 1","style":1},"borderBottom":{"color":"Text 1","style":2}},"tag":{"cellId":"c00057","cellDataVO":{"flagGather":0,"flagAddItemSumCell":false,"addItemSummethod":0,"readOnly":true,"row":4,"column":1,"cellId":"c00057","cellType":"I","len":0,"rec":0,"modelState":1},"flagAddItem":true,"modelState":1}},"2":{"value":4,"style":{"foreColor":"black","hAlign":1,"vAlign":1,"font":"15px SimSun","formatter":"0","locked":true,"wordWrap":false,"name":"__builtInStyle72","imeMode":1,"borderLeft":{"color":"Text 1","style":1},"borderRight":{"color":"Text 1","style":1},"borderTop":{"color":"Text 1","style":1},"borderBottom":{"color":"Text 1","style":2}},"tag":{"cellId":"c00058","cellDataVO":{"flagGather":0,"flagAddItemSumCell":false,"addItemSummethod":0,"readOnly":true,"row":4,"column":2,"cellId":"c00058","cellType":"R","len":0,"rec":0,"modelState":1},"flagAddItem":false,"modelState":1}},"3":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"15px SimSun","formatter":{"customerCultureName":"zh-CN","formatCached":"#,##0.00;-#,##0.00"},"locked":true,"wordWrap":false,"name":"__builtInStyle78","borderLeft":{"color":"Text 1","style":1},"borderRight":{"color":"Text 1","style":1},"borderTop":{"color":"Text 1","style":1},"borderBottom":{"color":"Text 1","style":2}},"tag":{"cellId":"c00059","cellDataVO":{"flagGather":0,"flagAddItemSumCell":true,"addItemSummethod":1,"readOnly":true,"row":4,"column":3,"cellId":"c00059","cellType":"N","displayInfo":"千分符=T,小数位数=2","len":21,"rec":2,"modelState":1},"flagAddItem":false,"modelState":1,"cellFormulaVO":{"jcls":"com.ygsoft.gris.statementmanage.spreadjs.service.model.formula.CellFormulaVO","cellId":"c00059","col":3,"color":"#FFFF80","computeType":0,"dispConditions":[""],"dispFormulas":[".(附加项目_4,年末数_4)"],"editable":false,"flagParent":false,"formulaId":["4E98E3E3_AFB5_A716_6AE1_AF64CC9218BAAA"],"formulaType":1,"modelState":1,"range":"1","row":8,"__dynamic":1}}},"4":{"style":{"foreColor":"black","hAlign":3,"vAlign":1,"font":"15px SimSun","formatter":{"customerCultureName":"zh-CN","formatCached":"#,##0.00;-#,##0.00"},"locked":true,"wordWrap":false,"name":"__builtInStyle79","borderLeft":{"color":"Text 1","style":1},"borderRight":{"color":"Text 1"},"borderTop":{"color":"Text 1","style":1},"borderBottom":{"color":"Text 1","style":2}},"tag":{"cellId":"c00060","cellDataVO":{"flagGather":0,"flagAddItemSumCell":true,"addItemSummethod":1,"readOnly":true,"row":4,"column":4,"cellId":"c00060","cellType":"N","displayInfo":"千分符=T,小数位数=2","len":21,"rec":2,"modelState":1},"flagAddItem":false,"modelState":1}},"5":{"style":{"foreColor":"#000000","hAlign":3,"vAlign":1,"font":"16px SimSun","locked":false,"wordWrap":false,"name":"__builtInStyle62"}},"6":{"style":"__builtInStyle62"},"7":{"style":"__builtInStyle62"},"8":{"style":"__builtInStyle62"},"9":{"style":"__builtInStyle62"},"10":{"style":"__builtInStyle62"},"11":{"style":"__builtInStyle62"},"12":{"style":"__builtInStyle62"},"13":{"style":"__builtInStyle62"},"14":{"style":"__builtInStyle62"},"15":{"style":"__builtInStyle62"},"16":{"style":"__builtInStyle62"},"17":{"style":"__builtInStyle62"},"18":{"style":"__builtInStyle62"},"19":{"style":"__builtInStyle62"}},"9":{"0":{"style":"__builtInStyle62"},"1":{"style":{"foreColor":"#000000","hAlign":0,"vAlign":1,"font":"12px SimSun","formatter":"#,##0","locked":false,"wordWrap":false,"name":"__builtInStyle80"}},"2":{"style":{"foreColor":"#000000","hAlign":0,"vAlign":1,"font":"12px SimSun","formatter":"#,##0","locked":false,"wordWrap":false,"name":"__builtInStyle80"}},"3":{"style":{"foreColor":"#000000","hAlign":0,"vAlign":1,"font":"12px SimSun","formatter":"#,##0","locked":false,"wordWrap":false,"name":"__builtInStyle80"}},"4":{"style":{"foreColor":"#000000","hAlign":0,"vAlign":1,"font":"12px SimSun","formatter":"#,##0","locked":false,"wordWrap":false,"name":"__builtInStyle80"}},"5":{"style":"__builtInStyle62"},"6":{"style":"__builtInStyle62"},"7":{"style":"__builtInStyle62"},"8":{"style":"__builtInStyle62"},"9":{"style":"__builtInStyle62"},"10":{"style":"__builtInStyle62"},"11":{"style":"__builtInStyle62"},"12":{"style":"__builtInStyle62"},"13":{"style":"__builtInStyle62"},"14":{"style":"__builtInStyle62"},"15":{"style":"__builtInStyle62"},"16":{"style":"__builtInStyle62"},"17":{"style":"__builtInStyle62"},"18":{"style":"__builtInStyle62"},"19":{"style":"__builtInStyle62"}},"10":{"0":{"style":"__builtInStyle62"},"1":{"style":"__builtInStyle81"},"2":{"style":"__builtInStyle81"},"3":{"style":"__builtInStyle81"},"4":{"style":"__builtInStyle81"},"5":{"style":"__builtInStyle62"},"6":{"style":"__builtInStyle62"},"7":{"style":"__builtInStyle62"},"8":{"style":"__builtInStyle62"},"9":{"style":"__builtInStyle62"},"10":{"style":"__builtInStyle62"},"11":{"style":"__builtInStyle62"},"12":{"style":"__builtInStyle62"},"13":{"style":"__builtInStyle62"},"14":{"style":"__builtInStyle62"},"15":{"style":"__builtInStyle62"},"16":{"style":"__builtInStyle62"},"17":{"style":"__builtInStyle62"},"18":{"style":"__builtInStyle62"},"19":{"style":"__builtInStyle62"}},"11":{"0":{"style":"__builtInStyle62"},"1":{"style":"__builtInStyle81"},"2":{"style":"__builtInStyle81"},"3":{"style":"__builtInStyle81"},"4":{"style":"__builtInStyle81"},"5":{"style":"__builtInStyle62"},"6":{"style":"__builtInStyle62"},"7":{"style":"__builtInStyle62"},"8":{"style":"__builtInStyle62"},"9":{"style":"__builtInStyle62"},"10":{"style":"__builtInStyle62"},"11":{"style":"__builtInStyle62"},"12":{"style":"__builtInStyle62"},"13":{"style":"__builtInStyle62"},"14":{"style":"__builtInStyle62"},"15":{"style":"__builtInStyle62"},"16":{"style":"__builtInStyle62"},"17":{"style":"__builtInStyle62"},"18":{"style":"__builtInStyle62"},"19":{"style":"__builtInStyle62"}},"12":{"0":{"style":"__builtInStyle62"},"1":{"style":"__builtInStyle81"},"2":{"style":"__builtInStyle81"},"3":{"style":"__builtInStyle81"},"4":{"style":"__builtInStyle81"},"5":{"style":"__builtInStyle62"},"6":{"style":"__builtInStyle62"},"7":{"style":"__builtInStyle62"},"8":{"style":"__builtInStyle62"},"9":{"style":"__builtInStyle62"},"10":{"style":"__builtInStyle62"},"11":{"style":"__builtInStyle62"},"12":{"style":"__builtInStyle62"},"13":{"style":"__builtInStyle62"},"14":{"style":"__builtInStyle62"},"15":{"style":"__builtInStyle62"},"16":{"style":"__builtInStyle62"},"17":{"style":"__builtInStyle62"},"18":{"style":"__builtInStyle62"},"19":{"style":"__builtInStyle62"}},"13":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"14":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"15":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"16":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"17":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"18":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"19":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"20":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"21":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"22":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"23":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"24":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"25":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"26":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"27":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"28":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"29":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"30":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"31":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"32":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"33":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"34":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"35":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"36":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle82"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"37":{"1":{"style":"__builtInStyle82"},"2":{"style":"__builtInStyle83"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"38":{"1":{"style":"__builtInStyle83"},"2":{"style":"__builtInStyle83"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"39":{"1":{"style":"__builtInStyle83"},"2":{"style":"__builtInStyle83"},"3":{"style":"__builtInStyle82"},"4":{"style":"__builtInStyle82"}},"40":{"1":{"style":"__builtInStyle83"},"2":{"style":"__builtInStyle83"},"3":{"style":"__builtInStyle83"},"4":{"style":"__builtInStyle83"}},"41":{"1":{"style":"__builtInStyle83"},"2":{"style":"__builtInStyle83"},"3":{"style":"__builtInStyle83"},"4":{"style":"__builtInStyle83"}},"42":{"1":{"style":"__builtInStyle83"},"2":{"style":"__builtInStyle83"},"3":{"style":"__builtInStyle83"},"4":{"style":"__builtInStyle83"}},"43":{"1":{"style":"__builtInStyle83"},"2":{"style":"__builtInStyle83"},"3":{"style":"__builtInStyle83"},"4":{"style":"__builtInStyle83"}},"44":{"1":{"style":"__builtInStyle83"},"2":{"style":"__builtInStyle83"},"3":{"style":"__builtInStyle83"},"4":{"style":"__builtInStyle83"}},"45":{"1":{"style":"__builtInStyle83"},"2":{"style":"__builtInStyle83"},"3":{"style":"__builtInStyle83"},"4":{"style":"__builtInStyle83"}},"46":{"1":{"style":"__builtInStyle83"},"2":{"style":"__builtInStyle83"},"3":{"style":"__builtInStyle83"},"4":{"style":"__builtInStyle83"}},"47":{"1":{"style":"__builtInStyle83"},"2":{"style":"__builtInStyle83"},"3":{"style":"__builtInStyle83"},"4":{"style":"__builtInStyle83"}},"48":{"1":{"style":"__builtInStyle83"},"2":{"style":"__builtInStyle83"},"3":{"style":"__builtInStyle83"},"4":{"style":"__builtInStyle83"}},"49":{"1":{"style":"__builtInStyle83"},"2":{"style":"__builtInStyle83"},"3":{"style":"__builtInStyle83"},"4":{"style":"__builtInStyle83"}},"50":{"1":{"style":"__builtInStyle83"},"2":{"style":"__builtInStyle83"},"3":{"style":"__builtInStyle83"},"4":{"style":"__builtInStyle83"}},"51":{"1":{"style":"__builtInStyle83"},"2":{"style":"__builtInStyle83"},"3":{"style":"__builtInStyle83"},"4":{"style":"__builtInStyle83"}},"52":{"1":{"style":"__builtInStyle83"},"2":{"style":"__builtInStyle83"},"3":{"style":"__builtInStyle83"},"4":{"style":"__builtInStyle83"}},"53":{"1":{"style":"__builtInStyle83"},"2":{"style":"__builtInStyle83"},"3":{"style":"__builtInStyle83"},"4":{"style":"__builtInStyle83"}},"54":{"1":{"style":"__builtInStyle83"},"2":{"style":"__builtInStyle83"},"3":{"style":"__builtInStyle83"},"4":{"style":"__builtInStyle83"}},"55":{"1":{"style":"__builtInStyle83"},"2":{"style":"__builtInStyle83"},"3":{"style":"__builtInStyle83"},"4":{"style":"__builtInStyle83"}},"56":{"2":{"style":"__builtInStyle83"},"3":{"style":"__builtInStyle83"},"4":{"style":"__builtInStyle83"}},"57":{"2":{"style":"__builtInStyle83"},"3":{"style":"__builtInStyle83"},"4":{"style":"__builtInStyle83"}}},"columnDataArray":[{"style":"__builtInStyle84"},{"style":"__builtInStyle84"},{"style":"__builtInStyle84"},{"style":"__builtInStyle84"},{"style":"__builtInStyle84"},{"style":"__builtInStyle84"},{"style":"__builtInStyle84"},{"style":"__builtInStyle84"},{"style":"__builtInStyle84"},{"style":"__builtInStyle84"},{"style":"__builtInStyle84"},{"style":"__builtInStyle84"},{"style":"__builtInStyle84"},{"style":"__builtInStyle84"},{"style":"__builtInStyle84"},{"style":"__builtInStyle84"},{"style":"__builtInStyle84"},{"style":"__builtInStyle84"},{"style":"__builtInStyle84"},{"style":"__builtInStyle84"}],"defaultDataNode":{"style":{"themeFont":"Body","locked":false}}},"tag":{"date":"2017-02-08","readOnly":false,"formatId":996850,"repId":995236,"startRow":5,"startCol":1,"deptName":"广西电网有限责任公司","deptId":2100000751,"endRow":8,"repName":"附加项目13","endCol":4,"designVO":{"maxCellID":60,"repCells":[{"order":1,"itemValue":"目录一","row":1,"column":1,"cellId":"c00001","cellType":"I","isGatther":0,"modelState":1},{"order":2,"itemValue":"1","row":1,"column":2,"cellId":"c00002","cellType":"R","isGatther":0,"modelState":1},{"separator":true,"readOnly":false,"order":3,"row":1,"column":3,"cellId":"c00003","cellType":"N","convertrate":0,"percentage":false,"negativeRed":false,"decimalPlace":2,"isGatther":0,"modelState":1},{"separator":true,"readOnly":false,"order":4,"row":1,"column":4,"cellId":"c00004","cellType":"N","convertrate":0,"percentage":false,"negativeRed":false,"decimalPlace":2,"isGatther":0,"modelState":1},{"order":5,"itemValue":"目录二","row":2,"column":1,"cellId":"c00005","cellType":"I","isGatther":0,"modelState":1},{"order":6,"itemValue":"2","row":2,"column":2,"cellId":"c00006","cellType":"R","isGatther":0,"modelState":1},{"separator":true,"readOnly":false,"order":7,"row":2,"column":3,"cellId":"c00007","cellType":"N","convertrate":0,"percentage":false,"negativeRed":false,"decimalPlace":2,"isGatther":0,"modelState":1},{"separator":true,"readOnly":false,"order":8,"row":2,"column":4,"cellId":"c00008","cellType":"N","convertrate":0,"percentage":false,"negativeRed":false,"decimalPlace":2,"isGatther":0,"modelState":1},{"order":9,"itemValue":"目录三","row":3,"column":1,"cellId":"c00053","cellType":"I","isGatther":0,"modelState":1},{"order":10,"itemValue":"3","row":3,"column":2,"cellId":"c00054","cellType":"R","isGatther":0,"modelState":1},{"separator":true,"readOnly":false,"order":11,"row":3,"column":3,"cellId":"c00055","cellType":"N","convertrate":0,"percentage":false,"negativeRed":false,"decimalPlace":2,"isGatther":0,"modelState":1},{"separator":true,"readOnly":false,"order":12,"row":3,"column":4,"cellId":"c00056","cellType":"N","convertrate":0,"percentage":false,"negativeRed":false,"decimalPlace":2,"isGatther":0,"modelState":1},{"order":13,"itemValue":"附加项目","row":4,"column":1,"cellId":"c00057","cellType":"I","isGatther":0,"modelState":1},{"order":14,"itemValue":"4","row":4,"column":2,"cellId":"c00058","cellType":"R","isGatther":0,"modelState":1},{"separator":true,"readOnly":false,"order":15,"row":4,"column":3,"cellId":"c00059","cellType":"N","convertrate":0,"percentage":false,"negativeRed":false,"decimalPlace":2,"isGatther":0,"modelState":1},{"separator":true,"readOnly":false,"order":16,"row":4,"column":4,"cellId":"c00060","cellType":"N","convertrate":0,"percentage":false,"negativeRed":false,"decimalPlace":2,"isGatther":0,"modelState":1}],"repAdds":[{"cellId":"c00057","printRows":-1,"orderCols":"#1","sumCols":"3,4","gather":0,"multiSum":0,"summethod":1,"rptPrntdt":1,"repPrntrg":1,"modelState":1}],"repColumns":[{"order":1,"column":1,"title":"项目","colId":1,"shortTitle":"B","colType":1,"modelState":1},{"order":2,"column":2,"title":"行次","colId":2,"shortTitle":"C","colType":3,"modelState":1},{"order":3,"column":3,"title":"年初数","colId":3,"shortTitle":"D","colType":5,"modelState":1},{"order":4,"column":4,"title":"年末数","colId":4,"shortTitle":"E","colType":5,"modelState":1}],"repDataStartRow":5,"repDataStartCol":1,"repDataEndRow":8,"repDataEndCol":4,"repHeadStartRow":1,"repHeadEndRow":3,"repHeadStartCol":1,"repHeadEndCol":4,"repColumnStartRow":4,"repColumnEndRow":4,"repColumnStartCol":1,"repColumnEndCol":4,"repElements":[{"sRow":3,"sCol":1,"flagRepDepartElement":true,"modelState":1},{"sRow":3,"sCol":2,"flagRepDateElement":true,"modelState":1},{"sRow":3,"sCol":4,"flagRepUnitElement":true,"modelState":1},{"sRow":1,"sCol":1,"flagRepHeadTitleElement":true,"modelState":1}],"maxColID":4,"modelState":1},"showDate":"2017-02-28","modelState":1},"printInfo":{"columnStart":0,"columnEnd":4,"rowStart":0,"rowEnd":8,"showBorder":false,"showColumnHeader":1,"showRowHeader":1,"centering":1,"firstPageNumber":1,"margin":{"footer":0,"header":0,"left":0,"right":0,"bottom":0,"top":0},"pageOrder":2,"blackAndWhite":true,"paperSize":{"width":826.7716659601717,"height":1169.2913561436715,"kind":9}},"namedStyles":[{"foreColor":"#000000","hAlign":3,"vAlign":2,"font":"normal normal 12px SimSun","formatter":"_ * #,##0_ ;_ * \\-#,##0_ ;_ * \"-\"_ ;_ @_ ","locked":false,"wordWrap":false,"name":"Comma [0]"},{"foreColor":"#000000","hAlign":3,"vAlign":2,"font":"normal normal 12px SimSun","formatter":"_ * #,##0.00_ ;_ * \\-#,##0.00_ ;_ * \"-\"??_ ;_ @_ ","locked":false,"wordWrap":false,"name":"Comma"},{"foreColor":"#000000","hAlign":3,"vAlign":2,"font":"normal normal 12px SimSun","locked":false,"wordWrap":false,"name":"Normal"},{"foreColor":"Text 1 0","font":"normal bold 14.7px calibri","themeFont":"Body","name":"Total","borderTop":{"color":"Accent 1 0","style":1},"borderBottom":{"color":"Accent 1 0","style":6}},{"backColor":"#FFC7CE","foreColor":"#9C0006","font":"normal normal 14.7px calibri","themeFont":"Body","name":"Bad"},{"foreColor":"Text 2 0","font":"normal bold 14.7px calibri","themeFont":"Body","name":"Heading 4"},{"foreColor":"Text 2 0","font":"normal bold 14.7px calibri","themeFont":"Body","name":"Heading 3","borderBottom":{"color":"Accent 1 39","style":2}},{"foreColor":"Text 2 0","font":"normal bold 17.3px calibri","themeFont":"Body","name":"Heading 2","borderBottom":{"color":"Accent 1 49","style":5}},{"backColor":"#F2F2F2","foreColor":"#3F3F3F","font":"normal bold 14.7px calibri","themeFont":"Body","name":"Output","borderLeft":{"color":"#3F3F3F","style":1},"borderRight":{"color":"#3F3F3F","style":1},"borderTop":{"color":"#3F3F3F","style":1},"borderBottom":{"color":"#3F3F3F","style":1}},{"foreColor":"#FF0000","font":"normal normal 14.7px calibri","themeFont":"Body","name":"Warning Text"},{"backColor":"#FFCC99","foreColor":"#3F3F76","font":"normal normal 14.7px calibri","themeFont":"Body","name":"Input","borderLeft":{"color":"#7F7F7F","style":1},"borderRight":{"color":"#7F7F7F","style":1},"borderTop":{"color":"#7F7F7F","style":1},"borderBottom":{"color":"#7F7F7F","style":1}},{"foreColor":"Text 2 0","font":"normal bold 20px calibri","themeFont":"Body","name":"Heading 1","borderBottom":{"color":"Accent 1 0","style":5}},{"foreColor":"Text 2 0","font":"normal bold 24px calibri","themeFont":"Headings","name":"Title"},{"foreColor":"#000000","hAlign":3,"vAlign":2,"font":"normal normal 12px SimSun","formatter":"0%","locked":false,"wordWrap":false,"name":"Percent"},{"backColor":"Accent 6 39","foreColor":"Background 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"60% - Accent6"},{"backColor":"Accent 5 39","foreColor":"Background 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"60% - Accent5"},{"backColor":"Accent 4 39","foreColor":"Background 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"60% - Accent4"},{"backColor":"Accent 3 39","foreColor":"Background 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"60% - Accent3"},{"backColor":"Accent 2 39","foreColor":"Background 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"60% - Accent2"},{"backColor":"Accent 1 39","foreColor":"Background 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"60% - Accent1"},{"backColor":"Accent 6 59","foreColor":"Text 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"40% - Accent6"},{"backColor":"Accent 5 59","foreColor":"Text 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"40% - Accent5"},{"backColor":"Accent 4 59","foreColor":"Text 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"40% - Accent4"},{"backColor":"Accent 3 59","foreColor":"Text 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"40% - Accent3"},{"backColor":"Accent 2 59","foreColor":"Text 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"40% - Accent2"},{"backColor":"Accent 1 59","foreColor":"Text 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"40% - Accent1"},{"backColor":"Accent 6 79","foreColor":"Text 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"20% - Accent6"},{"backColor":"Accent 5 79","foreColor":"Text 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"20% - Accent5"},{"backColor":"Accent 4 79","foreColor":"Text 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"20% - Accent4"},{"backColor":"Accent 3 79","foreColor":"Text 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"20% - Accent3"},{"backColor":"Accent 2 79","foreColor":"Text 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"20% - Accent2"},{"backColor":"Accent 1 79","foreColor":"Text 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"20% - Accent1"},{"backColor":"#C6EFCE","foreColor":"#006100","font":"normal normal 14.7px calibri","themeFont":"Body","name":"Good"},{"foreColor":"#000000","hAlign":3,"vAlign":2,"font":"normal normal 12px SimSun","formatter":"_ \"?\"* #,##0.00_ ;_ \"?\"* \\-#,##0.00_ ;_ \"?\"* \"-\"??_ ;_ @_ ","locked":false,"wordWrap":false,"name":"Currency"},{"foreColor":"#000000","hAlign":3,"vAlign":2,"font":"normal normal 12px SimSun","formatter":"_ \"?\"* #,##0_ ;_ \"?\"* \\-#,##0_ ;_ \"?\"* \"-\"_ ;_ @_ ","locked":false,"wordWrap":false,"name":"Currency [0]"},{"foreColor":"#FA7D00","font":"normal normal 14.7px calibri","themeFont":"Body","name":"Linked Cell","borderBottom":{"color":"#FF8001","style":6}},{"backColor":"#F2F2F2","foreColor":"#FA7D00","font":"normal bold 14.7px calibri","themeFont":"Body","name":"Calculation","borderLeft":{"color":"#7F7F7F","style":1},"borderRight":{"color":"#7F7F7F","style":1},"borderTop":{"color":"#7F7F7F","style":1},"borderBottom":{"color":"#7F7F7F","style":1}},{"backColor":"#A5A5A5","foreColor":"Background 1 0","font":"normal bold 14.7px calibri","themeFont":"Body","name":"Check Cell","borderLeft":{"color":"#3F3F3F","style":6},"borderRight":{"color":"#3F3F3F","style":6},"borderTop":{"color":"#3F3F3F","style":6},"borderBottom":{"color":"#3F3F3F","style":6}},{"backColor":"#FFFFCC","name":"Note","borderLeft":{"color":"#B2B2B2","style":1},"borderRight":{"color":"#B2B2B2","style":1},"borderTop":{"color":"#B2B2B2","style":1},"borderBottom":{"color":"#B2B2B2","style":1}},{"backColor":"#FFEB9C","foreColor":"#9C6500","font":"normal normal 14.7px calibri","themeFont":"Body","name":"Neutral"},{"foreColor":"#7F7F7F","font":"italic normal 14.7px calibri","themeFont":"Body","name":"Explanatory Text"},{"backColor":"Accent 1 0","foreColor":"Background 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"Accent1"},{"backColor":"Accent 2 0","foreColor":"Background 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"Accent2"},{"backColor":"Accent 3 0","foreColor":"Background 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"Accent3"},{"backColor":"Accent 4 0","foreColor":"Background 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"Accent4"},{"backColor":"Accent 5 0","foreColor":"Background 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"Accent5"},{"backColor":"Accent 6 0","foreColor":"Background 1 0","font":"normal normal 14.7px calibri","themeFont":"Body","name":"Accent6"},{"foreColor":"#000000","hAlign":3,"vAlign":0,"font":"normal normal 12px SimSun","locked":false,"wordWrap":false,"name":"__builtInStyle15"},{"foreColor":"#000000","hAlign":3,"vAlign":1,"font":"normal normal 16px SimSun","locked":false,"wordWrap":false,"name":"__builtInStyle62"},{"foreColor":"#000000","hAlign":3,"vAlign":1,"font":"normal normal 16px 'Times New Roman'","locked":false,"wordWrap":false,"name":"__builtInStyle63"},{"foreColor":"#000000","hAlign":3,"vAlign":2,"font":"normal normal 14.7px SimSun","formatter":"#,##0","locked":false,"wordWrap":false,"name":"__builtInStyle64"},{"foreColor":"#000000","hAlign":3,"vAlign":1,"font":"normal normal 14.7px SimSun","locked":false,"wordWrap":false,"name":"__builtInStyle65"},{"foreColor":"#000000","hAlign":2,"vAlign":1,"font":"normal normal 14.7px SimSun","formatter":"#,##0","locked":false,"wordWrap":false,"name":"__builtInStyle66"},{"foreColor":"#000000","hAlign":0,"vAlign":1,"font":"normal normal 14.7px SimSun","locked":false,"wordWrap":false,"name":"__builtInStyle67"},{"backColor":"#0000FF","foreColor":"#FFFFFF","hAlign":1,"vAlign":1,"font":"normal normal 14.7px SimSun","formatter":"#,##0","locked":false,"wordWrap":false,"name":"__builtInStyle68","borderRight":{"color":"#000000","style":1},"borderTop":{"color":"#000000","style":2},"borderBottom":{"color":"#000000","style":1}},{"backColor":"#0000FF","foreColor":"#FFFFFF","hAlign":1,"vAlign":1,"font":"normal normal 14.7px SimSun","formatter":"#,##0","locked":false,"wordWrap":false,"name":"__builtInStyle69","borderTop":{"color":"#000000","style":2},"borderBottom":{"color":"#000000","style":1}},{"foreColor":"#000000","hAlign":3,"vAlign":1,"font":"normal normal 13.3px 'Times New Roman'","formatter":"#,##0","locked":false,"wordWrap":false,"name":"__builtInStyle70"},{"foreColor":"#000000","hAlign":3,"vAlign":1,"font":"normal normal 14.7px SimSun","formatter":"#,##0","locked":false,"wordWrap":false,"name":"__builtInStyle71","borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1}},{"foreColor":"#000000","hAlign":1,"vAlign":1,"font":"normal normal 14.7px SimSun","formatter":"@","locked":false,"wordWrap":false,"name":"__builtInStyle72","borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1}},{"backColor":"#FFFFFF","foreColor":"#000000","hAlign":3,"vAlign":1,"font":"normal normal 14.7px SimSun","formatter":"#,##0.00;(#,##0.00)","locked":false,"wordWrap":false,"name":"__builtInStyle73","borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1}},{"backColor":"#FFFFFF","foreColor":"#000000","hAlign":3,"vAlign":1,"font":"normal normal 14.7px SimSun","formatter":"#,##0.00;(#,##0.00)","locked":false,"wordWrap":false,"name":"__builtInStyle74","borderBottom":{"color":"#000000","style":1}},{"foreColor":"#000000","hAlign":3,"vAlign":1,"font":"normal normal 14.7px 'Times New Roman'","formatter":"#,##0","locked":false,"wordWrap":false,"name":"__builtInStyle75","borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":1}},{"foreColor":"#000000","hAlign":3,"vAlign":1,"font":"normal normal 14.7px SimSun","formatter":"#,##0","locked":false,"wordWrap":false,"name":"__builtInStyle76","borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":2}},{"foreColor":"#000000","hAlign":1,"vAlign":1,"font":"normal normal 14.7px SimSun","formatter":"@","locked":false,"wordWrap":false,"name":"__builtInStyle77","borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":2}},{"backColor":"#FFFFFF","foreColor":"#000000","hAlign":3,"vAlign":1,"font":"normal normal 14.7px SimSun","formatter":"#,##0.00;(#,##0.00)","locked":false,"wordWrap":false,"name":"__builtInStyle78","borderRight":{"color":"#000000","style":1},"borderBottom":{"color":"#000000","style":2}},{"backColor":"#FFFFFF","foreColor":"#000000","hAlign":3,"vAlign":1,"font":"normal normal 14.7px SimSun","formatter":"#,##0.00;(#,##0.00)","locked":false,"wordWrap":false,"name":"__builtInStyle79","borderBottom":{"color":"#000000","style":2}},{"foreColor":"#000000","hAlign":0,"vAlign":1,"font":"normal normal 10.7px SimSun","formatter":"#,##0","locked":false,"wordWrap":false,"name":"__builtInStyle80"},{"foreColor":"#000000","hAlign":0,"vAlign":1,"font":"normal normal 10.7px SimSun","locked":false,"wordWrap":false,"name":"__builtInStyle81"},{"foreColor":"#000000","hAlign":0,"vAlign":1,"font":"normal normal 10.7px SimSun","formatter":"#,##0","locked":true,"wordWrap":false,"name":"__builtInStyle82"},{"foreColor":"#000000","hAlign":0,"vAlign":1,"font":"normal normal 16px SimSun","formatter":"#,##0","locked":true,"wordWrap":false,"name":"__builtInStyle83"},{"foreColor":"#000000","hAlign":3,"vAlign":1,"font":"normal normal 16px SimSun","locked":true,"wordWrap":false,"name":"__builtInStyle84"},{"foreColor":"#000000","hAlign":1,"vAlign":1,"font":"normal bold 24px SimSun","formatter":"@","locked":false,"wordWrap":false,"name":"__builtInStyle85"},{"foreColor":"#000000","hAlign":1,"vAlign":1,"font":"normal bold 24px SimSun","formatter":"#,##0","locked":false,"wordWrap":false,"name":"__builtInStyle86"},{"foreColor":"#000000","hAlign":0,"vAlign":1,"font":"normal normal 14.7px SimSun","formatter":"@","locked":false,"wordWrap":false,"name":"__builtInStyle87"},{"foreColor":"#000000","hAlign":0,"vAlign":1,"font":"normal normal 14.7px SimSun","locked":false,"wordWrap":false,"name":"__builtInStyle88"}]}}}
回复 使用道具 举报
dexteryao讲师达人认证 悬赏达人认证 SpreadJS 开发认证
超级版主   /  发表于:2017-3-22 17:51:50
地板
图片是我导入您提供json的效果,有些变宽缺失了。
建议您不要通过showborder 和showGridLine的方式去打印变宽,最好还是设置好想要打印的变宽直接打印。

blob704401855.png
回复 使用道具 举报
远光软件
初级会员   /  发表于:2017-3-23 08:48:59
5#
用的是9.40.20153.0版本的,实际表格那里没有设置宽度的,也能显示边框,而打印就不显示边框,两者不一致。
回复 使用道具 举报
远光软件
初级会员   /  发表于:2017-3-23 10:01:58
6#
貌似我多打印一行就可以显示出加粗效果,不过会多一个空行。
58d32c1ae4b06d61c05f710e.jpg
回复 使用道具 举报
远光软件
初级会员   /  发表于:2017-3-23 13:39:24
7#
dexteryao 发表于 2017-3-22 17:51
图片是我导入您提供json的效果,有些变宽缺失了。
建议您不要通过showborder 和showGridLine的方式去打印 ...

怎么设置呢?
回复 使用道具 举报
dexteryao讲师达人认证 悬赏达人认证 SpreadJS 开发认证
超级版主   /  发表于:2017-3-23 17:47:30
8#
建议您不要showborder 然后给模板的BE两列设置好左右边框。
回复 使用道具 举报
远光软件
初级会员   /  发表于:2017-3-24 08:53:34
9#
dexteryao 发表于 2017-3-23 17:47
建议您不要showborder 然后给模板的BE两列设置好左右边框。

这样解决的是边框显不显示的问题,没解决下边框没加粗的问题。
回复 使用道具 举报
dexteryao讲师达人认证 悬赏达人认证 SpreadJS 开发认证
超级版主   /  发表于:2017-3-24 10:59:08
10#
下边框没加粗 加粗就用您说得多设置一行去解决,
回复 使用道具 举报
12下一页
您需要登录后才可以回帖 登录 | 立即注册
返回顶部