You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2016/06/01 18:25:18 UTC
[Bug 59652] New: FormulaParseException from whitespace
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.paffrath@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-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 59652] FormulaParseException from whitespace
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59652
Bug 59652 depends on bug 58648, which changed state.
Bug 58648 Summary: FormulaParser throws exception in parseSimpleFactor() when getCellFormula() is called on a cell and the formula contains spaces between closing parentheses ") )"
https://bz.apache.org/bugzilla/show_bug.cgi?id=58648
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |FIXED
--
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
[Bug 59652] FormulaParseException from whitespace
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59652
--- Comment #2 from scott.paffrath@gmail.com ---
It is a duplicate and the nightly build fixes it. Thank you.
--
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
[Bug 59652] FormulaParseException from whitespace
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59652
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution|--- |DUPLICATE
--- Comment #3 from Dominik Stadler <do...@gmx.at> ---
Fixed by the fix for bug 58648.
*** This bug has been marked as a duplicate of bug 58648 ***
--
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
[Bug 59652] FormulaParseException from whitespace
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59652
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
Depends on| |58648
Status|NEW |NEEDINFO
--- Comment #1 from Dominik Stadler <do...@gmx.at> ---
Sounds like a duplicate of 58648, can you try with a nightly build from
https://builds.apache.org/view/POI/job/POI/lastSuccessfulBuild/artifact/build/dist/
to verify that your cases were also fixed by these changes.
--
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
[Bug 59652] FormulaParseException from whitespace
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59652
Bug 59652 depends on bug 58648, which changed state.
Bug 58648 Summary: FormulaParser throws exception in parseSimpleFactor() when getCellFormula() is called on a cell and the formula contains spaces between closing parentheses ") )"
https://bz.apache.org/bugzilla/show_bug.cgi?id=58648
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |UNCONFIRMED
Resolution|FIXED |---
--
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