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. Regards, -- Agustin