Summary: | FormulaParseException inserting 1 row into 4-row spreadsheet. | ||
---|---|---|---|
Product: | POI | Reporter: | Thomas Gagne <tggagne> |
Component: | XSSF | Assignee: | POI Developers List <dev> |
Status: | CLOSED INVALID | ||
Severity: | major | ||
Priority: | P2 | ||
Version: | 3.6-FINAL | ||
Target Milestone: | --- | ||
Hardware: | Macintosh | ||
OS: | Windows XP | ||
Attachments: |
The source code to generate the above error. The spreadsheet will be attached next.
An xlsx workbook with a single, 4-row sheet. |
Created attachment 25542 [details]
An xlsx workbook with a single, 4-row sheet.
This spreadsheet was created with Excel. I removed the two extra tabs to simplify the example.
User error. |
Created attachment 25541 [details] The source code to generate the above error. The spreadsheet will be attached next. Exception in thread "main" org.apache.poi.ss.formula.FormulaParseException: Cell reference expected after sheet name at index 7. at org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:420) at org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:266) at org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1112) at org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1072) at org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1059) at org.apache.poi.ss.formula.FormulaParser.parseUnary(FormulaParser.java:1124) at org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1097) at org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1072) at org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1059) at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1410) at org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1510) at org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1494) at org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1451) at org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1431) at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1552) at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:174) at org.apache.poi.xssf.usermodel.helpers.XSSFRowShifter.shiftFormula(XSSFRowShifter.java:182) at org.apache.poi.xssf.usermodel.helpers.XSSFRowShifter.updateRowFormulas(XSSFRowShifter.java:152) at org.apache.poi.xssf.usermodel.helpers.XSSFRowShifter.updateSheetFormulas(XSSFRowShifter.java:139) at org.apache.poi.xssf.usermodel.helpers.XSSFRowShifter.updateFormulas(XSSFRowShifter.java:132) at org.apache.poi.xssf.usermodel.XSSFSheet.shiftRows(XSSFSheet.java:2075) at org.apache.poi.xssf.usermodel.XSSFSheet.shiftRows(XSSFSheet.java:2022) at t2test.PoiTest.littleTest(PoiTest.java:46) at t2test.PoiTest.main(PoiTest.java:18)