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
|