Create DataBar conditional formatting in Calc by macro

English
, ,
#1

Need help creating a DATABAR conditional format for a cell using macro. Needed to set up the color and range of values

#2

There are pitfalls - see this topic.

#3

Well, I can copy the format too…

#4
#5

Too general question. And I’ve never used the com.sun.star.sheet.ConditionEntry service.

#6

So what have you tried? Or are you actually asking for someone to write the macro?

#7

I’ve tried com.sun.star.beans.PropertyValue. No, suggest a solution

#8

or give an example …

#9

Is it wright that I can’t safely create (or modify an existing) DataBar’s format in Basic, but only using Python UNO scripts, which can access TableConditionalEntry objects?

#10

As far as I remember, the problem is in the initial creation of the conditional formatting rule of the desired type by the macro. If there is at least one cell with the desired type of conditional formatting, then we can use the macro to copy and change the conditional formatting rule. This does not depend on the programming language.
Here is another example of a macro for conditional formatting “color scale”.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.