https://bugs.documentfoundation.org/show_bug.cgi?id=150264
--- Comment #17 from Mike Kaganski <[email protected]> --- (In reply to Heiko Tietze from comment #16) > To my understanding the request is about a checkbox that converts input by > all means into the given format. Ah :) No, and please note that your wording reflects the usual misconception - so let's together please avoid this confusion: not "convert to format", but "convert to a specific data type". Again: this is very important difference. > "Validate dates..." is not generic enough I agree - the request (and its title) wording is too restrictive, and is dictated by the user's use case; my explanation in comment 2 and comment 11 does not limit he types. > and validation sounds like feedback. I do not quite get you; in my understanding, that was meant by OP to describe "validate if the text in cells matches the format before converting the data type" - so e.g. if user selected "DD/MM/YYYY" format, then the conversion would *first* check if the string in the cell matches this format (it has three parts separated by slashes; the first part is two-character, having a number in 1-31 range; second is two-character, having a number 1-12; and third is four-character, consisting on digits), and only then convert. I myself do not have an opinion how much such a check could be useful/implementable. > So I imagine something like "[ ] Convert data to the specified format". Yes, matches the second * in comment 2. > And the "by all means" is what bothers me. It *seems* to me that the first (and before my response, the only) mention of "by all means" in this issue was yours ;) > What I'd expect, again, is an automatic but rather conservative > detection of the input format. Without options. No options was proposed up to now; the only "optional" thing was to perform (or not perform) the conversion itself. -- You are receiving this mail because: You are the assignee for the bug.
