Result of COUNT function is incorrect

Result of COUNT function is incorrect

Posted by: yyoshimura on 8 March 2021, 5:02 pm EST

• 

  yyoshimura

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 March 2021, 5:02 pm EST

  Hi

  The result of COUNT function is not correct with following formula. Please refer attachment for reproduction. B3 cell is the result using Excel which value is 2, B6 cell is the result using library which value is 1.

  =COUNT(D3,E3,F3,)

  If we defined the COUNT function without the last comma, the result will be the same.

  We hope that the formula result should be same as Excel. The problem only occurs with COUNT function. COUNTA is working as expected.

  By the way, we are using the latest V4.0.4.

  Regards

  gcexcelperformance.zip

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 9 March 2021, 10:12 pm EST

  Hi,

  Thank you for bringing this to our attention.
  
  We have forwarded this to the developers and will let you know as soon as we get the update from their end.
  
  [Internal Tracking ID: 3841]

  Regards,
  
  Prabhat Sharma.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 10 April 2021, 11:54 pm EST

  Hello,

  We are happy to inform you that the issue has been fixed in the latest build 4.0.5 and you can update it from the given link:
  
  https://www.nuget.org/packages/GrapeCity.Documents.Excel/

  Regards,
  
  Prabhat Sharma.

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 12 April 2021, 10:44 am EST

  We confirmed that this issue is fixed in the latest build. Thank you for your support.