Summary: | The formula-parts are not correctly parsed by the method org.apache.poi.ss.formula.FormulaParser.parseSheetName() and that leads to the FormulaParseException | ||
---|---|---|---|
Product: | POI | Reporter: | GYO <g.youansisiewe> |
Component: | XSSF | Assignee: | POI Developers List <dev> |
Status: | RESOLVED INFORMATIONPROVIDED | ||
Severity: | critical | CC: | g.youansisiewe |
Priority: | P2 | Keywords: | APIBug |
Version: | 3.10-FINAL | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | All | ||
Attachments: | Excel-File (POI_BUG.xlsx) to trigger a FormulaParseException. And Fix for org.apache.poi.ss.formula.FormulaParser.parseSheetName() |
Description
GYO
2015-02-23 11:03:19 UTC
Created attachment 32508 [details]
Excel-File (POI_BUG.xlsx) to trigger a FormulaParseException. And Fix for org.apache.poi.ss.formula.FormulaParser.parseSheetName()
3.10 is a little old, and there have been quite a few Formula Parser fixes since then Any chance you could try with the 3.12 beta 1 release candidate, and see if that's already fixed? Hi POI, i just tried with the version 3.12 beta 2. The problem still occurs. Any chance you could re-format your proposed fix as a patch? http://poi.apache.org/guidelines.html#SubmittingPatches has some advice on that Also, if you could write a small unit test based on your test file, which shows the problem + verifies that your fix corrects it, that'd be most helpful! This patch is years out of date and code has improved over many POI releases. Try with latest POI release and reopen if you can provide a reproducible test case. |