Forums Home / Spread / SpreadJS
Posted by: davide.vago on 25 January 2022, 9:57 pm EST
davide.vago
Posted 25 January 2022, 9:57 pm EST
Dear support,
I’ve been noticing your SpreadJS v15 is available via NPM since a week now but there is nothing live that explain what is changing and how we can migrate v14 to v15.
Would you please check it out? I noticed the v15 is breaking the initialisation of Workbooks based on v14.
Looking forward to hearing from you
avinash.pathak
Posted 26 January 2022, 9:44 pm EST
Hi Davide,
You may refer to the following link for the changelog.
Changelog: https://www.grapecity.com/spreadjs/docs/latest/online/rnotesv15.html
Further, Regarding the migration error. Could you please provide the working sample? so that we could investigate it further and help you accordingly. You may also refer rot the following attached sample and modified it to replicate the issue.
Regards
Avinash
davide.vago
Posted 3 February 2022, 11:03 pm EST
Hi Avinash,
After an initial investigation the breaking part is caused by the fromJSON method.
We are currently injecting data via the fromJSON method, the structure of our files is more or less like this one (I tried to replicate without displaying sensitive data):
{
"sheets": {
"My fancy data set": {
"name": "My fancy data set",
"rowCount": 208,
"columnCount": 20,
"activeRow": 0,
"activeCol": 0,
"data": {
"dataTable": {
"0": {
"0": {
"value": 2774,
}
}
},
"defaultDataNode": {
"style": {
"foreColor": "#041c2c",
"hAlign": 2,
"font": "12px Open Sans",
"formatter": "_(#,##0.0_);_((#,##0.0);_(\"-\"??_);_(@_)",
"locked": false,
"wordWrap": true
}
},
"columns": [
{
"size": 411
}
],
"gridline": {
"showHorizontalGridline": false,
"showVerticalGridline": false
},
"index": 0
},
"scrollIgnoreHidden": true,
"sheetCount": 1,
"activeSheetIndex": 0
}
Something must be changed in terms of Schema structure or minimum requirements to use the fromJSON method.
Please note, this happens also with the latest patch 15.0.1
Looking forward to hearing from you.
avinash.pathak
Posted 6 February 2022, 5:09 pm EST
Hi Davide,
Something must be changed in terms of Schema structure or minimum requirements to use the fromJSON method.
This may be possible every major release has some new enhancements and it may affect the json that is why changing the json directly is not recommended because we can not guarantee that the schema will not be changed in the future. We recommend you Always, use spreadJS API to change the workbook json.
Further, we tried to replicate the issue using the provided json but at our end, the json is loading correctly. Please refer to the following sample and modify it to replicate the issue.
sample: https://jscodemine.grapecity.com/share/niYlohRoZUqKLUHBfuQabQ/
Regards,
Avinash
davide.vago
Posted 6 February 2022, 10:45 pm EST
Thanks Avinash for getting back to me with a sample.
Would you be able to provide us the Schema Diff between v14 and v15, there must be something changed, the small sample I gave isn’t 100% representative of what we actually inject but I couldn’t provide a better example for company policies reasons.
Looking forward to hearing from you,
Regards,
Davide
avinash.pathak
Posted 7 February 2022, 3:19 pm EST
Hi Davide,
We have escalated this issue to the concerned team and asked them regarding the same. We will update you regarding this as we get any information from the team. The internal ID for the issue will be SJS-11815.
Regards,
AVinash
avinash.pathak
Posted 8 February 2022, 8:49 pm EST
Hi Davide,
please refer to the following attached JSON scheme of v15 and let me know if you have any further queries.
Regards
Avinash
davide.vago
Posted 8 February 2022, 9:18 pm EST
Hi Avinash,
Thanks for coming back to me with this, would it be possible to have the same file of v14 so we can diff the 2 files and see what changed?
Thanks again,
Davide
avinash.pathak
Posted 9 February 2022, 4:34 pm EST
Hi Davide,
For V14, YOu may refer to the following documentation Link.
JSON Schema: https://www.grapecity.com/spreadjs/docs/v14/online/fullschema13.html
Regards,
Avinash
kevin.ashley
Posted 18 February 2022, 7:21 am EST
Hi Davide,
I just wanted to let you know that our JSON schema has been updated in our docs to the latest one:
https://www.grapecity.com/spreadjs/docs/latest/online/fullschema.html
Regards,
Kevin
