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:

• To work with the cell range: «Regular report instance moniker!Sheets!<Sheet key>!<absolute address>!Style». Absolute address can be specified in various formats that are allowed for cells, for example: A5, A5:D10, R5C3, C:C, 43:43.

• To work with the specified table area: «Regular report instance moniker!DataArea!DataSources!<source key>!DataSourceSlices!<slice key>!Views!<table key>!EaxTableStyle!».
  This moniker should also be appended with one of the following values:

• Internal - to get data area formatting.

• Top - to get column headers formatting.

• Left - to get row headers formatting.

The moniker can be obtained on executing the OpenPrxMeta operation.

The operation returns formatting of the specified table area.

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 JSONC#

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 GetSpecificRangetyle(string moniker, ulong sourceKey, ulong sliceKey, ulong 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"
    };
    //Get style
    var result = somClient.GetStyle(tGet);
    return result;
}

See also:

Interactive Visual Components