Description: Conditional formatting does not work maybe due to conflict with format cell Steps to Reproduce: 1.Create or use an existing conditional formatting 2.Apply it to a cell or a range 3. Actual Results: It does not work. The format cell prevail over it. Expected Results: Not result Reproducible: Always User Profile Reset: Yes Additional Info: Best explanation in the attachment. I don't know if it is related to 82765 bug.
Created attachment 150663 [details] A spreadsheet that explains better the problem
could you please check if your issue is a duplicate of: Bug 117715 - Settings from Conditional formatting shouldn't overwrite direct formatting https://bugs.documentfoundation.org/show_bug.cgi?id=117715
In this case (as far as I understood from the example) it is the other way around and works as intended. A hard/direct format applied overrides / has precedence over a conditional format of the same type (number,font,bold,...) (which in turn overrides a format applied from a style). Not a bug.
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 bug 93300: “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.
Created attachment 151003 [details] Performance Condit and Direct Formatting
Created attachment 151004 [details] Summary of bugs
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone else confirms it.
Correcting status.