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: RE: HSSF, User-defined cell formats
Date Mon, 17 Nov 2003 04:02:56 GMT
Can you pls tell me how to use AreaReference? or will FunctionPtg help 
me any way for copying formula? 

----- Original Message -----
From: Nagaraj_K <Nagaraj_K@satyam.com>
Date: Monday, November 17, 2003 9:14 am
Subject: RE: HSSF, User-defined cell formats

> Hi,
> Did u have a look at getting cell reference using AreaReference ?? 
> Guessthat 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 
> contactthe sender by email and delete all copies; your cooperation 
> in this regard
> is appreciated.
> 
************************************************************************
**
> 


---------------------------------------------------------------------
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