https://bugs.documentfoundation.org/show_bug.cgi?id=150271
Bug ID: 150271
Summary: [UI//UX enhancement] clearly visible hint or tooltip
when entering a Conditional Formatting condition
Product: LibreOffice
Version: 7.3.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: piotr.os...@gmail.com
Description:
Generally in tools, whether it's a graphical or textual interface, it's good to
have some prompts telling us what we can do with a tool and explaining how we
can do it.
The basis of this report is that, using a spreadsheet, I wanted to highlight
some cell in green (emphasis: "good") by quickly typing the + sign and pressing
enter.
Steps to Reproduce:
And for this solution I opened the function:
Format --> Conditional --> Condition....
and here we are. I wanted to set a condition making: "when I type + then the
cell will turn green".
So I set:
Condition 1
Cell value > is equal to > +.
simply a solitary plus.
Actual Results:
And this condition did not work.
I spent several minutes trying to use other conditions "is not equal",
"contains", "does not contain".
Then I tried to enter some number, e.g. 1, and the cell finally turned green.
So I went back to some word e.g. abc - and still nothing came out. But
fortunately this time I got a hint in this condition maker. At the bottom of
the section it displayed a shy and faintly noticeable message: "Strings without
quotes are interpreted as column/row labels".
Expected Results:
And it was only then that I understood: I should type: "+" (plus in quotes).
Reproducible: Always
User Profile Reset: No
Additional Info:
The conclusion of these struggles is that if some user does not think to try to
type different types of characters (letters) then he will not be able to set
the correct condition in his formatting.
Such situations cause us to complete simple tasks only after a long time.
Sometimes in a few minutes, sometimes after searching the Internet or sometimes
even after a few days with a fresh mind.
If the tool interface had prompts clearly visible and easily accessible for
checking in the area of the window where we work, telling what we can do with
the tool and explaining how we can do it, this simple task in 99% of cases
would be completed by the user in 1-2 minutes.
What I suggest is either to add a case where we type in the field: +, -, %, (,
) and other characters that are part of formulas with a hint:
Eg. "This is a sign used in formulas. Fininsh your formula or write this text
in quotes".
Or: "To treat as text write in quotes".
Or maybe prepare a small cheat sheet that pops up when you hover over a field
or click on an icon in that field (like in GNOME Files or FreeCommander:
attached pictures 8 and 9).
--
You are receiving this mail because:
You are the assignee for the bug.
