-
Notifications
You must be signed in to change notification settings - Fork 267
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Epplus result differs from excel for number and empty string inequality #1364
Comments
Hi @colbybhearn, we have fixed this one and #1365 and it will be released in next version of EPPlus 6. Both of these worked as expected in EPPlus 7, which has a lot of improvements in the formula calculation. You should consider to upgrade from v6 to v7 since we will not provide bug fixes on EPPlus 6 for more than another month or so (until we release v 7.1 - we support the two latest minor versions which currently is 7.0 and 6.2). |
@swmal Ok, understood. Thanks so much for jumping on these defects (@JanKallman too!). I'll look into v7 again! |
Excel gives a result of
FALSE
for=24>""
and a result ofTRUE
for=24<""
.EPPlus yields the exact opposite.
Please see attached workbook.
I'm sorry I couldn't put together a pull request for this one.
Empty string inequality.xlsx
This is occurring for me in version 6.2.10 and 6.2.18.
The text was updated successfully, but these errors were encountered: