<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:libreoffice@nisz.hu" title="NISZ LibreOffice Team <libreoffice@nisz.hu>"> <span class="fn">NISZ LibreOffice Team</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Filter By Color: allow multiple selection"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142522">bug 142522</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;">CC</td>
<td>
</td>
<td>libreoffice@nisz.hu
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Filter By Color: allow multiple selection"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142522#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Filter By Color: allow multiple selection"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142522">bug 142522</a>
from <span class="vcard"><a class="email" href="mailto:libreoffice@nisz.hu" title="NISZ LibreOffice Team <libreoffice@nisz.hu>"> <span class="fn">NISZ LibreOffice Team</span></a>
</span></b>
<pre>Created <span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=172406" name="attach_172406" title="Example file from Excel">attachment 172406</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=172406&action=edit" title="Example file from Excel">[details]</a></span>
Example file from Excel
My Excel 2019 does not allow two background or text colors to be used as
filter, see in this example file.
Allowing filtering with two colors could cause interoperability issues such as
losing one of the filtering colors on XLSX saving or invalid XLSX (since Excel
does not allow two colors, it would likely freak out from seeing two colors as
filter criteria and ditch the complete autofilter).
So this overall idea is a -1 from me.
Cheers
Gabor</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>