<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 - Filter by Color does not work for colors, which are set by number format"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144549">144549</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Filter by Color does not work for colors, which are set by number format
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.3.0.0 alpha0+ Master
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (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>rb.henschel@t-online.de
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=175075" name="attach_175075" title="Example of Color in number format">attachment 175075</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=175075&action=edit" title="Example of Color in number format">[details]</a></span>
Example of Color in number format
It is possible now to filter on colors. However, that covers only text color
and background color. But it is possible to set colors in number-format. That
is in the predefined number formats done for negative numbers. But you can
define number-formats with other colors and other ranges too. Such example is
attached.
Number-formats with colors can be used for the y-axis in charts too.
To include colors from number-format in a filter is important for exchange with
Google Tables. That application considers colors set by number-format the same
as colors set by text format.</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>