<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 - FILEOPEN XLSX Conditional text format colors not considered by color filter"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142580">142580</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILEOPEN XLSX Conditional text format colors not considered by color filter
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.2.0.0 alpha1+ Master
</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>Keywords</th>
<td>implementationError
</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>libreoffice@nisz.hu
</td>
</tr>
<tr>
<th>CC</th>
<td>m.weghorn@posteo.de, nemeth@numbertext.org, samuel.mehrbrodt@allotropia.de, varga.balazs3@nisz.hu
</td>
</tr>
<tr>
<th>Blocks</th>
<td>103512
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=172489" name="attach_172489" title="Example file from Excel with text color conditional formatting">attachment 172489</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=172489&action=edit" title="Example file from Excel with text color conditional formatting">[details]</a></span>
Example file from Excel with text color conditional formatting
Attached example file from Excel demonstrates a difference in behaviors: when
cells are formatted by text color and conditional format both, Excel offers the
conditional format text colors for filtering by color while Calc does not.
Steps to reproduce:
1. Open attached file
2. Dropdown the B1 autofilter, select Text color
Actual results:
Text color option offers orange color only.
Expected results:
Text color should also offer the blue and green text colors defined by
conditional format along the orange.
Also this should happen with new Calc files in the editor.
LibreOffice details:
Version: 7.2.0.0.alpha1+ (x64) / LibreOffice Community
Build ID: 187136265d26c014e842550c2f1fc5997736e4fa
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL</pre>
</div>
</p>
<div id="referenced">
<hr style="border: 1px dashed #969696">
<b>Referenced Bugs:</b>
<ul>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] AutoFilter-related bugs and enhancements"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=103512">Bug 103512</a>] [META] AutoFilter-related bugs and enhancements
</li>
</ul>
</div>
<br>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>