What branch are you using? Nightly build?
-----Original Message----- From: Constantin [mailto:[email protected]] Sent: Thursday, May 27, 2010 3:26 AM To: [email protected] Subject: XSSFSheet.shiftRows(...) Error Hi, i want to shift rows within a XSSFSheet. I have the following code: XSSFSheet sheet; .. sheet.shiftRows(4, 6, -1); So I want to shift the rows 4, 5 and 6 one row up. When I do this, I get the following error: Exception in thread "main" org.apache.poi.ss.formula.FormulaParseException: Cell reference expected after sheet name at index 8. 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.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.updateNamedRanges (XSSFRowShifter.java:112) at org.apache.poi.xssf.usermodel.XSSFSheet.shiftRows (XSSFSheet.java:2074) at org.apache.poi.xssf.usermodel.XSSFSheet.shiftRows (XSSFSheet.java:2022) at test.renderer.base.renderer.WorkbookRenderer.processForEachCell (WorkbookRenderer.java:156) at test.renderer.base.renderer.WorkbookRenderer.evaluateCell (WorkbookRenderer.java:103) at test.renderer.base.renderer.WorkbookRenderer.processRow (WorkbookRenderer.java:76) at test.renderer.base.renderer.WorkbookRenderer.processSheet (WorkbookRenderer.java:64) at test.renderer.base.renderer.WorkbookRenderer.render (WorkbookRenderer.java:55) at test.renderer.services.FETARendererService.createExcelReport (FETARendererService.java:35) at test.Test.main(Test.java:14) I have no formula within the sheet (& the whole workbook). Do you have any idea, why I get this exception? Or can you explain to me, what it means exactly? Thank you in advance and best regards, Constantin --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
