https://bugs.documentfoundation.org/show_bug.cgi?id=150264
--- Comment #18 from C.Rogers ---
Yes, this is precisely what I would expect. No feedback, but a very
conservative one to one conversion. I also agree with changing to "Convert data
to specified format". I agree that validation sounds
https://bugs.documentfoundation.org/show_bug.cgi?id=150264
Heiko Tietze changed:
What|Removed |Added
Keywords|needsUXEval |needsDevAdvice
https://bugs.documentfoundation.org/show_bug.cgi?id=150264
--- Comment #17 from Mike Kaganski ---
(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
https://bugs.documentfoundation.org/show_bug.cgi?id=150264
--- Comment #16 from Heiko Tietze ---
(In reply to Mike Kaganski from comment #15)
> > And having such an option that forces input into a specific format
>
> I didn't understand that. What is "an option that forces input into a
>
https://bugs.documentfoundation.org/show_bug.cgi?id=150264
--- Comment #15 from Mike Kaganski ---
(In reply to Heiko Tietze from comment #14)
What does that mean? I fail to follow what confused you.
Did you get confused how that data could be inserted with the "unexpected"
types?
It may come
https://bugs.documentfoundation.org/show_bug.cgi?id=150264
--- Comment #14 from Heiko Tietze ---
I'm having a hard time to imagine the actual conversion. For example 04/07/2022
could be MM/DD/ or DD/MM/, 4/7 a date or a fraction, 4.7 a number or a
date with missing dot etc. And having
https://bugs.documentfoundation.org/show_bug.cgi?id=150264
QA Administrators changed:
What|Removed |Added
Status|NEEDINFO|UNCONFIRMED
Ever
https://bugs.documentfoundation.org/show_bug.cgi?id=150264
--- Comment #13 from QA Administrators ---
[Automated Action] NeedInfo-To-Unconfirmed
--
You are receiving this mail because:
You are on the CC list for the bug.
https://bugs.documentfoundation.org/show_bug.cgi?id=150264
--- Comment #12 from C.Rogers ---
Exactly this ^
Though functionally, it's to prevent the user having to manually remove the '
from every cell in order to convert the cell contents to the cell data type
when there is already a 1 to 1
https://bugs.documentfoundation.org/show_bug.cgi?id=150264
--- Comment #11 from Mike Kaganski ---
The UX problem is that people tend to confuse (mix) formatting to cell data
type.
In Calc, a cell can contain a text, a number, or a formula. The actual type of
data in the cell is defined at entry
https://bugs.documentfoundation.org/show_bug.cgi?id=150264
--- Comment #10 from Heiko Tietze ---
(In reply to C.Rogers from comment #8)
> It's for when changing the cell data type of many cells at once.
Still don't understand what functionality the checkbox adds. Maybe someone
smarter than me
https://bugs.documentfoundation.org/show_bug.cgi?id=150264
--- Comment #9 from C.Rogers ---
It's functionally equivalent to what Calc does when importing a CSV and the
user chooses "Date" as a data type for a column. Calc runs through and
validates all the cells in that column and converts. This
https://bugs.documentfoundation.org/show_bug.cgi?id=150264
--- Comment #8 from C.Rogers ---
When the user is simply entering values, they do not see the Format Cells
dialogue. This checkbox only for when the user is using that dialogue. Nothing
else is meant to change. Indeed, it should not.
https://bugs.documentfoundation.org/show_bug.cgi?id=150264
--- Comment #7 from Heiko Tietze ---
(In reply to C.Rogers from comment #6)
> I believe that strings appear on the left of the cell...
And we have View > Value Highlighting. But what should happen when the entered
value is a mismatch to
https://bugs.documentfoundation.org/show_bug.cgi?id=150264
--- Comment #6 from C.Rogers ---
I believe that strings appear on the left of the cell, and numbers of the
correct format on the right. This is plenty of feed back that the string is
unchanged to the number format. Also, the string
https://bugs.documentfoundation.org/show_bug.cgi?id=150264
Heiko Tietze changed:
What|Removed |Added
CC||libreoffice-ux-advise@lists
16 matches
Mail list logo