#1028408 gnumeric: Decimal places change by themselves.

Package:
gnumeric
Source:
gnumeric
Description:
spreadsheet application for GNOME - main program
Submitter:
olaf
Date:
2024-02-02 10:09:02 UTC
Severity:
normal
#1028408#5
Date:
2023-01-10 17:43:23 UTC
From:
To:
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.
#1028408#10
Date:
2023-03-06 12:07:31 UTC
From:
To:
severity 1028408 important
thanks

Hi,

Just to say that the same applies for me.  I have looked at the bur
reports
(https://gitlab.gnome.org/GNOME/gnumeric/-/issues/?sort=created_date&state=all&first_page_size=20),
and have not found it.  Given that formula results could be wrong, I
would raise the severity of this bug.

Thanks,
Eugen
#1028408#17
Date:
2023-09-06 11:04:54 UTC
From:
To:
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,
#1028408#22
Date:
2023-09-08 14:55:45 UTC
From:
To:
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,
#1028408#27
Date:
2024-02-02 09:59:10 UTC
From:
To:
Hi,

This email to say that it seems the bug seems to be fixed for me, I am
using gnumeric 1.12.56-2+b1 now.

Cheers,
Eugen