TabFormatConditionsMove

Syntax

bool TabFormatConditionsMove(string mon, ItemMoveInfo tArg)

Parameters

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

tArg. Parameters for moving conditional formats.

Description

The TabFormatConditionsMove operation moves conditional formats.

Comments

The order of conditional formats determines the order of their application to a cell range. To execute the operation, in the mon field specify regular report instance moniker with the !Sheets!sheet key !range address!FormatConditions postfix, and in the tArg field specify parameters for moving conditional formats.

The operation results in the logical True if moving completed successfully.

Example

Below is the example of moving conditional formats in the collection. The request contains moniker for working with conditional formats of cell range, index of conditional format to be moved, and index of the position, to which moving is executed. The response contains whether the dimension is successfully moved.

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

SOAP response:

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

JSON request:

{
 "TabFormatConditionsMove" : 
  {
   "mon" : "S1!M!S!P1!Sheets!1!A0:B3!FormatConditions",
   "tArg" : 
    {
     "indexFrom" : "0",
     "indexTo" : "1"
    }
  }
}

JSON response:

{
 "TabFormatConditionsMoveResult" : "1"
}
public static bool MoveFormatConditions(string moniker, string sheetKey, string address, long moveFrom, long moveTo)
{
    var somClient = new SomPortTypeClient(); // Proxy object for operation execution
    // Operation execution parameters
    var tTab = new TabFormatConditionsMove()
    {
        mon = moniker + "!Sheets!" + sheetKey + '!' + address + "!FormatConditions",
        tArg = new ItemMoveInfo()
        {
            indexFrom = moveFrom,
            indexTo = moveTo
        }
    };
    // Move conditional formats
    var result = somClient.TabFormatConditionsMove(tTab);
    return result;
}

See also:

Table