You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Constantin <c....@googlemail.com> on 2010/05/27 10:25:44 UTC
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: XSSFSheet.shiftRows(...) Error
Posted by Constantin <c....@googlemail.com>.
<Bryce.Alcock <at> sungard.com> writes:
>
> What branch are you using?
> Nightly build?
Hi,
i'm using POI 3.6-20091214
Thanks,
Constantin
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
RE: XSSFSheet.shiftRows(...) Error
Posted by Br...@sungard.com.
What branch are you using?
Nightly build?
-----Original Message-----
From: Constantin [mailto:c.pagenkopp@googlemail.com]
Sent: Thursday, May 27, 2010 3:26 AM
To: user@poi.apache.org
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org