Cannot get value from cell with Index and Match function combo

Cannot get value from cell with Index and Match function combo

Posted by: yyoshimura on 14 April 2023, 1:33 am EST

• 

  yyoshimura

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 14 April 2023, 1:33 am EST

  Hi,

  We have a workbook with cells defined with Index and Match function combo. When we try to get the value from the cell using the library, “Value” string is returned instead of actual value. Please see attachment for reproduction.

  Please help to look at this issue. Thank you.

  Regards

  sample.zip

• 

  nitin.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 17 April 2023, 5:48 am EST

  Hi,

  We have replicated this issue at our end. This seems like a bug. So, we have escalated this issue to the development team. Will get back to you once we have any update from them.[Internal Tracking Id - DOCXLS-8013]

  Best Regards,
  
  Nitin

• 

  nitin.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 10 May 2023, 2:32 am EST

  Hi,

  This issue is fixed in 6.1.0 version. Please refer here for the same: https://www.nuget.org/packages/GrapeCity.Documents.Excel#versions-body-tab

  Regards,
  
  Nitin

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 10 May 2023, 3:33 am EST

  Thank you for the fix!