Bug 49399

Summary: FormulaParseException inserting 1 row into 4-row spreadsheet.
Product: POI Reporter: Thomas Gagne <tggagne>
Component: XSSFAssignee: 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.

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.