https://bugs.documentfoundation.org/show_bug.cgi?id=136615
--- Comment #35 from Eike Rathke <er...@redhat.com> --- Anyway, the Excel design of using floating point values to express date+time is fundamentally wrong, and with that inaccuracies are inevitable. Rounding in one or the other direction will produce wrong values for some cases no matter what and is only cosmetic to calm the user. The real solution would be to get rid of that and use a proper DateTime type instead and convert to floating point only when needed, e.g. when exporting to Excel file formats or calculations require it or if a floating point display is requested. -- You are receiving this mail because: You are the assignee for the bug.
