<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:lukebenes@hotmail.com" title="Luke <lukebenes@hotmail.com>"> <span class="fn">Luke</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Allow Changing Order of Outer Conditional Formats"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126047">bug 126047</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;">Summary</td>
<td>More flexibility to conditional formatting
</td>
<td>Allow Changing Order of Outer Conditional Formats
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>RESOLVED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>WORKSFORME
</td>
<td>---
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Allow Changing Order of Outer Conditional Formats"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126047#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Allow Changing Order of Outer Conditional Formats"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126047">bug 126047</a>
from <span class="vcard"><a class="email" href="mailto:lukebenes@hotmail.com" title="Luke <lukebenes@hotmail.com>"> <span class="fn">Luke</span></a>
</span></b>
<pre>Sounds like the 3 members of the UX team discussing this issue missed a major
point. Suggestion 1 is not some hypothetical, dream feature. It 1 is precisely
how Excel has worked for decades and it supported by both XSL and XLSX formats.
Users coming from other spreadsheet software expect to be able to order the
conditional formats (not just inner conditions). Since the original report was
overly broad, I propose we limit this report to just the first suggestion:
adding the capability to re-order outer conditions.
The current XLSX importer reverses the order of outer conditional formats. If
you save as ODF, there is no way to fix this issue without recreating the
conditions. Allowing re-ordering would improve interoperability and is the
behavior that users expect. See <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=114686" name="attach_114686" title="Sample XLSX showing issue with importing Data Bar">attachment 114686</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=114686&action=edit" title="Sample XLSX showing issue with importing Data Bar">[details]</a></span> for an example of how this
feature would be useful for fixing import errors along with giving LO users a
feature that Excel has had for years.</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>