TabFormatConditionsClear

Syntax

bool TabFormatConditionsClear(string mon)

Parameters

mon. Moniker of the range for working with its conditional formats.

Description

The TabFormatConditionsClear operation deletes all conditional formats for cell range.

Comments

To execute the operation, in the mon field specify regular report instance moniker with the !Sheets!sheet key!range address!FormatConditions postfix.

The operation results in the logical True if deletion was successful.

Example

Below is the example of deleting all conditional formats of the cell range. The request contains moniker for working with cell range conditional formats. The response contains whether deletion was successful.

SOAP request:

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
<s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<TabFormatConditionsClear xmlns="http://www.fsight.ru/PP.SOM.Som">
  <mon xmlns="">S1!M!S!P1!Sheets!1!A0:B3!FormatConditions</mon>
  </TabFormatConditionsClear>
  </s:Body>
  </s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
  <TabFormatConditionsClearResult xmlns="http://www.fsight.ru/PP.SOM.Som" xmlns:q1="http://www.fsight.ru/PP.SOM.Som" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">1</TabFormatConditionsClearResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

{
 "TabFormatConditionsClear" : 
  {
   "mon" : "S1!M!S!P1!Sheets!1!A0:B3!FormatConditions"
  }
}

JSON response:

{
 "TabFormatConditionsClearResult" : "1"
}
public static bool ClearFormatConditions(string moniker, string sheetKey, string address)
{
    var somClient = new SomPortTypeClient(); // Proxy object for operation execution
    // Operation execution parameters
    var tTab = new TabFormatConditionsClear()
    {
        mon = moniker + "!Sheets!" + sheetKey + '!' + address + "!FormatConditions"
    };
    // Delete all conditional formats
    var result = somClient.TabFormatConditionsClear(tTab);
    return result;
}

See also:

Table