https://bugs.documentfoundation.org/show_bug.cgi?id=163724
--- Comment #10 from Eyal Rozenberg <[email protected]> --- (In reply to Heiko Tietze from comment #9) > (In reply to Eyal Rozenberg from comment #8) > > > You are using 12-hour locale settings. > > That doesn't matter. I did not ask for a reformat. > You configure something and expect to be asked anyway? Well, most other > users would reject this. I did not configure a request to reformat pasted text. > > ignoring a common date-time format because it does not correspond to the > > app... > Is 1.1 the first of January or a real value? Is Mos/4 a chapter from the > bible or some localization? Of course, you may ask to solve the issue with > AI... (1.) How many options to interpret 2000-12-31 17:30 are you aware of? (2.) We can use the fact that a column contains many cells to better guess the appropriate format. (3.) If there are multiple options - we can offer them as a list. Even when there are multiple possibilities for the format of a column - it's still a very small number. Specifically, There are only 3 date field orders used on earth: https://i.redd.it/tq41jwj7xzv91.png and even if you want to consider pairs of date fields, there are only 6 of those. And there are even less time formats. (4.) Offering multiple interpretations can always have the "don't interpret anything, just paste the plain strings", which right now, we don't even have. -- You are receiving this mail because: You are the assignee for the bug.
