<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:tietze.heiko@gmail.com" title="Heiko Tietze <tietze.heiko@gmail.com>"> <span class="fn">Heiko Tietze</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - CALC: See cells with conditional formatting set"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=115241">bug 115241</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - CALC: See cells with conditional formatting set"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=115241#c1">Comment # 1</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - CALC: See cells with conditional formatting set"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=115241">bug 115241</a>
from <span class="vcard"><a class="email" href="mailto:tietze.heiko@gmail.com" title="Heiko Tietze <tietze.heiko@gmail.com>"> <span class="fn">Heiko Tietze</span></a>
</span></b>
<pre>(In reply to Timur from <a href="show_bug.cgi?id=115241#c0">comment #0</a>)
<span class="quote">> 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.</span >
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.
<span class="quote">> 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.)</span >
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.
<span class="quote">> 3. Add an option "Mark" in Format-Conditional Formatting and in Conditional
> Formatting drop-down icon.
> Maybe with yellow button.</span >
Sounds like an overkill to me. No need for special treatment IMHO.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>