Bug 140089

Summary:	Conditional formatting broken
Product:	LibreOffice	Reporter:	Przemek <jeskenis>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	normal
Priority:	medium
Version:	7.0.3.1 release
Hardware:	All
OS:	Linux (All)
URL:	https://vimeo.com/507490738
Whiteboard:
Crash report or crash signature:		Regression By:

Description Przemek 2021-02-02 11:54:37 UTC

Today I've tried adding conditional formatting to my spreadsheet. Basically what I've tried to achieve is not highlight maximum value in the column. It simply does not work - after entering formula and applying the formatting all the values below the one that should get a highlight were highlighted. 
Tried moving the data to new spreadsheet, removing formulas and using only values etc. Nothing helped. At this point IMO conditional formatting in 7.0.3 is unusable, sadly. Hope someone will be able to nail it down.
Here's the video showing the issue:
https://vimeo.com/507490738

Comment 1 [REDACTED] 2021-02-02 12:36:52 UTC

You did not use absolute addressing in your formula. You need to use =MAX(M$2:M$13)

Comment 2 Przemek 2021-02-02 13:00:15 UTC

ok, cool - thx. Obvious mistake - but maybe some sort of check and warning in the window would be a good enhancement idea?

Comment 3 [REDACTED] 2021-02-02 17:22:05 UTC

(In reply to Przemek from comment #2)
> ok, cool - thx. Obvious mistake - but maybe some sort of check and warning
> in the window would be a good enhancement idea?

Hmm... How should the application know what you want? The formula you have used is not wrong and there may be uses case where you exactly want what you have used.