<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 - FILESAVE XLSX Filter by color overwrites conditional format background setting"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142578">142578</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILESAVE XLSX Filter by color overwrites conditional format background setting
</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>filter:xlsx, 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>123807
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=172482" name="attach_172482" title="Example file from Calc">attachment 172482</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=172482&action=edit" title="Example file from Calc">[details]</a></span>
Example file from Calc
Attached example file has conditional formatting set on cells with background
color, and autofilter by color set on this color.
When saved to XLSX the conditional formatting color is overwritten with the
autofiltered background color.
Steps to reproduce:
1. Open attached file
2. Save as XLSX, reload
Actual results:
The B1:B3 cells background color changes from pink to green, text color changes
from red to black since it has changed in the Conditional Formatting dialog.
Expected results:
Conditional formatting style retained correctly.
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] XLSX Autofilter-related bugs"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123807">Bug 123807</a>] [META] XLSX Autofilter-related bugs
</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>