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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
