<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 formats of a XLSX-File are opened and saved in a different order than the original one. This breaks the documents appearance"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138601">138601</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Conditional formats of a XLSX-File are opened and saved in a different order than the original one. This breaks the documents appearance
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.0.3.1 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</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>tim.uniewski@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
I created a template in MS Excel which relies heavily in conditional formats.
The order of them is important, as they may overlap and are rendered in the
order defined in Excel.
If one user does open this file in LibreOffice and saves it, the conditional
format is broken.
Attached please find an example before and after opening it in LO.
Steps to Reproduce:
1. View the original file (attached) in Excel
2. Open it in LO and see the difference here.
3. Save the file in LO
4. Open it in Excel again and see that the original format is broken now.
Actual Results:
The conditional formatting is wrong after editing the file in LO
Expected Results:
The format should be untouched or at least the order of conditional formats
should not be changed.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.0.3.1 (x64)
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 12; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded
------
<span class="quote">> Is OpenGL enabled?</span >
I was not able to check this in 7.0.</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>