I have created a very simple formula that doesn't seam to work in HSSF. The formula is as follows:

cell.setCellFormula(222222-111111)

When I do this I get an Exception as follows:

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

The strange thing is that I can use smaller numbers with no problems. For example cell.setCellFormula(22-11) works just fine. Does anyone have any ideas on this?

Thanks,

Brian Andersen


--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to