Get values from range returns [Spill] instead

Get values from range returns [Spill] instead

Posted by: yyoshimura on 14 August 2023, 5:50 pm EST

• 

  yyoshimura

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 14 August 2023, 5:50 pm EST

  Hi,

  We have a workbook with some formulas in it and we rely on the feature when Workbook.EnableCalculation is false, the previous calculated values should be got instead. We noticed that after V6.0.5 this behaviour was changed and the same formula returns [spill] instead. Please see attachment for reproduction. Version 6.0.4 and before is working as expected.

  Please help to look at this issue. This feature is very critical to our use case and we hope that we can have the previous behavior by some means. Thank you.

  Regards

  ConsoleApp1.zip

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 15 August 2023, 3:29 pm EST

  Hello,

  We too can observe the issue and escalate 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-8725]

  Regards,
  
  Prabhat Sharma

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 24 August 2023, 8:26 pm EST

  Hello,

  We are happy to inform you that the issue is fixed in the 6.2.1 version and the build release is public.
  
  You can check with the latest 6.2.1 GcExcel.Net: https://www.nuget.org/packages/GrapeCity.Documents.Excel/6.2.1

  Regards,
  
  Prabhat Sharma.

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 29 August 2023, 5:33 pm EST

  We confirmed it is working with V6.2.1. Thank you for your support!