java.lang.NumberFormatException: Value out of range. Value:"40000" Radix:10

poi-user | Amol Deshmukh | 1 decade ago
  1. 0

    cell formula "40000" throws NumberFormatException: Value out of range

    Apache Bugzilla | 1 decade ago | amolweb
    java.lang.NumberFormatException: Value out of range. Value:"40000" Radix:10
  2. 0

    Formula: "40000/2" gives exception

    poi-user | 1 decade ago | Amol Deshmukh
    java.lang.NumberFormatException: Value out of range. Value:"40000" Radix:10
  3. 0

    DO NOT REPLY [Bug 33160] New: - cell formula "40000" throws NumberFormatException: Value out of range

    poi-dev | 1 decade ago | bugzilla@apache.org
    java.lang.NumberFormatException: Value out of range. Value:"40000" Radix:10
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Re: Formula: "40000/2" gives exception

    poi-user | 1 decade ago | Danny Mui
    java.lang.NumberFormatException: Value out of range. Value:"40000" Radix:10
  6. 0

    Re: Formula: "40000/2" gives exception

    poi-user | 1 decade ago | Avik Sengupta
    java.lang.NumberFormatException: Value out of range. Value:"40000" Radix:10

  1. danleyb2Interintel 2 times, last 5 months ago
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.lang.NumberFormatException

    Value out of range. Value:"40000" Radix:10

    at java.lang.Short.parseShort()
  2. Java RT
    Short.parseShort
    1. java.lang.Short.parseShort(Unknown Source)
    2. java.lang.Short.parseShort(Unknown Source)
    2 frames
  3. org.apache.poi
    IntPtg.<init>
    1. org.apache.poi.hssf.record.formula.IntPtg.<init>(IntPtg.java:58)
    1 frame
  4. POI
    HSSFCell.setCellFormula
    1. org.apache.poi.hssf.model.FormulaParser.Factor(FormulaParser.java:486)
    2. org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:548)
    3. org.apache.poi.hssf.model.FormulaParser.Expression(FormulaParser.java:596)
    4. org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:700)
    5. org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula(HSSFCell.java:678)
    5 frames