[Libreoffice-ux-advise] [Bug 156520] Date acceptance pattern keeps overriding my cells

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #7 from ady <adylo811517 at gmail.com> ---
> (In reply to ady from comment #5)
> > An empty field could, potentially, had meant "no pattern is (forced to be)
> > recognized as date".
> That's the point, cells always have some format and no patters means text.
> (And you can change this on import.)

The reporter might or might not refer (in part at least) to the importing
dialogue, but in comment 5 I wasn't.

Have one cell with default standard format and type in something that might
potentially be interpreted as date but that you don't want it to be interpreted
as such. Other than preceding the/each value with an apostrophe or
pre-formatting the cell(s) as text, the value will be interpreted as date.
Using the import dialogue has its own column-formatting capabilities - that's a
different case.

Usually this behavior is helpful, but for some reason the reporter is having a
different, almost opposite situation (with some resulting request). We all
raised valid questions; I would suggest waiting for feedback from the reporter
to clarify the use-case, needs, and request.

-- 
You are receiving this mail because:
You are on the CC list for the bug.