Some formula changed after saving

Posted by: yyoshimura on 20 February 2022, 7:45 pm EST

  • Posted 20 February 2022, 7:45 pm EST

    Hi,

    We have a book with LET function defined and we know that LET function is not supported currently, but the problem is that when the book is saved using the library, the definition of formula was changed unexpectedly and causing #Name? error.
    Please refer attachment for reproduction. Problematic cell is E7.

    Is there any way to avoid this issue?

    Regards

    gcexcelperformance.zip
  • Replied 21 February 2022, 10:18 pm EST

    Hello,

    Thank you for reporting this issue.
    We too can observe the issue and escalated this to the development team for investigation. We will let you know as soon as we get any update on this from their end.
    [Internal Tracking ID: DOCXLS-5593]

    Regards,
    Prabhat Sharma.
  • Marked as Answer

    Replied 6 March 2022, 6:15 am EST

    Hello,

    Your issue has been in the 5.0.4 release of GcExcel. Please update to the latest version to fix this issue.
    https://www.nuget.org/packages/GrapeCity.Documents.Excel/5.0.4

    Regards,
    Prabhat Sharma.
  • Replied 6 March 2022, 11:54 am EST

    Thank you for your support. We confirmed that the issue is fixed in 5.0.4.
Need extra support?

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

Learn More

Forum Channels