poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sasha Borodin <sa...@whoissasha.com>
Subject Large numbers in formula
Date Thu, 29 Jan 2004 02:33:27 GMT

Thanks to the POI team for such a massive undertaking and great results.

I'm having an issue trying to setCellFormula(myFormulaString).

myFormulaString = "SUM(500000 + 1)"

Calling setCellFormula throws java.lang.NumberFormatException: Value out of
range. Value:"500000" Radix:10

However, if myFormulaString = "SUM(500*1000 + 1)"

...which is the same number but different representation, no exception is
thrown and everything is fine.

This is a doctored example to demonstrate that large numeral representations
passed to the setCellFormula function seem to cause the issue.  Can anyone
comment on this problem?  Is this something that's resolved in POI 2.0?

Thank you,

-Sasha Borodin

To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org

View raw message