https://bugs.documentfoundation.org/show_bug.cgi?id=152967
Bug ID: 152967
Summary: Custom number formatting for timecode "d" is one off
Product: LibreOffice
Version: unspecified
Hardware: All
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Greetings
Using Libre Office 7.1.7.2, Build c6a4e3954236145e2acb0b65f68614365aeee33f
on a German Mac OX X 10.15.7, Catalina, powerbook, set in the OS control panel
to use the english language for this app.
When formatting a cell with a custom time format containg a "d" for days the
shown value is one off (too high).
E. g. use a cell containing numerical 12.5 (i.e. twelve and a half days) the
format code [d " d " h " h "] should return '12 d 12 h'; it returns '13 d 12
h'.
Happens also, when the app is set to native German format on the machine.
Very annoying when you try to display time intervals and two cells with
identical dates (subtraction resulting in "0") are allegedly one day apart.
Took me a while to notice....
BTW: a numerical -1.5 is displayed as '30 d 12 h' - so there.
Cheers
J W
--
You are receiving this mail because:
You are the assignee for the bug.
