[Solved] Removing conditional format from sheet

[Mr.Dandy]

Hello forum,

I try to remove with a script a conditional format for a specified range:

Code: Select all

Sub RemoveCF
	oDoc = ThisComponent
	oSheet = oDoc.CurrentController.ActiveSheet
	oRange = oSheet.getCellRangeByName("A1:A3")
	oCF = oRange.ConditionalFormat
	msgbox oCF.Count & " CF detected before removing"
	oCF.clear()
	msgbox oCF.Count & " CF detected after removing"
End Sub

clear method seems working because the 2nd msgbox displays 0.
But the CF is still present.
If I inspect A1:A3 with MRI, this range is in its previous state.

[Villeroy]

Assign the modified oCF object to the range: oRange.ConditionalFormat = oCF

[Mr.Dandy]