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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
