Created attachment 199591 [details] conditional formattings Hey. This is a looooong-standing issue (like 10 years or more), I've just never bothered to report ;-) I do have a rather complex spreadsheed with quite some conditional formattings. All of them always go over a few columns (sometimes single ones, sometimes ranges, sometimes lists or combinations thereof) and always from row 10 to 1400 (well at least in the current version of the document, in a year or so it may go from 10 to 1600). In the attached screenshot, you see the overview. Now, in that screenshot, I've already cleaned up most of the broken up ones already. For example: - The one AW10:AW14000 was broken up in something like: - AW1262:AW1400,AW10:AW1260 and an extra rule - AW1261 (with the same conditions/etc. ... just different cell ranges) - The same could happen with rules that go over multiple column like A10:C1400 (not in the image) - Sometimes, the broken out / new ones are not just single cells, but themselves ranges like AI1199:AI1200, sometimes also over multiple columns. In the image there's still one broken up rule contained: - the selected one (B10:EL1295,BH1296:EL1296,BH1297:EL1297,B1296:BG1297,B1298:EL1400) which actually seems to have suffered from multiple break ups. It should be simply B10:EL1400. And I (still) have some even much more severely broken up ones. Now the thing is: I don't understand how these break ups come to happen. I would understand it, if I'd move around columns/rows, add new ones, delete ones, etc. ... and when LO tries to adapt the existing rules to the changed columns/etc.. But I haven't changed the overall structure of the table since ... well the document was created 2007,... so probably few weeks after I've created it. The only thing I do change, is: - content in cells - appending new lines at the end (i.e. when 1400 are used up, I'll add the next 500 rows or so, but every time I do this, I actually check the conditional formatting rules, an that inserting[0] of row does even work correctly. Any ideas what could cause these break ups (cleaning them up is actually quite a nuisance ;-) ) Thanks, Chris. [0] I insert lines, cause the always last row contains a part of a "nice" border around the whole spreadsheet and I don't want to re-do this always.
Please take a look into tdf#87274
(In reply to m_a_riosv from comment #1) > Please take a look into tdf#87274 Christoph: should we close as duplicate of that request?
Hmm. Difficult to say. First, while the symptoms seem similar, the other report seems to describe that it occurs when actually changing the cell structure (and thus LibreOffice may have reason to break up the CF). In my case however, I'm pretty sure that I don't do this - if I copy and paste then only the raw contents in a cell, not the whole cell itself Yet still I get the break ups for no apparent reason? What could be is, that the break up isn't undone by a Undo operation. I.e. sometimes I accidentally do copy/paste the whole cell (which I immediately notice because of colours) but then I undo. If that doesn't apply to the CF, it could explain the spurious break up I see. Also, the other report seems to rather describe it as a nice-to-have feature... but even there I'd tend to rather consider it a bug. So... I can't really say whether or not it should be marked as a duplicate.
I vote for this really annoying bug, which can unawaringly cause quite a lot of hassle and superfluous manual cleanup work, in order to keep a maintainable list of rules. Situation's even worse, thanks to the absence of any useful editing functions in the 'manager', that would e. g. help you in cloning conditional format entries, to make splitting up area formatting rules easier, or using others as templates. Version here is 25.2.3.2 (AARCH64)
For newer version report, see also: https://bugs.documentfoundation.org/show_bug.cgi?id=169201