https://bugs.documentfoundation.org/show_bug.cgi?id=165162
Bug ID: 165162
Summary: Improve UX around Conditional Formatting
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: needsUXEval
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-b...@lists.freedesktop.org
Reporter: heiko.tie...@documentfoundation.org
CC: libreoffice-ux-advise@lists.freedesktop.org,
lpra...@collabora.com
Blocks: 116221
LibreOffice has a Manage CF dialog that holds multiple, not necessarily related
entries of CF. The actual Add CF dialog allows to define multiple conditions,
all related to one range, in a non-standard UI. Excel does not allow those
combinations.
The whole workflow needs to be scrutinized and the concept challenged. Some
issues:
* the Manage CF dialog lacks of sorting (bug 105325)
* shows only a single condition without any indication of more (bug 164325)
* does not show the formatting
* could be improved by toggles to activate CF (bug 101553)
* the Add CF dialog becomes difficult to manage with growing number of cell
value options
* hides the formatting when switching to another condition
* allows strange combinations of all cell conditions and cell values
One potential solution is to "flatten the workflow" and to allow only one
condition per Add CF. This simplifies workflow on cost of flexibility, in
particular thinking of a toggle to activate a (combination of) CF. The
opportunity to (re)unify CF has been requested before (bug 87274) and could be
done in the Manage CF dialog only.
As for the Manage CF dialog I'd suggest to switch from the listview to a
treeview and show all information when expanded.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=116221
[Bug 116221] [META] Manage conditional formatting dialog bugs and enhancements
--
You are receiving this mail because:
You are on the CC list for the bug.
