Erro Formula

Erro Formula

Posted by: pedro.moraes on 24 March 2023, 9:14 am EST

• 

  pedro.moraes

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 24 March 2023, 9:14 am EST

  Hello,

  I have a doubt in the formulas. For example, in cell A1 I put the value 10, in B1 I put =A1+10 and dragged it to the end of the line. But when I generate the JSON, the formula:

  si: {0}

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 27 March 2023, 6:32 am EST

  Hello,
  
  We were able to replicate the issue on our end. We also found the object instead of formula string in the formula property of the cell in the json format. We would like to tell you that these are the internal implementation of the SpreadJS to optimize the formula references and increase the performance of Calc Engine.

  Please note that the json schema of SpreadJS json format is only for the internal use in SpreadJS. It may change in the future implementations for optimizations. 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 change something in the spread, you need to use the related APIs for that purpose.

  Please let us know if you still face any difficulties.

  regards,
  
  Avinash

• 

  geometrylitegame.org

  • Post Options:
  • Link
    Copy

  Posted 2 December 2025, 4:29 am EST

  You’ll need a tool or script that specifically extracts the formula as a string instead of the value.

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 2 December 2025, 6:35 am EST

  Hi,

  If you need to retrieve the formula as a string, you can use the

  getFormula

  API:
  
  https://developer.mescius.com/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#getformula

  Regards,
  
  Priyam