Re: Excel: Unable to apply formula SUM

[Joerg Heinicke]

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]