poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 58591] Formula evaluation of IF-Equals "IF(A1=1, B1, C1)" returns incorrect result if A1 cell value is TRUE
Date Sat, 07 Nov 2015 04:10:20 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=58591

--- Comment #3 from Javen O'Neal <onealj@apache.org> ---
All of these formulas can probably be reduced down to an equality test between
different data types that can be coerced to the same data types then compared
with regular boolean logic.

Thanks for Jason Tomforde for asking the question on user@[1] that triggered
the finding of this bug.

Added these unit tests in r1713080, with @Ignore annotations applied to failing
tests.

[1]
https://mail-archives.apache.org/mod_mbox/poi-user/201511.mbox/%3CSNT150-W744ED91F30ADE685B52EF4C5290%40phx.gbl%3E
Thread: http://thread.gmane.org/gmane.comp.jakarta.poi.user/21417

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message