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: [email protected]
Reporter: [email protected]
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.
