Bug 134687 - EDITING Missing automatic time conversion in hours when inserting minutes over 59
Summary: EDITING Missing automatic time conversion in hours when inserting minutes ove...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-07-09 10:55 UTC by egc
Modified: 2020-07-09 11:33 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description egc 2020-07-09 10:55:43 UTC
(I guess) starting with version 6.4 there is no automatic time conversion in hours anymore when inserting minutes higher than 59 like "0:104" minutes in a cell.
Until now this was automatically converted and interpreted as "1:44" (1 hour an 44 minutes), but now it shows only "0:104" as unknown value.
Comment 1 Mike Kaganski 2020-07-09 11:33:19 UTC
This is not a bug, but deliberate change - see https://git.libreoffice.org/core/+/7d72b9d34c1183b7471a7a97c007aba10de2d27e:

> Input with subsequent part greater than 59 is not time or duration
> 
> Like 1:123 or 1:1:123 is text, but 123:1 or 123:1:1 is a duration.

See also tdf#134455, where handling of invalid times was explicitly restored inside TIMEVALUE function.