https://bugs.documentfoundation.org/show_bug.cgi?id=135249
--- Comment #4 from Eike Rathke <[email protected]> ---
(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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
