cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joerg Heinicke <joerg.heini...@gmx.de>
Subject Re: Excel: Unable to apply formula SUM
Date Thu, 14 Aug 2003 07:22:15 GMT
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


Mime
View raw message