Re: gnumeric XML doesn't show result of formula
- From: John Machin <sjmachin lexicon net>
- To: "Andreas J. Guelzow" <aguelzow pyrshep ca>, gnumeric list <gnumeric-list gnome org>
- Subject: Re: gnumeric XML doesn't show result of formula
- Date: Sun, 03 Feb 2008 07:22:58 +1100
Andreas J. Guelzow wrote:
I think that what you are trying to say is that it is impossible to
represent the square root of 2 exactly as a floating-point number. This
is true/well-known/irrelevant. What is of *practical* interest is the
actual FP result of evaluation of any formula, irrespective of whether
the result can be represented exactly or not. The two Excel outputs give
in this case what appears to be the nearest possible FP result. OO 2.x
records an inaccurate result. Gnumeric gives *ZERO* results.
On Sat, 2008-02-02 at 12:55 +1100, John Machin wrote:
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:
Excel 2003 "Save as XML Spreadsheet":
<Data ss:Type="Number">1.4142135623730951</Data> [OK]
OpenOffice.org Calc 2.x .ods file:
office:value-type="float" office:value="1.4142135623731"> [only 14
digits of precision]
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?
I don't see a bug or feature...
Excel 2007, 2003 and OO 2.x appear to give 2 values for each cell (and
those values are even the same since none of the given floating point
values are equal to the square root of 2.)
So Gnumeric is more consistent by giving just one value.
] [Thread Prev