Hello!
Please help! In Libreoffice calc, I want to write a macro that retrieves the cell style obtained by conditional formatting of certain cells (A1:D5). Basically, I can query the cell style, but I only get the basic cell style, even though the cell style is changed by the conditional formatting.
Libreoffice 7.5
Thank you very much!
You can get this data using cell properties ConditionalFormat or ConditionalFormatLocal.
The value of the property is an array of objects supporting the service TableConditionalEntry.
Unfortunately, as far as I know, there is no way to determine which style is applied as a result of conditional formatting rules.
By the way, in Excel, the (read-only) property Range.DisplayFormat is responsible for this.