You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@poi.apache.org by "Mehra, Vishal" <vm...@inovant.com> on 2003/08/14 00:06:06 UTC

Unable to apply formula SUM

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: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org