Some formula changed after saving

Some formula changed after saving

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

• 

  yyoshimura

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 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.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 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.

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 6 March 2022, 11:54 am EST

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