Formulas are not getting saved after exporting to excel

Posted by: sreepriya.ameti on 5 May 2021, 6:46 pm EST

  • Posted 5 May 2021, 6:46 pm EST

    Hi,
    We are using spread v14 in our application.
    When we give some formulas to the cells and then on saving it to excel, we see the value is there but if you click on the cell we don't see the formula given to that cell.
    Can you let us know what are we missing while saving it to excel.
    This is an urgent requirement so please given an immediate response.

    Thank you,
    Sreepriya.
  • Marked as Answer

    Replied 5 May 2021, 10:02 pm EST

    Hi,

    You don't need to do anything specific to have formulae exported to an Excel file.
    As you can see in the attached sample, the cell A4 contains the formula after the export.
    SaveFormulaCells.zip

    Please check if you are doing something else and attach a small sample here so we can further investigate it.

    Thanks,
    Jitender
Need extra support?

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

Learn More

Forum Channels