Hi Brian. Why don't you use a string?
Regards, Karl-Heinz. -----Urspr�ngliche Nachricht----- Von: Brian Andersen [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 15. Juli 2004 17:22 An: POI Users List Betreff: Simple Formula Problem 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
