https://bugs.documentfoundation.org/show_bug.cgi?id=159421
Stéphane Guillou (stragu) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED CC| |stephane.guillou@libreoffic | |e.org Hardware|x86-64 (AMD64) |All Resolution|--- |DUPLICATE OS|Windows (All) |All --- Comment #2 from Stéphane Guillou (stragu) <[email protected]> --- Thanks for the report. I see the same in your sample document. Unfortunately, this is likely due to floating-point arithmetic imprecision common to many tools. If you use in cell G16 the following formula instead: =ROUND(F16*10000) ... the date will be as expected. You can also see how the DATE() formula will handle a value that is just under the target value, try this: =DATE(2021.9999999,4,15) See this help page: https://help.libreoffice.org/latest/en-US/text/scalc/01/calculation_accuracy.html There is an open report to improve the situation, so I will mark as duplicate as that one. *** This bug has been marked as a duplicate of bug 136615 *** -- You are receiving this mail because: You are the assignee for the bug.
