cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mehra, Vishal" <vme...@inovant.com>
Subject RE: Excel: Unable to apply formula SUM
Date Thu, 14 Aug 2003 17:46:32 GMT
Joerg,

because my application is a standalone java application..

-Vishal

-----Original Message-----
From: Joerg Heinicke [mailto:joerg.heinicke@gmx.de]
Sent: Thursday, August 14, 2003 12:22 AM
To: users@cocoon.apache.org
Subject: Re: Excel: Unable to apply formula SUM


Why don't you use the Gnumeric file format instead of writing Java code?

Joerg

Mehra, Vishal wrote:

> 
> Created Excel worksheet using POI. All the cell values are formatted as string. 
> 
>           cell = currentRow.createCell( (short) i);
>           cell.setCellType(HSSFCell.CELL_TYPE_STRING);
>           cell.setCellValue(columnValue);
> 
> I am unable to apply SUM (or AutoSum) formula on the numeric values. After opening the
Excel file,
> I even tried to format all the cells as numeric/accouting,.... but with no success. 
> 
> SUM is always coming as zero...
> 
> Any pointers...
> 
> Thanks,
> 
> Vishal


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message