V 6.2.5.2
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…
Hello,
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.
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…