https://bugs.documentfoundation.org/show_bug.cgi?id=147817
--- Comment #6 from Loren Amelang <lo...@psychoros.com> --- So I did some searching, and found a trail about a year old - where I _did_ change the default! Deep in a late night rabbit hole, following these instructions: https://ask.libreoffice.org/t/how-to-format-the-date/43077/6 ----- At “Date acceptance patterns:” you can see what entries are available. You can add your own. You can format cells for a date by going to Menu Format>Cells. There you select date. You can also specify a custom user-defined format at the bottom of the dialog box. ----- I'm a "YYMMDD" person. I wanted a way to enter dates with that format. Libre won't accept MMDD or other systems without non-numeric delimiters. "M.D" defaults to the current year, and was the closest I could find. But my lizard brain hated it, and I forgot I'd added it. The problem in this report turned out to be that it affects not only currently typed dates in date columns, but the handling of any number in any column that could possibly be an "M.D" date! Like dollar values... In columns that are not date formatted! I found I could choose "YYMMDD" as a display format for date columns: 220115 515.71 inet With Col.1 formatted as date, that shows 01/15/2022 when selected, but displays YYMMDD when not selected. Entering Ctrl+; works! Shows MM/DD/YYYY when selected, but displays YYMMDD when not selected. But entering "221010" in a column of similarly formatted dates shows 02/06/2505 selected, and displays 050206. Maybe it is just me, but that seems wrong! If a column is explicitly set to dates, you should be able to enter more dates formatted like what you see above your cell. And even more importantly, in columns that are NOT formatted as dates, the "Date acceptance patterns" should not affect the interpretation of numbers at all! I imagine changing this would create even more problems for people who are accustomed to this behavior. But I certainly don't understand why Libre applies date acceptance patterns to pre-existing numbers in non-date columns! Is there some separate mechanism for choosing only how an entry you are currently typing will be interpreted? -- You are receiving this mail because: You are the assignee for the bug.
