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]
