Can you pls tell me how to use AreaReference? or will FunctionPtg help me any way for copying formula?
----- Original Message ----- From: Nagaraj_K <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > 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 <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > ------------------------------------------------------------------- > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > ************************************************************************ ** > 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
