https://bugs.documentfoundation.org/show_bug.cgi?id=145499
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords| |needsUXEval --- Comment #2 from Mike Kaganski <[email protected]> --- (In reply to Colin from comment #0) > I have even expanded the column width and formatted the maximum decimal > places and it is NOT the notorious anomaly where some numbers have the final > digit defined as 1 ie. 2,000000000000001 = 2 It is exactly it. To check: 1. Set column K's filter to display both cases of '73.6' 2. In T278, put formula '=RAWSUBTRACT($K$249;K278)' 3. Drag-copy it down to T1755 4. Observe that unlike other cells, T1755 displays -1.4210854715202E-14 However, I don't know if it's correct to display two entries "named" same, when they denote different values. Either they must have enough precision to allow user tell one from the other, or they should be grouped together. Otherwise, it's impossible to use them in reasonable manner. -- You are receiving this mail because: You are the assignee for the bug.
