SetTabFormatCondition

SOAP-запрос:

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

<SetTabFormatCondition xmlns="http://www.fsight.ru/PP.SOM.Som">

  <mon xmlns="">S1!M!S!P1!Sheets!1!A0:B3!FormatConditions!0</mon>

<tArg xmlns="">

  <k>0</k>

  <Key>0</Key>

  <Type>CellContent</Type>

<Details>

<CellContent>

  <ContentType>0</ContentType>

  <CellValue>100</CellValue>

  <SpecificText />

<Style>

  <Font S="10" B="true" />

  </Style>

  <ValueCondition>4</ValueCondition>

  <TextCondition>0</TextCondition>

  <DateCondition>0</DateCondition>

  <MinValue />

  <MaxValue />

  </CellContent>

  </Details>

  </tArg>

  </SetTabFormatCondition>

  </s:Body>

  </s:Envelope>

SOAP-ответ:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

<soapenv:Body>

  <SetTabFormatConditionResult 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</SetTabFormatConditionResult>

  </soapenv:Body>

  </soapenv:Envelope>

JSON-запрос:

{
 "SetTabFormatCondition" : 
  {
   "mon" : "S1!M!S!P1!Sheets!1!A0:B3!FormatConditions!0",
   "tArg" : 
    {
     "k" : "0",
     "Key" : "0",
     "Type" : "CellContent",
     "Details" : 
      {
       "CellContent" : 
        {
         "ContentType" : "0",
         "CellValue" : "100",
         "SpecificText" : "",
         "Style" : 
          {
           "Font" : 
            {
             "@B" : "true",
             "@S" : "10"
            }
          },
         "ValueCondition" : "4",
         "TextCondition" : "0",
         "DateCondition" : "0",
         "MinValue" : "",
         "MaxValue" : ""
        }
      }
    }
  }
}

JSON-ответ:

{
 "SetTabFormatConditionResult" : "1"
}

public static bool SetFormatCondition(string moniker, string sheetKey, string adress, string formatKey, string cellValue, TabStyle formatStyle)
{
    var somClient = new SomPortTypeClient(); // Прокси-объект для выполнения операции
    // Параметры выполнения операции
    var tTab = new SetTabFormatCondition()
    {
        mon = moniker + "!Sheets!" + sheetKey + '!' + adress + "!FormatConditions!" + formatKey,
        tArg = new TabFormatCondition()
        {
            Type = TabConditionType.CellContent,
            Details = new TabFormatConditionDetails()
            {
                CellContent = new TabFormatCellContent()
                {
                    ContentType = 0, //TabFormatContentType.CellValue
                    ValueCondition = 4, //TabConditionCellContentValue.Above
                    CellValue = cellValue,
                    Style = formatStyle,
                    SpecificText = "",
                    MinValue = "",
                    MaxValue = ""
                }
            }
        }
    };
    // Изменение параметров условного формата
    var result = somClient.SetTabFormatCondition(tTab);
    return result;
}