gnumeric XML doesn't show result of formula
- From: John Machin <sjmachin lexicon net>
- To: gnumeric list <gnumeric-list gnome org>
- Subject: gnumeric XML doesn't show result of formula
- Date: Sat, 02 Feb 2008 12:55:24 +1100
Hello,
Here's the results of a little experiment (start up the UI, type
=sqrt(2) into cell A1, save as ...) for a few varieties of XML
spreadsheet file formats:
[my comments in [], whitespace adjusted by me]
Excel 2007 .xlsx file:
<c r="A1">
<f>SQRT(2)</f>
<v>1.4142135623730951</v> [OK]
</c>
Excel 2003 "Save as XML Spreadsheet":
<Cell ss:Formula="=SQRT(2)">
<Data ss:Type="Number">1.4142135623730951</Data> [OK]
</Cell>
OpenOffice.org Calc 2.x .ods file:
<table:table-cell table:formula="oooc:=SQRT(2)"
office:value-type="float" office:value="1.4142135623731"> [only 14
digits of precision]
<text:p>1.41</text:p>
</table:table-cell>
Gnumeric [1.6.3, Windows] .gnumeric file:
<gnm:Cell Col="0" Row="0">=sqrt(2)</gnm:Cell> [no result at all]
Bug or feature? Is it fixed in the 1.8.1 release?
Cheers,
John
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]