Result of COUNT function is incorrect

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

  • 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
  • Replied 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.
  • Replied 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.
Need extra support?

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

Learn More

Forum Channels