Description: Please allow me to turn off date acceptance patterns. If I input any data, that is arranged anyway like a date, that I want to calculate later off of I get a date. Changing the cell format to number changes it to a value of the date it was changed to not the original values. Text format is useless to me as I am using the data to calculate off of. Forcing your preferences on me makes your software unusable to me. This is not a feature it is a virus. I have spent over 100 hours trying to make work arounds for this. Keep the Date acceptance pattern and just allow me to have no patterns in the field, or a check box to turn it off. Steps to Reproduce: 1.Type any into any field Jun 17. 2.Calc changes it to 06/17/23.(or whatever you have it changed to in "Date acceptance pattern") 3.Go to "Date acceptance pattern", find no off button. Actual Results: 06/17/23 Expected Results: Jun 17 Reproducible: Always User Profile Reset: No Additional Info: 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.
You are confusing date acceptance patterns and date formats. For 06/17/23 I assume your locale is English (USA) as that matches its default date format MM/DD/YY. A date entered is displayed in the locale's default date format unless entered in the ISO 8601 YYYY-MM-DD date format. The input "Jun 17" is accepted as June 17, 2023 (current year). If you want the date to still be displayed as "Jun 17" then format the cell with the date number format MMM DD. If you want the input to stay text then precede it with an ' apostrophe, so 'Jun 17
(In reply to Eike Rathke from comment #1) > You are confusing date acceptance patterns and date formats. For 06/17/23 I > assume your locale is English (USA) as that matches its default date format > MM/DD/YY. A date entered is displayed in the locale's default date format > unless entered in the ISO 8601 YYYY-MM-DD date format. The input "Jun 17" is > accepted as June 17, 2023 (current year). If you want the date to still be > displayed as "Jun 17" then format the cell with the date number format MMM > DD. If you want the input to stay text then precede it with an ' apostrophe, > so 'Jun 17 The request starts by "Please allow me to turn off date acceptance patterns". Whether there is some confusion between date format and date acceptance pattern, I can still see a valid request. At least 2 points to consider: * Menu "Tools > Options > Language Settings > Languages > Date acceptance patterns" does not accept an empty field (it is automatically set back to its default after pressing "apply"). * Depending on Language(s), Menu "Tools > Options > LibreOffice Calc > Sort Lists" includes items such as "Jun" (starting with "Jan", "Feb"...) which _maybe_ influences the behavior too(?). I am not sure (or don't recall ATM) which other settings or options can influence the recognition of "Jun 17" as a date, but probably there are such settings somewhere. I am changing this to ENHANCEMENT request.
(In reply to waterplanttrader from comment #0) > Expected Results: > Jun 17 If this _is_ supposed to be considered as a date, then change the number format ([CTRL]+[1]), as Eike mentioned in comment 1.
(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?
(In reply to Heiko Tietze from comment #4) > (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. We are not talking about a cell that is already formatted as date while trying to introduce a value without it being recognized as date. _That_ would be an inconsistent request. An empty field could, potentially, had meant "no pattern is (forced to be) recognized as date". To be clear, I am not requesting any change; I am only replying to what seem(ed) to be some kind of request from the reporter. Whether there is some actual request, or a misunderstanding, or lack of knowledge about how to achieve something in Calc, it is not completely clear to me ATM.
(In reply to Heiko Tietze from comment #4) > See also... https://help.libreoffice.org/7.4/en-US/text/shared/optionen/01140000.html (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.)
> (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.
(In reply to ady from comment #7) > The reporter might or might not refer (in part at least) to the importing > dialogue How? In comment 0 they say >> 1.Type any into any field Jun 17. That is no import dialog (assuming field==cell).
(In reply to Eike Rathke from comment #8) > (In reply to ady from comment #7) > > The reporter might or might not refer (in part at least) to the importing > > dialogue > How? In comment 0 they say > >> 1.Type any into any field Jun 17. > That is no import dialog (assuming field==cell). I agree. Please note my "might or might not refer". That was a reply to what Heiko mentioned in comment 4: " If we talk about the Text Import dialog " ...and in comment 6: " And you can change this on import " As I said, _I_ was not referring to the import dialogue in comment 5, and there is no clear indication that the reporter was referring to it either (but still possible); it was only introduced by Heiko. Once again, I would suggest awaiting for feedback from the reporter, who has been silent since comment 0, for several weeks ATM.
(In reply to ady from comment #9) > Once again, I would suggest awaiting for feedback from the reporter, who has > been silent since comment 0, for several weeks ATM. Waterplanttrader, please comment and reopen.