v15 is out within the registry but no announcement/changelog is available

Posted by: davide.vago on 25 January 2022, 9:57 pm EST

  • 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
  • Replied 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

    sjs_cdn.html.html.zip
  • Replied 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.
  • Replied 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

  • Replied 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

  • Replied 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
  • Replied 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

    JSON_Schema.zip
  • Replied 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
  • Replied 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
  • Replied 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
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels