[Libreoffice-ux-advise] [Bug 115241] CALC, UI: There is no easy way to see the cells with conditional formatting

[bugzilla-daemon]

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

Heiko Tietze  changed:

   What|Removed |Added

   Keywords|needsUXEval |
 CC|libreoffice-ux-advise@lists |
   |.freedesktop.org|

--- Comment #6 from Heiko Tietze  ---
We have two Options:
#1: per selection via edit > select > (options) 
  + it's how Excel works but likely not what users have in mind
  + should work per find and replace dialog out of the box
#2: temporarily show an icon or triangle on cells
  + similar to non-printable characters on/off
  + ideally with option 1 for special use cases such as 
replace all conditional formattings by something else
Option 2 is my preference.

Not recommended are modification of color/font/shading etc.


The remaining question is what properties are in-scope (external data,
protected cells, ...) and what out-of scope or rather accomplished per extra
solutions (comments, tracked changes, ... )

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 115241] CALC, UI: There is no easy way to see the cells with conditional formatting

[bugzilla-daemon]

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

Heiko Tietze  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=11
   ||4997

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 115241] CALC, UI: There is no easy way to see the cells with conditional formatting

[bugzilla-daemon]

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

--- Comment #5 from Cor Nouws  ---
(In reply to Timur from comment #4)

> I suggested 1. for permanent highlighting, to add an option "Preview
> Condition" in Tools - Options - LibreOffice Calc - View and also in View
> menu (like Value Highlighting). 

One has to make sure that the 'highlighting' is visible, despite the CF.
I like the idea, however.

> Cor suggested (let's call 4.) temporary selection with Edit > Select > Cells
> with conditional formatting.

Weĺl, IMO it's mostly logic in line with the other functions there :)

I can live with both solutions.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 115241] CALC, UI: There is no easy way to see the cells with conditional formatting

[bugzilla-daemon]

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

--- Comment #4 from Timur  ---
What we agree is that there is no easy way to see the cells with conditional
formatting and we should be able to see cells with conditional formatting set.

I suggested 1. for permanent highlighting, to add an option "Preview Condition"
in Tools - Options - LibreOffice Calc - View and also in View menu (like Value
Highlighting). 
I stay with my option 1. for this bug, to see those cells if needed. 

Cor suggested (let's call 4.) temporary selection with Edit > Select > Cells
with conditional formatting.
Cor's suggestion is useful maybe to clear them all and can be another bug. Why
not have both.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 115241] CALC, UI: There is no easy way to see the cells with conditional formatting

[bugzilla-daemon]

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

Cor Nouws  changed:

   What|Removed |Added

Summary|CALC: See cells with|CALC, UI: There is no easy
   |conditional formatting set  |way to see the cells with
   ||conditional formatting

--- Comment #3 from Cor Nouws  ---
I suggest Edit > Select > Cells with conditional formatting

(Analogue to ... > Select Unprotected Cells )

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise