<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 - Priority ordering of conditional formatting in Calc as proposed in Bug 74074, Comment 19, a) does not work, b) is not sufficient."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=127252">127252</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Priority ordering of conditional formatting in Calc as proposed in Bug 74074, Comment 19, a) does not work, b) is not sufficient.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.0.0.beta2+
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</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>marc.claes9@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
This is a follow-up on <a class="bz_bug_link
bz_status_VERIFIED bz_closed"
title="VERIFIED FIXED - FORMATTING: Ability to rearrange order of conditions in conditional formatting dialogs"
href="show_bug.cgi?id=74074">bug 74074</a> (on which I added comments 21 to 23 - but
somewhat fumbled, I'm afraid... ;-)
I just installed v. 6.3.0.4, and I noticed following effects:
Ordering of the conditional formatting priority, as set in the “Conditional”
menu → “Manage...” item → “Edit...” pop-up window with the "Up"- and
"Down"-button, is not honored. Apparently (but this has not been tested in
further depth) "Colorscale"-types of conditional formatting seem to always have
top priority.
Steps to Reproduce:
Please see attachment file "Cond_Form_Ex_20190815.ods", in which I added
conditional formatting as well as normal formatting as follows (all formatting
and conditional formatting is done to range A2:Z55):
1. the full range A2:Z55 is coloured yellow (unconditional),
2. columns between row 2 and row 55 are colored depending on their value
between white (for minimum) and blue (for maximum) (do not be fooled by the
progressive coloring of the rows – that is an effect of their progressive
numbering, NOT of conditional formatting! The "Colorscale"-type cond.
formatting is to the COLUMNS!),
3. any non-numeric or non-empty cells in the range are colored red,
4. any column between row 2 and row 55 is greyed when the cell in row 1 (of
that column) is empty.
Actual Results:
grey has priority over red (see cell H52 and M52), but blue always has top
priority…
Expected Results:
priority to grey, then to red, then to blue (see order in “Conditional” menu →
“Manage...” item → “Edit...” pop-up window)
Reproducible: Always
User Profile Reset: No
Additional Info:
Additionally (but that is a feature request as well as a bug report...) when
multiple conditional formats apply (even to different – but overlapping! -
ranges), the order of priority of these should ALSO be changeable (with an “Up”
and “Down” button in “Conditional” menu → “Manage...” pop-up window)!
Help - About LibreOffice info:
Version: 6.3.0.4
Build ID: 1:6.3.0-0ubuntu0.18.04.1~lo2
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3;
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded</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>