Anyone know stuff about how #Gnumeric represents decimal numbers and whether that has changed between Gnumeric versions?
Simplified example:
I have a .gnumeric file made with Gnumeric 1.12.35 (packaged by #Ubuntu, released 2017). It contains only the number 4.99 in cell A1. If I export it to CSV, I get a CSV file with 4.99.
I copy that file over to another computer and open it with Gnumeric 1.12.55 (packaged by #Debian, released 2023). In cell A1 I see the value 4.9900000000000002 (I didn't count the exact number of zeros). When I export it to CSV, I get that ...0002 as well.
When I create a file with 4.99 with Gnumeric 1.12.55 (the newer one), it saves as 4.99, it exports to CSV as 4.99, and when opened with Gnumeric 1.12.35 it shows up as 4.99 as well.
Computers are the same architecture, the one with old Gnumeric is an i5-8259U and with the new Gnumeric is an i7-8850H. If that matters, the OS with the old Gnumeric is a frankeninstall that I recall started out as Xubuntu 14.04 and was updated in fits and bursts.
I know about floating point decimal representation and its inherent issues. But the file I created with Gnumeric 1.12.35 was fine for all this time (exporting to CSV as well) and I am wondering if there's a setting in Gnumeric somewhere I can set so that both versions read 4.99. (That's a simplified example - the real thing is a spreadsheet with ten thousand values, I could possibly round them all but I'd rather do it only as last resort.)