找回密码
 立即注册

QQ登录

只需一步,快速开始

jiqimao 讲师达人认证
金牌服务用户   /  发表于:2019-7-4 18:14  /   查看:4542  /  回复:7
  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. seriesItem 的JSON = {"chartType":12,"axisGroup":0,"backColor":"accent 3 50","backColorTransparency":0,"border":{"color":"accent 3 50","transparency":0,"width":0},"name":""Series1"","yValues":
  20. "Sheet1!$E$2:$E$5"}
复制代码


报错信息如下图:

image.png624187926.png


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

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






7 个回复

倒序浏览
Fiooona
论坛元老   /  发表于:2019-7-4 19:04:57
沙发
您好,这个问题需要做一些调研,目前还无法定位问题出在哪里,明天下午下班前会给您回复。
组件化表格编辑器(预览版)试用进行中,点击了解详情!
请点击评分,对我的服务做出评价!5分为非常满意!
回复 使用道具 举报
KevinChen讲师达人认证 悬赏达人认证 SpreadJS 开发认证
论坛元老   /  发表于:2019-7-5 14:26:29
板凳
您好,关于SpreadJS与Nodejs结合使用的问题,我们需要内部沟通处理,

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

印象中贵司已经引入了GCDocuments,是有哪些特殊的需求点无法满足呢?
回复 使用道具 举报
jiqimao讲师达人认证
金牌服务用户   /  发表于:2019-7-5 23:00:23
地板
我们是准备在nodejs环境下执行命令. 包括在线编辑器的命令
回复 使用道具 举报
jiqimao讲师达人认证
金牌服务用户   /  发表于:2019-7-7 13:53:33
5#
随着表格的增大,在前端生成好ssjson传回后端服务器会造成明显的延迟,所以我们需要把前端操作的命令传回后端,后端自己再生成ssjson。gcexcel并不支持命令,所以只能用node在后端运行sp来执行命令。
回复 使用道具 举报
KevinChen讲师达人认证 悬赏达人认证 SpreadJS 开发认证
论坛元老   /  发表于:2019-7-8 12:22:51
6#
好的,这个问题我会提交到系统中,后续进展请关注本帖
回复 使用道具 举报
jiqimao讲师达人认证
金牌服务用户   /  发表于:2019-7-8 12:39:59
7#
请问这个大概多久可以得到回复呢 ? 因为我们这边现在需要等你们的结果后, 我们才能继续做这件事情. 所以, 你们给出结果的时间对于我们而言还是很重要的. 麻烦了, 谢谢啦
回复 使用道具 举报
KevinChen讲师达人认证 悬赏达人认证 SpreadJS 开发认证
论坛元老   /  发表于:2019-7-8 17:09:25
8#
这个问题需要等待研发人员的反馈,由于SpreadJS在开发中,是不对nodejs环境做支持的,

具体修不修,怎么解决,这方面还需要评估。
回复 使用道具 举报
您需要登录后才可以回帖 登录 | 立即注册
返回顶部