https://bugs.documentfoundation.org/show_bug.cgi?id=40528
Robert Lacroix <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|NEW |RESOLVED --- Comment #9 from Robert Lacroix <[email protected]> --- Note what the description said. "Basically the math being done for some values throws a .000000000000001 on to the value." This is a fundamental limitation in representing some numbers inside all computers, called Round-off Error, which can not be fixed but can be worked around. The round-off error appears as an extra amount in your calculated value because you subtracted an inexactly represented number from a number which is represented exactly. To work around the problem this causes in sorting, you must round the calculated value to an acceptable precision using the ROUND(value, digits) spreadsheet function in the formula of the column you are sorting. -- You are receiving this mail because: You are the assignee for the bug.
