standardnotes / forum

Support from other community members. For 1-on-1 help, please contact help@standardnotes.com.
https://forum.standardnotes.org
199 stars 8 forks source link

Spreadsheet showing ocasional strange insignifigant roundering error in simple subtraction. #3751

Open SR11980140 opened 1 month ago

SR11980140 commented 1 month ago

Describe the bug Sometimes simple subtraction results in strange rounding. as in 293.9 - 293.8 = 0.099999999999970, instead of 0.1. Screenshot 2024-09-22 122547

To Reproduce Steps to reproduce the behavior: As seen in attached screen shot. The same formula [ =if(B2, B2-B1, "") ] is duplicated for each successive row. 3 of the 10 rows show a strange small rounding error in the resulting math.

Expected behavior 0.2 - 0.1 = 0.1

Desktop (please complete the following information):

Smartphone (please complete the following information):

SR11980140 commented 1 month ago

Also, they didn't respond to changing the number of shown decimals in 3.195.0. But now seem to in 3.195.3.