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]
