GetStyle

Syntax

StyleMetaData GetStyle(string mon)

Parameters

mon. Moniker containing information about the table area, which formatting should be obtained.

Description

The GetStyle operation gets formatting style for the cell range or selected table range displayed analytical data area.

Comments

To execute the operation, in the mon field specify the moniker in the following format:

The moniker can be obtained on executing the OpenPrxMeta operation. The operation returns formatting of the specified table area.

To work with formatting style specified for control block, the moniker can be obtained in the meta.calcObjet.validBlock.style field after executing the GetAlg operation.

Example

Below is the example of getting formatting of table row headers. The request contains table area moniker. The response contains the obtained formatting.

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">
<GetStyle xmlns="http://www.fsight.ru/PP.SOM.Som">
  <mon xmlns="">S1!M!S!P1!DataArea!DataSources!1!DataSourceSlices!1!Views!3!EaxTableStyle!Left</mon>
  </GetStyle>
  </s:Body>
  </s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<GetStyleResult 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">
<style xmlns="">
  <Text HA="1" VA="1" WW="1" M="7px 6px 8px 6px" />
  <NumberFormat F="" FT="0" />
  <Font F="Arial" S="8" B="false" H="12" />
  <Borders />
  <Hyperlink />
  </style>
  </GetStyleResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

{
 "GetStyle" : 
  {
   "mon" : "S1!M!S!P1!DataArea!DataSources!1!DataSourceSlices!1!Views!3!EaxTableStyle!Left"
  }
}

JSON response:

{
 "GetStyleResult" : 
  {
   "style" : 
    {
     "Text" : 
      {
       "@VA" : "1",
       "@HA" : "1",
       "@M" : "7px 6px 8px 6px",
       "@WW" : "1"
      },
     "NumberFormat" : 
      {
       "@F" : "",
       "@FT" : "0"
      },
     "Font" : 
      {
       "@B" : "false",
       "@S" : "8",
       "@F" : "Arial",
       "@H" : "12"
      },
     "Borders" : "",
     "Hyperlink" : ""
    }
  }
}
public static StyleMetaData GetSpecificRangeStyle(string moniker, uint sourceKey, uint sliceKey, uint viewKey)
{
    var somClient = new SomPortTypeClient(); //Proxy object for operation execution
    //Operation execution parameters
    var tGet = new GetStyle()
    {
        //mon = moniker + "!DataArea!DataSources!" + sourceKey.ToString() + "!DataSourceSlices!" + sliceKey.ToString() + "!Views!" + viewKey.ToString() + "!EaxTableStyle!Left"
        mon = moniker + "!DataArea!Views!" + viewKey.ToString() + "!EaxTableStyle!Left"
    };
    //Get style
    var result = somClient.GetStyle(tGet);
    return result;
}

See also:

Table