https://bugs.documentfoundation.org/show_bug.cgi?id=156520
Heiko Tietze <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC|heiko.tietze@documentfounda |libreoffice-ux-advise@lists |tion.org |.freedesktop.org Status|NEW |NEEDINFO --- Comment #4 from Heiko Tietze <[email protected]> --- (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 the assignee for the bug.
