On 6/9/23 13:04, Agustin Martin wrote: > On Tue, Jan 10, 2023 at 06:43:23PM +0100, olaf wrote: >> Package: gnumeric >> Version: 1.12.53-1.1+b1 >> Severity: normal >> >> With request to take note. >> >> Dear Maintainer, >> >> after updating to the current version, I am noticing discrepancies with my >> entries in several documents. For example, sums like "9.95 €" are now >> displayed as "9.949999999993" and "6.4" as "6.40000000000004"; simple >> calculations like "=2.19/350" >> now say "=2.189999999999/0.349999999999998", etc. > > Same problem here after creating spreadsheet and saving it in > MS Excel 97/2000/XP format. Before saving it 3,5 and 4,7 are correctly > represented. Saving and loading it again renders 4,7 as > 4,7000000000000001776. > > The interesting thing is that if I create the same spreadshet in gnumeric > format, save it and reload it (all in gnumeric format), problem does not > appear. If I then save the file in above excel format and reload it, > problem is back with the saved excel file. >
Tested a bit more, trying to save in different formats from just created gnumeric file with "3.5" and "4.7". As said, "MS Excel 97/2000/XP" fails and renders 4.7 wrong as above after reload. However, following formats seem to work well: * Gnumeric XMP (.gnumeric) * ODF 1.2 strict and extended conformance (.ods) * ECMA 376 first and second edition (*.xlsx) Regards, -- Agustin
