bool TabFormatConditionsRemove(string mon, ItemRemoveInfo tArg)
mon. Moniker of the range for working with its conditional formats.
tArg. Parameters for removing conditional format.
The TabFormatConditionsRemove operation removes conditional format of cell range.
To execute the operation, in the mon field specify regular report instance moniker with the !Sheets!sheet key!cell range!FormatConditions postfix, and in the tArg.index field specify index of conditional format to be removed.
The operation results in the logical true if, deletion finished successfully.
Below is the example of removing conditional format of cell range. The request contains moniker for working with cell range conditional formats and index of conditional format to be removed. The response contains whether deletion was successful.
{
"TabFormatConditionsRemove" :
{
"mon" : "S1!M!S!P1!Sheets!1!A0:B3!FormatConditions",
"tArg" :
{
"index" : "0"
}
}
}
{
"TabFormatConditionsRemoveResult" : "1"
}
public static bool DeleteFormatCondition(string moniker, string sheetKey, string adress, ulong formatIndex)
{
var somClient = new SomPortTypeClient(); // Proxy object for operation execution
// Operation execution parameters
var tTab = new TabFormatConditionsRemove()
{
mon = moniker + "!Sheets!" + sheetKey + '!' + adress + "!FormatConditions",
tArg = new ItemRemoveInfo()
{
index = formatIndex
}
};
// Remove conditional format
var result = somClient.TabFormatConditionsRemove(tTab);
return result;
}
See also: