Manfred, Yes, you are right one could open html, TAB delimited, or even CSV format files in Excel.
This will work for most of the cases, except :- (1) Formula's will not be supported by neither of the above 3 options (2) Formatting is not supported by TAB and CSV formats. (3) If the integer value of cell is large (say 16 digits), opening the above formats files in Excel will round off the last few digits. Not a desirable option in my case. BTW, my original problem with SUM is resolved. -Vishal -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2003 11:12 AM To: [EMAIL PROTECTED] Subject: Antwort: Excel: Unable to apply formula SUM Hallo, sounds a bit crazy, but may be, you should generate a HTML-File. This works well with Excel. Didn't have expierience with Gnumeric yet. Alternatively you may use a TAB-separated text file. Both methods are tested, but only unter Excel yet. In this way, you have to take care abotu the language, because Excel has language specific keywords, eg. SUM in 'enu' ist SUMME in 'ger'. May be, Gnumeric has not implemented this bug/feature. (1)--HTML--> <html><body><table> <tr> <td>51</td><td>22</td><td>73</td><td>94</td><td><b>=SUM(a1:d1)</b></td> </tr> </table></body></html> (1)--HTML--< Works well an gives you the possibility of formatting the text and the background (2)--TAB-separated-TEXT--> 51 22 73 94 =SUM(a1:d1) (2)--TAB-separated-TEXT--< Works also well but without any formating You have to deliver the files as excel-file-type (appicaltion/ms-excel), even if they are not realy in this format. Hope this helps with Gnumeric too and if so, please give me a feedback, because I need to support gnumeric soon. Many thanks. Greetings, Manfred. "Mehra, Vishal" <[EMAIL PROTECTED]> 14.08.2003 02:43 Bitte antworten an [EMAIL PROTECTED] An [EMAIL PROTECTED] Kopie Thema Excel: 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
