Formula Highlighting

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

  • 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
    because the formula calculations are done in the backend and the affected values are sent back to the frontend and updated in SpreadJs.

    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
  • Marked as Answer

    Replied 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
Need extra support?

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

Learn More

Forum Channels