search

EPPlusSoftware / EPPlus

EPPlus-Excel spreadsheets for .NET
https://epplussoftware.com
Other
1.81k stars 276 forks source link

COUNTIFS not matching true & false as expected #1578

Closed colbybhearn closed 1 month ago

colbybhearn commented 2 months ago

EPPlus usage

Commercial use (I have a commercial license)

Environment

Windows

Epplus version

7.3

Spreadsheet application

Excel

Description

It seems the true/false value matching is not working like Excel's. Excel matches the value True using criteria True or "True" EPPlus does not match the value True using criteria True or "True" EPPlus only matches the value 'True' with 1 or "1".

I did not see tests for true/false values, nor for multiple sets of arguments, so I added those in PR #1575

swmal commented 2 months ago

Thanks @colbybhearn - I will have a look at this.