Formulas missing after Excel file with named cells is converted to SpreadJS

Posted by: thiago on 23 August 2018, 10:15 pm EST

  • Posted 23 August 2018, 10:15 pm EST

    Hi,

    We have been having an issue when converting Excel files to SpreadJS. After importing the Excel file to our application, some of the formulas in the spreadsheet are lost, and a constant value is left in the corresponding cells where the formulas should be found. Also, the Excel spreadsheet has a number of named cells in it.

    This issue seems to be recent, and we have no record of facing it over the past months. We are using the latest version of Chrome, SpreadJS 9.40.20161.0 and ExcelIO service.

    Thanks.
  • Replied 24 August 2018, 7:37 am EST

    Hello,

    There is no known issue as such.
    Could you please provide the Excel file to debug this issue further?


    Thanks,
    Deepak Sharma
  • Replied 24 August 2018, 9:19 am EST

    Sure. Please find example attached.
    The last cells marked in yellow in line 8 are the ones we refer to.
    SpreadJS-Issue.zip
  • Marked as Answer

    Replied 27 August 2018, 3:56 am EST

    Hello,

    I tested this issue with the latest build of spreadJS(v11) and could not replicate it.
    I imported the Excel file with the online demo:
    https://www.grapecity.com/en/demos/spread/JS/InspectorSample/

    Please refer to the attached image.

    I would suggest you to please upgrade to latest version of spreadJS.

    Thanks,
    Deepak Sharma
Need extra support?

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

Learn More

Forum Channels