Formula si: {0}

Formula si: {0}

Posted by: marcio.shimoda on 12 July 2023, 5:11 pm EST

• 

  marcio.shimoda

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 12 July 2023, 5:11 pm EST

  Hi!
  
  I’m using the SpreadJS JSON to get the user formulas and save them in the backend. But sometimes I get “si: {0}” where should the string formula. Is there any information about this property and how could I get the formula?

• 

  chandan.rawat

  

  • Post Options:
  • Link
    Copy

  Posted 13 July 2023, 8:43 am EST

  Hello,

  Please note that the json schema of SpreadJS json format is for internal use in SpreadJS. It is not recommended to use it to read or get the state of the Sheet and Spread as it may change in future implementations for optimizations purpose. These are the internal implementation of the SpreadJS to optimize the formula references and increase the performance of Calc Engine. So it is not recommended to directly change or alter the json of the spread(workbook) since it may break the defined structures and cause issues. If you need to get the state or formulas from cells, you should use the APIs which are exposed by SpreadJS. This is to ensure consistency.

  Please let us know if you face any issues.

• 

  marcio.shimoda

  • Post Options:
  • Link
    Copy

  Posted 13 July 2023, 9:28 am EST

  Hi!

  So, should I use API Excel for Java to get those formulas correctly?

• 

  chandan.rawat

  

  • Post Options:
  • Link
    Copy

  Posted 14 July 2023, 9:07 am EST

  Hi,

  Yes, you can use Documents for Excel Java at the backend to create the Workbook instance from the ssjson. Then you could get the sheet instance and use the APIs to get the formulas from the sheet. This will ensure that you always get the formula string from the cell.