<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_CLOSED bz_closed"
title="CLOSED NOTABUG - Conditional FORMATTING affected by Format cell"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124661#c4">Comment # 4</a>
on <a class="bz_bug_link
bz_status_CLOSED bz_closed"
title="CLOSED NOTABUG - Conditional FORMATTING affected by Format cell"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124661">bug 124661</a>
from <span class="vcard"><a class="email" href="mailto:absque6@gmail.com" title="absque6@gmail.com">absque6@gmail.com</a>
</span></b>
<pre>I have been studying 122697, 117715, 114860, 103793 and 93300 bugs.
I don´t know if the claimed consistency in 93300 was needed. If so, another
option would have been to keep the priority of conditional formatting (CF) over
direct formatting (DF) and force manually applied styles to behave the same way
than those applied using conditional format. It is known that in Format /
Conditional / Manage / Edit / Cell Range we can easily delete the cells that we
want afterwards to be direct formatted.
I don´t know what I'm missing here but I think now that DF overrides CF we are
loosing some of the power of CF. When we use CF we want an “extra” for a cell,
something else than DF gives. In the past both DF and DF made a good team: once
established the cell parameters with DF, CF arrived as a magician to change
automatically into your preferences using the wand “condition + predefined
styles”. Now a cell range with a conditional formatting will need to add at
least one more condition (or this is what I thought) to obtain the same results
than in the past. When the number of conditions for the cell increases the lost
of simplicity is evident or even impossible to achieve the desired aim.
I have attached a file to explain that and independent of that I realized in
this file that Calc has an strange or perhaps anomalous behaviour.
Maybe there is a third possibility: the chance of configure the priority in
Tools/Options/LibreOffice Calc/ (great) or in the selected cell range or in the
style (fantastic). Probably it is the same idea explained in <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - Style formatting overrides direct formatting when using conditional formatting"
href="show_bug.cgi?id=93300">bug 93300</a>:
“Another option would be to lock or unlock the properties of a style”. I don´t
know if that is not possible or a real nightmare for the programmers.</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>