Changing Cell Style

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

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

<tWbk xmlns=" ">

  <id>S1!M!S!W7</id>

  </tWbk>

<tArg xmlns=" ">

<pattern>

  <obInst>true</obInst>

  <styles>true</styles>

  </pattern>

<meta>

<styles>

<splice>

<tabStyle>

  <Font C="#FF6A00" />

  </tabStyle>

  <setDefault>false</setDefault>

  </splice>

<discrepancy>

<tabStyle>

  <Font I="true" />

  </tabStyle>

  <setDefault>false</setDefault>

  </discrepancy>

<forecast>

<tabStyle>

  <Font B="true" />

  </tabStyle>

  <setDefault>false</setDefault>

  </forecast>

  </styles>

  </meta>

  </tArg>

  </SetWbkMd>

  </s:Body>

  </s:Envelope>

SOAP response:

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

<soapenv:Body>

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

<id xmlns=" ">

  <id>S1!M!S!W7</id>

  </id>

  </SetWbkMdResult>

  </soapenv:Body>

  </soapenv:Envelope>

JSON request:

{
 "SetWbkMd" : 
  {
   "tWbk" : 
    {
     "id" : "S1!M!S!W7"
    },
   "tArg" : 
    {
     "pattern" : 
      {
       "obInst" : "true",
       "styles" : "true"
      },
     "meta" : 
      {
       "styles" : 
        {
         "splice" : 
          {
           "tabStyle" : 
            {
             "Font" : 
              {
               "@C" : "#FF6A00"
              }
            },
           "setDefault" : "false"
          },
         "discrepancy" : 
          {
           "tabStyle" : 
            {
             "Font" : 
              {
               "@I" : "true"
              }
            },
           "setDefault" : "false"
          },
         "forecast" : 
          {
           "tabStyle" : 
            {
             "Font" : 
              {
               "@B" : "true"
              }
            },
           "setDefault" : "false"
          }
        }
      }
    }
  }
}

JSON response:

{
 "SetWbkMdResult" : 
  {
   "id" : 
    {
     "id" : "S1!M!S!W7"
    }
  }
}

public static SetWbkMdResult SetWbkStyle(WbkId wbk)
{// Set operation execution parameters
    var tOp = new SetWbkMd
    {
        tWbk = wbk,
        tArg = new SetWbkMdArg

        {   // Set data change pattern
            pattern = new WbkMdPattern()
            {styles = true},
            // Set changeable data
            meta = new WbkMd()
            {
                styles = new LnTabStyles()
                {// Style for cells with forecast data
                    forecast = new LnCellStyle()
                    {

                        setDefault = false,
                        tabStyle = new TabStyle()
                        {
                            Font = new TabFontStyle
                            {
                                BSpecified = true,
                                B = true
                            }
                        }
                    },// Style for cells that are data source for spliced series

                    splice = new LnCellStyle()
                    {
                        setDefault = false,
                        tabStyle = new TabStyle()
                        {
                            Font = new TabFontStyle
                            {C = "#FF6A00"}
                        }
                    },// tyle for cells, which stored values differ from calculated ones
                    discrepancy = new LnCellStyle()

                    {
                        setDefault = false,
                        tabStyle = new TabStyle()
                        {
                            Font = new TabFontStyle
                            {
                                I = true,
                                ISpecified = true
                            }
                        }

}
}
}
}
};
// Create proxy object for operation execution
var somClient = new SomPortTypeClient();
// Execute operation
SetWbkMdResult sRes = somClient.SetWbkMd(tOp); 
return sRes;
}