poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 55324] New: formula returning #VALUE
Date Mon, 29 Jul 2013 09:23:28 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=55324

            Bug ID: 55324
           Summary: formula returning #VALUE
           Product: POI
           Version: 3.10-dev
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
          Assignee: dev@poi.apache.org
          Reporter: w.deprez@specinov.fr

When you create an excel file and use the following forumula, if condition is
true, we see a #VALUE in Excel. However if you click on the cell (or press F2
key) and press enter, the formula gets populated. 

=IF(LEN(A1)>4,MID(A1,4,2),A1)

-- 
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