Bug 54639

Summary: If a formula contains AND(..., ISBLANK(...), ...), Excel always evaluates the ISBLANK to false
Product: POI Reporter: Didier Loiseau <didierloiseau+apache>
Component: HSSFAssignee: POI Developers List <dev>
Status: NEW ---    
Severity: normal CC: onealj
Priority: P2    
Version: 3.9-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   
Attachments: Test code that demonstrates the 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!