https://bz.apache.org/bugzilla/show_bug.cgi?id=59652
Bug ID: 59652
Summary: FormulaParseException from whitespace
Product: POI
Version: 3.14-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: scott.paffr...@gmail.com
Both HSSF and XSSF throw this exception now when there is whitespace between
elements and closing parenthesis. I jumped from 3.12 to 3.14 so not sure if
this was in 3.13 or not.
public static void main(String[] args)
{
XSSFWorkbook wb = new XSSFWorkbook();
XSSFSheet sheet = wb.createSheet();
Row row = sheet.createRow(0);
Cell cell = row.createCell(0);
cell.setCellFormula("(4 + 2)"); // This works
cell = row.createCell(1);
cell.setCellFormula("( 4 + 2)"); // This works
cell = row.createCell(2);
cell.setCellFormula("(4 + 2 )"); // FormulaParseException
}
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
