[Issue] Cell defined names breaks conditional formatting !

[onidarbe]

For instance, column A is called in the first row 'ColA', b is 'ColB' ....
Now using "conditional formatting" with "formula is": 'ColB' > 'ColA'
Sometimes it works, sometimes it doesn't change the cell-format when the value in B is bigger then in A !???????

I also tried to set a defined name to every selected column. Seems there is a serious bug in Calc

[Hagar Delest]

It is a rather new bug it seems. You should subscribe and vote for it (up to 2 votes per issue) : Issue 83643 - Renaming Cell Style breaks Conditional Formatting.

You should add a comment because that issue has been re-tagged as enhancement and it's clearly a bug.

[huw]

That's my issue, Hagar, and it isn't the problem here (although I agree it's not an enhancement!).

The nearest issue I can see is 28589, although it isn't quite the same. I also think that one has been fixed in more recent releases.

I'm not very good with defined names so I'll leave this for someone else to have a look at.

Edit: typo.

[Hagar Delest]

Yes, you're right. I thought the cell name could have a link with the style somehow but you've found the right issue.

onidarbe, you should leave a comment to the latter because it had been accepted 3 years ago and then, ... nothing.

[acknak]

I'm not sure if this is a bug or not. Maybe I don't understand what you're trying to do.

When you define conditional formatting for a range, you specify it for one cell and then Calc will adjust the address over the range. E.g. if I select A1:B2 (with A1 as the current cell), I can make the conditional formula A1>B1, or $A1>$B1, but not A1:A2>B1:B2 or something like that.

So if the name 'ColA' somehow refers to the whole column, how do you expect that to work?

In fact, if I set up range names as "Col_A" as "$A1" and "Col_B" as "$B1", it works in a conditional formatting formula such as "Col_A > Col_B". The relative addresses are adjusted over the area where the conditional format applies.

[Hagar Delest]

For instance, column A is called in the first row 'ColA', b is 'ColB' ....

It seems that only single cells are renamed.

[huw]

I had a go defining as a name either whole columns, a range in a column, or single cells. I then tried each in conditional formatting, with and without single quotes. I got confusing results. Mostly nothing happened. Sometimes formatting was applied - most often this was if previous conditional formatting had "hungover" from a previous attempt. I did not have time to pin down what was going on.

When I said:

The nearest issue I can see is 28589, although it isn't quite the same. I also think that one has been fixed in more recent releases.

I was remembering conditional formatting not showing until a cell had scrolled off and back on the screen, which occured in certain circumstances (more than one condition, at least one of which based on another cell). I know this problem has been resolved because it no longer affects me daily, as it used to.