[Libreoffice-ux-advise] [Bug 115241] CALC: See cells with conditional formatting set

[bugzilla-daemon at bugs.documentfoundation.org]

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

Heiko Tietze <tietze.heiko at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1

--- Comment #1 from Heiko Tietze <tietze.heiko at gmail.com> ---
(In reply to Timur from comment #0)
> It's be useful to have an option in Calc to see which cells have conditional
> formatting set. I'm proposing 3 alternative ways to mark them.
> 
> 1. Add an option "Preview Condition" in Tools - Options - LibreOffice Calc -
> View and also in View menu (like Value Highlighting). 
> Maybe to preview conditional formatting like a condition is set, or some of
> them of there are more.

Good idea. But is the request really completely new or just an enhancement to
the value highlight thing? I mean we can integrate the depiction of conditional
formatting into the existing function.

> 2. Include conditional formatting in Value Highlighting.
> (Currently: Text cells are formatted in black, formulas in green, number
> cells in blue, and protected cells are shown with light grey background.)

That wont work as you can highlight the cell background (e.g. "bad" for <0) or
the font (e.g. "footnote"). The whole idea of using colors as the primary
method of information is doomed from the beginning. Excel has the small
triangles, we could do the same or go with small icons. If the function is
supposed to be activated temporarily only it could switch off  the user/style
formatting shortly.

> 3. Add an option "Mark" in Format-Conditional Formatting and in Conditional
> Formatting drop-down icon. 
> Maybe with yellow button.

Sounds like an overkill to me. No need for special treatment IMHO.

-- 
You are receiving this mail because:
You are on the CC list for the bug.