[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-user
Subject:    Re: creating a cell with a reference with POI
From:       "Larry Goodman" <goodman.larry () gmail ! com>
Date:       2007-02-26 11:56:02
Message-ID: 97de41240702260356k42da2709ve54601979b88e348 () mail ! gmail ! com
[Download RAW message or body]


Simple (sort of):  use something like cell.setFormula("B3+C2"); as in:

....
cell = row.createCell((short)colNum);
String formula = "B13";
cell.setCellFormula(formula);
...

you could also reference another sheet in the same excel file with
"!sheet2B13" or whatever you programming requirements are.

Works for me...

Larry


On 2/26/07, esmili <amine.esmili@calyon.com> wrote:
>
> Hello,
>
> I'm trying to create an Excel sheet containing a cell having a reference
> to
> another cell in the same sheet, with POI.
> I tried to use efficiently the CellReference class, but I cannot get any
> result.
> I'm hoping there is a simple solution to this.
> Thanks
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>
>


[prev in list] [next in list] [prev in thread] [next in thread]