[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

Heiko Tietze <heiko.tietze at documentfoundation.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|heiko.tietze at documentfounda |libreoffice-ux-advise at lists
                   |tion.org                    |.freedesktop.org
             Status|NEW                         |NEEDINFO

--- Comment #4 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
(In reply to ady from comment #2)
> * Menu "Tools > Options > Language Settings > Languages > Date acceptance
> patterns" does not accept an empty field

That would be a Schroedinger date - cell content is a date but not at the same
time. What you can do is to not accept input as date unless the year is added
too (21.8. becomes text if the acceptance pattern is D.M.Y without the D.M.).

See also https://bugs.documentfoundation.org/show_bug.cgi?id=156598

(In reply to waterplanttrader from comment #0)
> I have to import large sums of data and some data has dates some does not.
> Any data similar to a date or is a date not covered by your approved
> formats, gets changed to an "approved date format". I am getting flack for
> this, please help.

If we talk about the Text Import dialog, you can change the "Column type" to
Text in order to not read 21.8.2023 as a date value.

Does this help?

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