https://issues.apache.org/bugzilla/show_bug.cgi?id=57390
Bug ID: 57390
Summary: Match function with array argument in formula results
in "File error: data may have been lost"
Product: POI
Version: 3.11-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
Assignee: [email protected]
Reporter: [email protected]
Consider following simple example:
HSSFWorkbook wb = new HSSFWorkbook();
HSSFRow row = wb.createSheet().createRow(0);
row.createCell(0).setCellValue("09");
row.createCell(1).setCellFormula("MATCH(TRIM(A1),{\"09\"},0)");
try (FileOutputStream fos = new FileOutputStream("match_test_poi.xls"))
{
wb.write(fos);
}
Resulting file will contain formula MATCH(TRIM(A1),{"09"},0) in B1. When this
file is opened in MS Excel 2007/2010 it results in "File error: data may have
been lost". Then in B1 there is a "=#N/A" value. FYI, same file opens just fine
in OpenOffice.
I have checked poi 3.6 and latest poi 3.11. Both version have this issue.
Any help appreciated.
--
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]
