https://issues.apache.org/bugzilla/show_bug.cgi?id=48043
Summary: Excel complains about a POI generated function
Product: POI
Version: 3.5-FINAL
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
When I insert the following function in a cell:
=IF(AND(ISBLANK(A10),ISBLANK(B10)),"",CONCATENATE(A10,"-",B10))
using:
cell.setCellFormula(
"IF(AND(ISBLANK(A10)," +
"ISBLANK(B10)),\"\"," +
"CONCATENATE(A10,\"-\",B10))");
Excel complains about it (#VALUE!) when the workbook is first opened. However,
it is enough just to press F2, Enter on a cell for the function to start
evaluating properly. Interestingly, this problem does not appear in OpenOffice.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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]
