poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nagaraj_K <Nagara...@satyam.com>
Subject RE: HSSF, User-defined cell formats
Date Mon, 17 Nov 2003 03:44:07 GMT
Hi,
Did u have a look at getting cell reference using AreaReference ?? Guess
that might be of some help...
copied to the next cell below...use some generic logic where u add the
parameter value to the char value of "A" so that u can get the reference of
the cells....

Nags


-----Original Message-----
From: Suma G Shanthappa [mailto:suma.shanthappa@cgi.com]
Sent: Monday, November 17, 2003 9:08 AM
To: POI Users List
Subject: Re: HSSF, User-defined cell formats


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
************************************************************************** 
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
**************************************************************************

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message