[Libreoffice-bugs] [Bug 135249] Allow duration inputs of 0:mm or 0:0:ss with values >59, or 0:mm:ss with mm>59

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #7 from Mike Kaganski <mikekaganski at hotmail.com> ---
Thanks Eike! A nice change.

(In reply to Eike Rathke from comment #4)
> (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.

The same could be told about 1:1:123 ;-)

> > 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.

Both PoVs have pros and contras. I don't think that the "hell" would be larger
than now, and that comes not from some software problems, but from spreadsheet
concept (and tasks it is designed for) complexity, and general human laziness.

However, an increase of consistency would be a good thing. We already take
formatting into account when treating user input: first when a field is
formatted as text; then IIRC times vs durations started to be considered
recently ... and that goes against the "Number display formats are not input
masks" idea.

Personally I support the suggestion to extend consideration of cell formatting
when interpreting cell input. Like "first try to treat cell format as kind of
input mask; then consider general group of cell format; only then fall back to
normal processing". So a format like "DD/MM/YY" would result in considering an
input first as DMY; then as date (using configured acceptance patterns); then
generic processing (checking numbers, percents, currencies, times, formulas
etc...).

That would possibly be a major change, and could benefit from having a
configuration option, but that seems increasing consistency over current
situation (when we declare "formats are not masks, except here, and also here,
and again here...").

-- 
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/20200806/ff3347e4/attachment.htm>