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

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

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

• 

  thiago

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 23 August 2018, 1: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.

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 23 August 2018, 10:37 pm EST

  Hello,

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

  Thanks,
  
  Deepak Sharma

• 

  thiago

  • Post Options:
  • Link
    Copy

  Posted 24 August 2018, 12: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

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 26 August 2018, 6:56 pm EST - Updated 3 October 2022, 2:09 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
  
  

  

  1214×952 72.9 KB