2.2.4.37 SlicerFormatElement
Namespace: http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/
A slicer formatting specification.
-
<xs:complexType name="SlicerFormatElement"> <xs:sequence> <xs:element minOccurs="1" maxOccurs="1" name="GradientStop1" type="xs:int"/> <xs:element minOccurs="1" maxOccurs="1" name="GradientStop0" type="xs:int"/> <xs:element minOccurs="1" maxOccurs="1" name="GradientType" type="xs:int"/> <xs:element minOccurs="1" maxOccurs="1" name="HasGradient" type="xs:boolean"/> <xs:element minOccurs="0" maxOccurs="1" name="SlicerFontType" type="tns:SlicerFontType"/> <xs:element minOccurs="0" maxOccurs="1" name="BorderFormat" type="tns:BorderFormat"/> <xs:element minOccurs="1" maxOccurs="1" name="FillColor" type="xs:int"/> <xs:element minOccurs="1" maxOccurs="1" name="Ident" type="xs:int"/> <xs:element minOccurs="1" maxOccurs="1" name="HorizontalAlignment" type="xs:int"/> <xs:element minOccurs="1" maxOccurs="1" name="VerticalAlignment" type="xs:int"/> </xs:sequence> </xs:complexType>
GradientStop1: Specifies the second color stop in the gradient. MUST be present if HasGradient is "true". Value MUST be a LongRGBA, as specified in [MS-XLSB] section 2.5.89. If HasGradient is "false", this value MUST be ignored.
GradientStop0: Specifies the first color stop in the gradient. MUST be present if HasGradient is "true". Value MUST be a LongRGBA as specified in [MS-XLSB] section 2.5.89. If HasGradient is "false", this value MUST be ignored.
GradientType: Specifies the orientation of the gradient. MUST be one of the values specified in the following table.
|
Value |
Meaning |
|---|---|
|
0 |
Displays a horizontal gradient. |
|
1 |
Displays a vertical gradient. |
HasGradient: When set to "true", specifies that a gradient fill is to be applied to the slicer visual component. Otherwise, specifies fill color is to be applied to the slicer visual component.
SlicerFontType: Font specification for the slicer visual components.
BorderFormat: Specifies the formatting to apply to the border of the slicer visual components.
FillColor: Specifies the fill color. If HasGradient is "true", this value MUST be ignored. The value MUST be a LongRGBA, as specified in [MS-XLSB] section 2.5.89.
Ident: Specifies horizontal indent used for rendering slicer contents in points. MUST be greater than or equal to zero.
HorizontalAlignment: MUST be one of the values specified in the following table.
|
Value |
Name |
Meaning |
|---|---|---|
|
0 |
Automatic |
Equivalent to the [ISO/IEC-29500-1] ST_HorizontalAlignment general enumeration value. |
|
1 |
Center |
Equivalent to the [ISO/IEC-29500-1] ST_HorizontalAlignment center enumeration value. |
|
2 |
Left |
Equivalent to the [ISO/IEC-29500-1] ST_HorizontalAlignment left enumeration value. |
|
3 |
Right |
Equivalent to the [ISO/IEC-29500-1] ST_HorizontalAlignment right enumeration value. |
|
4 |
Fill |
Equivalent to the [ISO/IEC-29500-1] ST_HorizontalAlignment fill enumeration value. |
|
5 |
Justify |
Equivalent to the [ISO/IEC-29500-1] ST_HorizontalAlignment justify enumeration value. |
|
6 |
CenterAcrossSelection |
Equivalent to the [ISO/IEC-29500-1] ST_HorizontalAlignment centerContinuous enumeration value. |
|
7 |
Distributed |
Equivalent to the [ISO/IEC-29500-1] ST_HorizontalAlignment distributed enumeration value. |
|
8 |
JustifyDistributed |
Combination of Justify and Distributed enumeration values. |
VerticalAlignment: MUST be one of the values specified in the following table.
|
Value |
Name |
Meaning |
|---|---|---|
|
0 |
Automatic |
Equivalent to the [ISO/IEC-29500-1] ST_VerticalAlignment bottom enumeration value. |
|
1 |
Top |
Equivalent to the [ISO/IEC-29500-1] ST_VerticalAlignment top enumeration value. |
|
2 |
Bottom |
Equivalent to the [ISO/IEC-29500-1] ST_VerticalAlignment bottom enumeration value. |
|
3 |
Center |
Equivalent to the [ISO/IEC-29500-1] ST_VerticalAlignment center enumeration value. |