seems like a bug.. can u provide the stacktrace?

On Fri, 2004-07-16 at 00:38, Brian Andersen wrote:
> 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]
> 


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

Reply via email to