<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - CALC: Dynamic conditional colour formatting in autofiltered arrays"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138478">138478</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>CALC: Dynamic conditional colour formatting in autofiltered arrays
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.0.3.1 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>that.man.colin@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>The function [SUBTOTAL] will provide the defined analysis - sum, min, max, avg,
etc., for the displayed cells from within an autofiltered array.
If the component cells are also subject to Format > Conditional > Colour Scale
then prior to the auto filtering, the colour rendition is graduated across the
entire range of the cell values.
Following auto filtering, the colour rendition does not change so the
likelyhood is that all the cells will be varying hues of the same colour if
multiple instances of a similar event are filtered.
I feel it would be appropriate for the user to be in a position to define that
the colour scale should re-define itself to represent the low, middle & high
values of the resulting display, thereby more clearly highlighting the cell
value extremes.
Perhaps a radio button either with the colour scale definition or the
[SUBTOTAL] function which is defaulted to static evaluation. That is to say -
the user MUST choose a dynamic colour rendition.
I'm not sure if eXcel has a similar facility but obviously, importing and
exporting are a major consideration if Dynamic Colour Scaling proves to be
unique to LO.
Note: [SUBTOTAL] obviously provides values for min, max, etc., but there's
still a significant effort required to "scan" a list of potentially similar
values to identify those most closely matching the defined SUBTOTAL</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>