Nick and Team.
it is my own class/code and I have shown the line causing this bug which
is pure POI:
Ptg[] ptgs= FormulaParser.parse(
oldFormula
, parsingWorkbook
, FormulaType.CELL
, workbook.getSheetIndex(worksheet));
java.lang.IllegalStateException: Need book to evaluate name 'B65537'
at
org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:543)
at
org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:416)
at
org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:237)
at
org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1126)
at
org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1086)
at
org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1073)
at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1433)
at
org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1533)
at
org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1517)
at
org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1474)
at
org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1454)
at
org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1575)
at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:145)
My question is: why does the FormulaParser understand "=B1+1" up to
"=B65536+1", but eventually fails on "=B65536+1"?
Best regards
Andreas
On Sat, 2015-03-21 at 17:43 +0000, Nick Burch wrote:
> On Sat, 21 Mar 2015, Andreas Reichel wrote:
> > inserting a lot of new rows into a XSSF Sheet works well up to row
> > 65536, but finally fails:
> >
> > com.manticore.report.ExcelTools.shiftRows(ExcelTools.java:90):
>
> That isn't an Apache POI class. You might need to report the problem to
> whoever maintains that code
>
> (As long as you're on a new enough version of Apache POI, the POI part
> should work, so my hunch is that the bug is in the non-POI code you're
> using)
>
> Nick
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
