Bug 160796

Summary: Conditional formating pb
Product: LibreOffice Reporter: jbz <biz43eol>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEEDINFO ---    
Severity: normal CC: miguelangelrv
Priority: medium    
Version: 24.2.2.2 release   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: calc sheet

Description jbz 2024-04-23 10:03:53 UTC
Created attachment 193819 [details]
calc sheet

Voorwaardelijke opmaak
Voorwaardelijke opmaak reageert wisselend bij het invullen van een optelling in een andere cel. zie bijlage.
Comment 1 Julien Nabet 2024-04-23 12:26:01 UTC
Quick translation:
"Conditional formatting reacts differently when entering an addition in another cell. see attachment".
Comment 2 m_a_riosv 2024-04-23 15:27:17 UTC
I think you have not used properly relative/absolute references in MAX(B1:B10)->MAX($B$1:$B$10)
E.g. for B2, the max value with relative reference is calculated MAX(B2:B11)

But please explain better with what value do you want to get with the conditional format.

This site is used in English, you have good translators for that, like https://www.deepl.com/translator if you don't like Google translator.