[Libreoffice-ux-advise] [Bug 150264] FORMATTING: UI improvements to add automatic data validation of dates
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Mon Aug 15 13:21:58 UTC 2022
https://bugs.documentfoundation.org/show_bug.cgi?id=150264
--- Comment #17 from Mike Kaganski <mikekaganski at hotmail.com> ---
(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 on the CC list for the bug.
More information about the Libreoffice-ux-advise
mailing list