Bug 54639 - If a formula contains AND(..., ISBLANK(...), ...), Excel always evaluates the ISBLANK to false
Summary: If a formula contains AND(..., ISBLANK(...), ...), Excel always evaluates the...
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.9-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-03-05 14:18 UTC by Didier Loiseau
Modified: 2015-10-29 09:28 UTC (History)
1 user (show)



Attachments
Test code that demonstrates the bug (1.52 KB, text/x-java)
2013-03-05 14:18 UTC, Didier Loiseau
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Didier Loiseau 2013-03-05 14:18:03 UTC
Created attachment 30019 [details]
Test code that demonstrates the bug

If POI writes a formula that contains an ISBLANK() (or NOT(ISBLANK())) immediately within an AND/OR, Excel always evaluates it to false.

However, if within Excel you rewrite the formula without modifying it (e.g. F2 then enter), then Excel will evaluate it correctly.

This only occurs for HSSF, not XSSF.
Comment 1 Didier Loiseau 2013-03-05 14:31:30 UTC
I just noticed that IF(TRUE, ISBLANK(A2)) also has the same issue (returns false), whereas IF(ISBLANK(A2), TRUE) does not!