[Bug 165162] New: Improve UX around Conditional Formatting

[bugzilla-daemon at bugs.documentfoundation.org]

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-bugs at lists.freedesktop.org
          Reporter: heiko.tietze at documentfoundation.org
                CC: libreoffice-ux-advise at lists.freedesktop.org,
                    lpranam at 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.