java.lang.IllegalStateException: Need book to evaluate name 'B65537'

poi-user | Andreas Reichel | 2 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

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

    poi-user | 2 years ago | Andreas Reichel
    java.lang.IllegalStateException: Need book to evaluate name 'B65537'
  2. 0

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

    poi-user | 2 years ago | Andreas Reichel
    java.lang.IllegalStateException: Need book to evaluate name 'B65537'

    Root Cause Analysis

    1. java.lang.IllegalStateException

      Need book to evaluate name 'B65537'

      at org.apache.poi.ss.formula.FormulaParser.parseNonRange()
    2. POI
      FormulaParser.parse
      1. org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:543)
      2. org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:416)
      3. org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:237)
      4. org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1126)
      5. org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1086)
      6. org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1073)
      7. org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1433)
      8. org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1533)
      9. org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1517)
      10. org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1474)
      11. org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1454)
      12. org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1575)
      13. org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:145)
      13 frames