Joerg, because my application is a standalone java application..
-Vishal -----Original Message----- From: Joerg Heinicke [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2003 12:22 AM To: [EMAIL PROTECTED] Subject: Re: Excel: Unable to apply formula SUM 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
