Ask Your Question

Max number of separate Conditional Formats in Calc?

asked 2020-11-10 10:18:48 +0200

appreciatethehelp gravatar image

updated 2020-11-10 10:44:15 +0200


Just want to know the maximum number of separate/individual conditional formats (each separate conditional format is displayed as a separate row containing "range" and "first condition" information in "manage conditional formatting" window) that can be created in a single Calc doc?

I have defined 32 separate conditions so far without any issues...

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-11-10 10:52:54 +0200

igorlius gravatar image


I would assume, that the number of possble conditions is not a fixed value, but is limited by the amount of system resources (i.e. memory) availabe.

But i have to admit that i am not familiar with the LO code in such depth to verify my assumption. Maybe there is an upper limit, i am not aware of.

edit flag offensive delete link more



From the API view: Each sheet has a Property .ConditionalFormats which also counts the SheetCellRanges objects having such a thing applied. The counting property (named Length for unknown reasons) is of type Long and Long allows for values up to 2147483647.
The remark by @igorlius concerning resources should apply, (Also applicable: efficiency, filesize,...)
The number of rules accepted per a single CFed range is also unlimited. This was basically the case already long ago, but the UI only supported up to 3 rules directly before the enhancement @PKG linked to..

Lupp gravatar imageLupp ( 2020-11-10 11:15:50 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-11-10 10:18:48 +0200

Seen: 54 times

Last updated: Nov 10 '20