https://issues.apache.org/bugzilla/show_bug.cgi?id=54639
Bug ID: 54639
Summary: If a formula contains AND(..., ISBLANK(...), ...),
Excel always evaluates the ISBLANK to false
Product: POI
Version: 3.9
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
Assignee: [email protected]
Reporter: [email protected]
Classification: Unclassified
Created attachment 30019
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30019&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
