TabFormatConditionsAdd

Syntax

OpItemKey TabFormatConditionsAdd(string mon)

Parameters

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

Description

The TabFormatConditionsAdd operation creates a new conditional format 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 conditional format key.

Example

Below is the example of creating a new conditional format. The request contains moniker for working with cell range conditional formats. The response contains key of new conditional format.

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

SOAP response:

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

JSON request:

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

JSON response:

{
 "TabFormatConditionsAddResult" : 
  {
   "k" : "1"
  }
}
public static OpItemKey AddFormatCondition(string moniker, string sheetKey, string address)
{
    var somClient = new SomPortTypeClient(); // Proxy object for operation execution
    // Operation execution parameters
    var tTab = new TabFormatConditionsAdd()
    {
        mon = moniker + "!Sheets!" + sheetKey + '!' + address + "!FormatConditions"
    };
    // Create conditional format
    var result = somClient.TabFormatConditionsAdd(tTab);
    return result;
}

See also:

Table