https://bugs.documentfoundation.org/show_bug.cgi?id=163344
Bug ID: 163344 Summary: Loading "14:30" time value from ODS produces a different result compared to DATE, DATEVALUE, or direct input Product: LibreOffice Version: unspecified Hardware: All URL: https://ask.libreoffice.org/t/copy-time-from-csv-to-od s-not-working-correct/112053/ OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: mikekagan...@hotmail.com Created attachment 196954 --> https://bugs.documentfoundation.org/attachment.cgi?id=196954&action=edit 14:30 stored in a spreadsheet In the attached FODS, there is "14:30" time value in A1 (stored as "PT14H30M00S"), and a formula in B1, comparing A1 to the result of TIME(14;30;0). In current master, as well as in e.g. Version: 6.0.0.3 (x64) Build ID: 64a0f66915f38c6217de274f0aa8e15618924765 CPU threads: 24; OS: Windows 10.0; UI render: default; Locale: en-US (ru_RU); Calc: CL the difference is around 1.11E-16, instead of expected 0. The actual double value in A1 is 0.60416666666666674, while TIME returns 0.60416666666666663 (1 ulp difference). This may result in unexpected results e.g. on sorting, as explained in https://ask.libreoffice.org/t/copy-time-from-csv-to-ods-not-working-correct/112053. -- You are receiving this mail because: You are the assignee for the bug.