org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:543) --> Need book to evaluate name 'B65537'

[Andreas Reichel]

Dear All,

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):

String oldFormula = oldCell.getCellFormula();
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)
        at com.manticore.report.ExcelTools.shiftRows(ExcelTools.java:90)

The formula itself is just a simple row counter, like "=B2+1". How can I
work around that problem please?
Best regards!