poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Suma G Shanthappa" <suma.shantha...@cgi.com>
Subject Re: HSSF, User-defined cell formats
Date Mon, 17 Nov 2003 03:38:09 GMT
try this.....
String data = "3";
cellStyle = workbook.createCellStyle();
cellStyle.setDataFormat(				
	dataFormat.getFormat("#.0000");
cell.setCellStyle(cellStyle);
cell.setCellValue( data);


Can somebody help me on this...
I want to copy formula from one cell to a cell below/next to it.
How do I do it? Ex: If the formula in the cell is SUM(a2:a5) and if 
copy it to a cell below it the formula copied should be SUM(b2:b5).

Regds,
Suma

----- Original Message -----
From: Dimitri Pissarenko <dimitri.pissarenko@gmx.net>
Date: Monday, November 17, 2003 2:12 am
Subject: HSSF, User-defined cell formats

> Hello!
> 
> I want to create an Excel report with POI, where the numbers are
> formatted in the following way:
> 
> 0.0000
> 
> Such a format does not exist among the built-in HSSF data formats
> (according to
> http://jakarta.apache.org/po).
> 
> How can I create a user-defined data format?
> 
> TIA
> 
> Dimitri Pissarenko
> 
> -------------------------------------------------------------------
> --
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


Mime
View raw message