Which version are you using? Its not something that I was aware of, so I doubt its fixed... maybe you can enter a bug in bugzilla.
On Thu, 2004-01-29 at 08:03, Sasha Borodin wrote: > Hello, > > 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
