openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "João Paulo R. Rezende" <jprreze...@gmail.com>
Subject Removing condition formatting using macro
Date Tue, 08 Jul 2014 14:02:21 GMT
Hello,

I want to create a macro to remove or clear all condition formats in 
current sheet.

I had tried:

myRange.ConditionalFormat.Clear()
myRange.ConditionalFormat.removeByIndex(index)
mySheet.ConditionalFormat.Clear()

Already tried,
Dim oPropCondition As Object
.....
oPropCondition = oRange.ConditionalFormat
oPropCondition.Clear()
oRange.setPropertyValue( "ConditionalFormat", oPropCondition)

But nothing works,

How can I do this?

Thanks in advance,

-- 
João Paulo


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message