nodejs chart 出现 Bad Format Specifier错误

1. chart对象的JSON = {"name":"Chart 1","x":402,"y":40,"width":480,"height":300,"startRow":2,"startColumn":5,"startColumnOffset":20,"endRow":17,"endColumn":11,"endColumnOffset":20,"isSelected":true,"typeName":"2","chartSpace":{"typeName":"chartSpace","roundedCorners":false,"chart":{"title":{"txPr":{"p":[{"elements":[{"elementType":0,"t":"","rPr":{"latin":{"typeface":"+mn-lt"},"sz":18.
   
2. 67,"b":false,"solidFill":{"schemeClr":{"val":1,"lumMod":[65000],"lumOff":[35000]}}}}],"pPr":{"defRPr":{"latin":{"typeface":"+mn-lt"},"sz":18.67,"b":false,"solidFill":{"schemeClr":{"val":1
   
3. ,"lumMod":[65000],"lumOff":[35000]}}}},"endParaRPr":{}}],"bodyPr":{},"lstStyle":{}},"overlay":false,"spPr":null},"autoTitleDeleted":false,"plotArea":{"axes":[{"axisType":0,"axId":88779187
   
4. ,"delete":false,"majorTickMark":2,"minorTickMark":2,"tickLblPos":2,"axPos":0,"scaling":{"orientation":1},"spPr":{"ln":{"solidFill":{"schemeClr":{"val":1,"lumMod":[15000],"lumOff":[85000]}
   
5. }}},"numFmt":{"formatCode":"General"},"txPr":{"p":[{"elements":[{"elementType":0,"t":"","rPr":{"latin":{"typeface":"+mn-lt"},"sz":12,"b":false,"solidFill":{"schemeClr":{"val":1,"lumMod":[
   
6. 65000],"lumOff":[35000]}}}}],"pPr":{"defRPr":{"latin":{"typeface":"+mn-lt"},"sz":12,"b":false,"solidFill":{"schemeClr":{"val":1,"lumMod":[65000],"lumOff":[35000]}}}},"endParaRPr":{}}]},"a
   
7. uto":true,"lblOffset":0,"tickMarkSkip":1,"noMultiLvlLbl":true,"AxisGroup":0,"AxisType":0,"crosses":1,"crossAx":75828958},{"axisType":3,"axId":75828958,"delete":false,"majorTickMark":2,"mi
   
8. norTickMark":2,"tickLblPos":2,"axPos":1,"scaling":{"orientation":1},"spPr":{"ln":{"solidFill":{"schemeClr":{"val":1,"lumMod":[15000],"lumOff":[85000]}}}},"numFmt":{"formatCode":"General"}
   
9. ,"txPr":{"p":[{"elements":[{"elementType":0,"t":"","rPr":{"latin":{"typeface":"+mn-lt"},"sz":12,"b":false,"solidFill":{"schemeClr":{"val":1,"lumMod":[65000],"lumOff":[35000]}}}}],"pPr":{"
   
10. defRPr":{"latin":{"typeface":"+mn-lt"},"sz":12,"b":false,"solidFill":{"schemeClr":{"val":1,"lumMod":[65000],"lumOff":[35000]}}}},"endParaRPr":{}}]},"majorGridlines":{"spPr":{"ln":{"solidF
    
11. ill":{"schemeClr":{"val":1,"lumMod":[15000],"lumOff":[85000]}},"w":1},"effectLst":{}}},"AxisGroup":0,"AxisType":1,"crosses":1,"crossBetween":0,"crossAx":88779187}],"chartGroups":[{"chartT
    
12. ype":6,"ser":[{"seriesType":0,"idx":0,"order":0,"val":{"numRef":{"f":"Sheet1!$E$2:$E$5","numCache":{"formatCode":"General"}}},"shape":2,"invertIfNegative":false}],"axId":[88779187,7582895
    
13. 8],"barDir":1,"grouping":1,"gapWidth":150,"varyColors":false,"overlap":-27}],"spPr":{"noFill":true,"ln":{"noFill":true}}},"legend":{"legendPos":4,"txPr":{"p":[{"elements":[{"elementType":
    
14. 0,"t":"","rPr":{"latin":{"typeface":"+mn-lt"},"sz":12,"b":false,"solidFill":{"schemeClr":{"val":1,"lumMod":[65000],"lumOff":[35000]}}}}],"pPr":{"defRPr":{"latin":{"typeface":"+mn-lt"},"sz
    
15. ":12,"b":false,"solidFill":{"schemeClr":{"val":1,"lumMod":[65000],"lumOff":[35000]}}}},"endParaRPr":{}}]}},"plotVisOnly":true},"spPr":{"solidFill":{"schemeClr":{"val":0}},"ln":{"solidFill
    
16. ":{"schemeClr":{"val":1,"lumMod":[15000],"lumOff":[85000]}},"w":1}},"txPr":{"p":[{"elements":[{"elementType":0,"t":"","rPr":{"latin":{"typeface":"+mn-lt"},"b":false,"solidFill":{"schemeCl
    
17. r":{"val":1,"lumMod":[65000],"lumOff":[35000]}}}}],"pPr":{"defRPr":{"latin":{"typeface":"+mn-lt"},"b":false,"solidFill":{"schemeClr":{"val":1,"lumMod":[65000],"lumOff":[35000]}}}},"endPar
    
18. aRPr":{}}]}},"useAnimation":false}
    
19. 
    
20. seriesItem 的JSON = {"chartType":12,"axisGroup":0,"backColor":"accent 3 50","backColorTransparency":0,"border":{"color":"accent 3 50","transparency":0,"width":0},"name":""Series1"","yValues":
    
21. "Sheet1!$E$2:$E$5"}

复制代码

报错信息如下图:




我调用的方法是 util.js 文件中 的chartHelper.applyChartSeriesTheme方法. 报错的代码是  seriesCollection.set(i, seriesItem);  其中需要的 chart 对象 和 seriesItem对象的 json数据在上面给出了.

麻烦看下是什么问题. 已经遇到很多次了. 都无法解决.

您好，这个问题需要做一些调研，目前还无法定位问题出在哪里，明天下午下班前会给您回复。

您好，关于SpreadJS与Nodejs结合使用的问题，我们需要内部沟通处理，

能否描述一下您的应用场景，为什么您需要在NodeJS中使用SpreadJS？

印象中贵司已经引入了GCDocuments，是有哪些特殊的需求点无法满足呢？

我们是准备在nodejs环境下执行命令. 包括在线编辑器的命令

随着表格的增大，在前端生成好ssjson传回后端服务器会造成明显的延迟，所以我们需要把前端操作的命令传回后端，后端自己再生成ssjson。gcexcel并不支持命令，所以只能用node在后端运行sp来执行命令。

好的，这个问题我会提交到系统中，后续进展请关注本帖

请问这个大概多久可以得到回复呢 ? 因为我们这边现在需要等你们的结果后, 我们才能继续做这件事情. 所以, 你们给出结果的时间对于我们而言还是很重要的. 麻烦了, 谢谢啦

这个问题需要等待研发人员的反馈，由于SpreadJS在开发中，是不对nodejs环境做支持的，

具体修不修，怎么解决，这方面还需要评估。