https://bugs.documentfoundation.org/show_bug.cgi?id=163895
--- Comment #3 from b. <[email protected]> --- hello @ Nicole, thanks for checking, 1. enter 0.9999999999999994 in cell A4, 2. see display 0.999999999999999 without trailing '4', 3. enter '=6 * A4' in A5, 4. see result '6' in A5, 5. save file as *.ods, 6. close sheet, 7. load file, 8. see result in A5 changed to 5.99999999999999, 9. assume value in A4 changed to 0.999999999999999, without the '4', 10. problem: differences between construction-time and run-time, 11. hard to understand, not user friendly, 12. wish: consistent behavior, either 12a. keep precision in file save and load, or 12b. truncate on input rather than file save, think that's what Excel doe's. -- You are receiving this mail because: You are the assignee for the bug.
