[Libreoffice-ux-advise] [Bug 150264] FORMATTING: UI improvements to add automatic data validation of dates

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=150264

--- Comment #14 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
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 on the CC list for the bug.