https://bugs.documentfoundation.org/show_bug.cgi?id=168673
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.documentfounda | |tion.org/show_bug.cgi?id=12 | |7334 --- Comment #4 from Mike Kaganski <[email protected]> --- The difference problem is likely related to the changes introduced in tdf#127334. Indeed, in v.7.6, the difference gives the expected ~5E-18, while in v.24.2, it is ~2E-14. A note: to avoid the locale-specific nature of TEXT function, the testing formulas can be =A1-VALUE(CONCATENATE(A1)) =VALUE(A1)-VALUE(CONCATENATE(A1)) =RAWSUBTRACT(A1;VALUE(CONCATENATE(A1))) -- You are receiving this mail because: You are the assignee for the bug.
