Thank you for the reply. Actually it is a String (I just didn't type it
correctly in the email). It is really is follows:
String formula = "222222-111111";
cell.setCellFormula(formula);
KHZ (SAW) wrote:
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
