[Libreoffice-bugs] [Bug 135249] If cell is formatted as time or duration, then allow inputs with parts greater than 59

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=135249

--- Comment #4 from Eike Rathke <erack at redhat.com> ---
(In reply to gabrielhml from comment #3)
> It is also possible that the person writes 1:1:40 but does not mean time
Which can always be prefixed with an ' apostrophe to force text.

> but more than that, it would be nice if as a general rule Calc would try to
> conform to the format of the cell. This would apply to other cases too.
That quickly leads into a hell of confusion, the more if empty cells are
formatted already. Number display formats are not input masks.

> For example, when I have a date cell, if I input "1/5" it identifies a date.
> But if I input "1/2" it identifies as simply a "half".
Only if AutoCorrection is enabled to change 1/2 to ½ which you can revert with
Ctrl+Z.

> In this case, if the cell is formatted as time, then it should override
> whatever other function and try to treat the cell as time.
An input of 1:123 quite certainly is not meant as time or duration.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200805/bc434657/attachment.htm>