[Libreoffice-bugs] [Bug 133919] FILEOPEN XLS Time values rounded incorrectly

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133919

--- Comment #8 from Aron Budea <baron at caesar.elte.hu> ---
Created attachment 167910
  --> https://bugs.documentfoundation.org/attachment.cgi?id=167910&action=edit
Sample with single time cell in XLSX

Bug isn't specific to XLS, here's an XLSX saved in Excel, with the time copied
over from the other sheet.

Note that the numerical value (whatever's shown of it in the formula bar) is
0.708333333332121 in the buggy case, and 0.708333333333333 in the case when
5:00 PM is entered in Calc. The latter, "good" value is produced if 5:00 PM is
entered in Excel, too, so it's a difference in "rounding" for display.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201207/5971aabf/attachment-0001.htm>