poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 54639] New: If a formula contains AND(..., ISBLANK(...), ...), Excel always evaluates the ISBLANK to false
Date Tue, 05 Mar 2013 14:18:03 GMT
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: dev@poi.apache.org
          Reporter: didierloiseau+apache@gmail.com
    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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message