https://bugs.documentfoundation.org/show_bug.cgi?id=164052
Bug ID: 164052
Summary: Inconsistent calculation with cells formatted as HH:MM
and [HH];MM
Product: LibreOffice
Version: 7.6.2.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 197801
--> https://bugs.documentfoundation.org/attachment.cgi?id=197801&action=edit
Sample file to test
Operate with HH:MM formatted cells in a [HH]:MM formatted cell and the result
will be inconsistent.
Cell A1, HH:MM formatted, with content "24:01:00":
you see "00:01",
and in the formula bar and in the status bar "Sum: 24:01:00".
Cell A2, HH:MM formatted, with content "=A1*2":
you see 00:02 (consistent with shown value in A1),
and in the status bar "Sum: 48:02:00" (inconsistent with shown value,
consistent with hidden value).
Cell A3, [HH]:MM formatted, with content "=A1*2":
you see 48:02 (inconsistent with shown value in A1),
and in the status bar "Sum: 48:02" (consistent with shown value, consistent
with hidden value).
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 60(Build:1)
CPU threads: 4; OS: Linux 5.14; UI render: default; VCL: gtk3
Locale: es-MX (en_US.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
