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]
