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]
