openoffice conditional formatting emplate

tPropertyValue('ConditionalFormat', oConditionalFormat) OConditionalFormat = oObj1.ConditionalFormat The result of all this is (from MRI with the macro name amended):Ĭode: Select all Expand view Collapse view Sub CFClear Finally, I also searched this forum for Conditional Format, which provided a few useful links.

This gives a clue that we don't just need to 'clear', but also reset the CF property, or as the developers guide puts it 'After a conditional format is changed, it has to be reinserted into the property set of the cell or cell range.'Ħ. I also looked at the Developer's Guide from the link in 3. (In fact using MRI it looks like we can actually apply it to a sheet, not just a Sheet Cell Range).ĥ. We are looking for a method 'clear', which when applied to a Conditional Format in Sheet CellRange hopefully will clear the CF's. When you have a clue as to what you are looking for then fire up MRI and try to find it. Eventually I found the method 'clear', which looked like a good bet.Ĥ. I looked for Conditional Format and then followed the link to it in Sheet Cell Range, and then clicked on the link there to XSheetConditionalEntries. In particular use the Index (near the top). It documents services, interfaces, methods and properties. Read how to use it, again starting in a Calc spreadsheet, by Help, Open help, Open Basic (in the drop down menu at the top left of the dialog box), Contents, MRI.ģ. You can then start it off in a Calc spreadsheet from the menu by Tools, Add-Ons, MRI. Get hold of the MRI extension and install. Get hold of the Basic Programmers Guide and read it, particularly the chapter about spreadsheets.You can find a link to it at the top of the Macros and UNO API forum.Ģ. Villeroy is correct in that the MRI tool is very useful, but I think there are other things you need to do as well.ġ.

Openoffice conditional formatting emplate