https://bugs.documentfoundation.org/show_bug.cgi?id=150264
--- Comment #14 from Heiko Tietze <[email protected]> --- I'm having a hard time to imagine the actual conversion. For example 04/07/2022 could be MM/DD/YYYY or DD/MM/YYYY, 4/7 a date or a fraction, 4.7 a number or a date with missing dot etc. And having such an option that forces input into a specific format might lead to the same trouble for users, just from the opposite side. Don't know to what extend we recognize values but given the input of test 4/7 04/07/2022 4.7 I expect A1 to be text, B1 too, C1 to become a date if the conversion can be done with the locale setting, and D1 a number (converted even when locale is using a comma). Should happen on loading, pasting, and direct input. And overwritten in the next run. Why do we need an option? -- You are receiving this mail because: You are the assignee for the bug.
