Bug 49399 - FormulaParseException inserting 1 row into 4-row spreadsheet.
Summary: FormulaParseException inserting 1 row into 4-row spreadsheet.
Status: CLOSED INVALID
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.6-FINAL
Hardware: Macintosh Windows XP
: P2 major (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-06-07 14:43 UTC by Thomas Gagne
Modified: 2010-06-07 14:51 UTC (History)
0 users


Attachments
The source code to generate the above error. The spreadsheet will be attached next. (1.22 KB, application/octet-stream)
2010-06-07 14:43 UTC, Thomas Gagne 		Details
An xlsx workbook with a single, 4-row sheet. (7.27 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2010-06-07 14:46 UTC, Thomas Gagne 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Thomas Gagne 2010-06-07 14:43:25 UTC 
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)
Comment 1 Thomas Gagne 2010-06-07 14:46:11 UTC 
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.
Comment 2 Thomas Gagne 2010-06-07 14:50:39 UTC 
User error.