Formula Highlighting

Formula Highlighting

Posted by: frederik.beaudry on 26 May 2021, 1:16 am EST

• 

  frederik.beaudry

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 26 May 2021, 1:16 am EST

  Hello,

  I am trying to achieve something which I am not sure is possible. If it is, I would like to be pointed in the right direction.

  Our application currently uses SpreadJs to display the spreadsheet to the user, however, we initialize the workbook with ```
  
  deserializationOptions.ignoreFormula = true

  
  With this current setup, we simply don't have access to a cell's formula.
  
  1. Is it possible to setup the workbook so that it doesn't recalculate, but we can access a cell's formula via the workbook?
  
  2. If not, is it possible to use the formula textbox via a formula that I fetch from the backend?
  
  We need to have formula highlighting, which does not seem to be possible when the formulas are ignored.
  
  Thanks

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 27 May 2021, 12:12 am EST

  Hi,

  We are sorry but this is not supported with SpreadJS. Please let me know if you have any further queries regarding this issue, We are sorry for the inconvenience.

  Regards,
  
  Avinash