how stupid am I !!!!
i thought that this kind of typo will have generate parsing error....
Thanks a lot Jeff i'm going to buy glasses !
----- Original Message -----
From: "Jeff Nadler" <[EMAIL PROTECTED]>
To: "POI Users List" <[EMAIL PROTECTED]>; "laurent marot"
<[EMAIL PROTECTED]>
Sent: Thursday, November 27, 2003 5:18 PM
Subject: Re: [HSSF] Problem with SUM formula
> The second formula is missing an end paren:
>
> c.setCellFormula("SUM(H2:H6)");
>
> -Jeff
>
> ----- Original Message -----
> From: "laurent marot" <[EMAIL PROTECTED]>
> To: "POI Users List" <[EMAIL PROTECTED]>
> Sent: Thursday, November 27, 2003 4:43 AM
> Subject: [HSSF] Problem with SUM formula
>
>
> > Hi all,
> >
> > i'm facing a problem whith setCellFormula.
> >
> > i'm trying to set a SUM formula in a cell.
> >
> > When i use :
> >
> > c.setCellFormula("H2+H3+H4+H5+H6");
> >
> > everything works fine, but i'd like to use :
> > c.setCellFormula("SUM(H2:H6");
> >
> > and after several tries, Excel crashes when i use the second formula
> >
> > i'm a newbie to HSSF ( using POI 2.0 RC1 - 20031102 ) and i'd like to
know
> > what i'm doint wrong. any advice to solve this problem ?
> >
> > thanks a lot
> >
> >
> > ---------------------------------------------------------------------
> > 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]
