Re:Why Google Sheets ported its calculation worker from Java...
by mkl on Thursday June 27, 2024 @08:30PM
(#40816669)
That could be just the way it's displaying, e.g. to 14sf or something. If you try adding a million 0.1s and use a formula to compare to 100,000, that might tell you (with floats I got 100000.00000133288).
This question suggests it uses floats: https://stackoverflow.com/questions/74542790/google-sheet-yi...