<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 - Conditional Colour Scale Formatting incorrectly rendered: MAX & MEAN colours are reversed"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133746">133746</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Conditional Colour Scale Formatting incorrectly rendered: MAX & MEAN colours are reversed
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</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>normal
</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>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=161707" name="attach_161707" title="Simple small anonymised demonstration sheet">attachment 161707</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=161707&action=edit" title="Simple small anonymised demonstration sheet">[details]</a></span>
Simple small anonymised demonstration sheet
A simple colour scale on cell values ranging from zero to one appears to
reverse the colours assigned to the 50th percentile and max. Therefore, where
MAX should colour to Green it colours to yellow.
I cannot tell whether the sheet structure has become damaged internally but I
can confirm that other almost identical sheets [currently] function correctly.
I have even "copied" a correctly functioning sheet and re-entered data for the
desired subject but it still goes wrong.
Enclosing a fully functional sheet where it can be seen that the conditional
colour specification for column L should colour all the cells valued 1.00 as
GREEN but they insist upon reproducing as YELLOW.
Try selecting a block of 5 or MORE rows across any permutation of columns D to
H and simply deleting the data. The colours then reproduce correctly.
How interesting is that?
I imagine you will have better facilities for tracing the impact of changes to
these cells than I.</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>