[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