TabFormatConditionsRemove

Syntax

bool TabFormatConditionsRemove(string mon, ItemRemoveInfo tArg)

Parameters

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

tArg. Parameters for removing conditional format.

Description

The TabFormatConditionsRemove operation removes conditional format of cell range.

Comments

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.

Example

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.

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">
<TabFormatConditionsRemove xmlns="http://www.fsight.ru/PP.SOM.Som">
  <mon xmlns="">S1!M!S!P1!Sheets!1!A0:B3!FormatConditions</mon>
<tArg xmlns="">
  <index>0</index>
  </tArg>
  </TabFormatConditionsRemove>
  </s:Body>
  </s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
  <TabFormatConditionsRemoveResult 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</TabFormatConditionsRemoveResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

{
"TabFormatConditionsRemove" :
{
"mon" : "S1!M!S!P1!Sheets!1!A0:B3!FormatConditions",
"tArg" :
{
"index" : "0"
}
}
}

JSON response:

{
"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:

Interactive Visual Components