Joerg,
because my application is a standalone java application..
-Vishal
Sounds like you're using Poi, not Cocoon. Probably wrong list to ask this question then.
Geoff
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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
