2.2.4.37 SlicerFormatElement
Namespace: http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/
A slicer formatting specification.
-
<xs:complexType name="SlicerFormatElement" xmlns:xs="http://www.w3.org/2001/XMLSchema"> <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 0.
HorizontalAlignment: MUST be one of the values specified in the following table.
Value |
Name |
Meaning |
---|---|---|
0 |
Automatic |
Equivalent to the [ISO/IEC29500-1:2012] ST_HorizontalAlignment general enumeration value. |
1 |
Center |
Equivalent to the [ISO/IEC29500-1:2012] ST_HorizontalAlignment center enumeration value. |
2 |
Left |
Equivalent to the [ISO/IEC29500-1:2012] ST_HorizontalAlignment left enumeration value. |
3 |
Right |
Equivalent to the [ISO/IEC29500-1:2012] ST_HorizontalAlignment right enumeration value. |
4 |
Fill |
Equivalent to the [ISO/IEC29500-1:2012] ST_HorizontalAlignment fill enumeration value. |
5 |
Justify |
Equivalent to the [ISO/IEC29500-1:2012] ST_HorizontalAlignment justify enumeration value. |
6 |
CenterAcrossSelection |
Equivalent to the [ISO/IEC29500-1:2012] ST_HorizontalAlignment centerContinuous enumeration value. |
7 |
Distributed |
Equivalent to the [ISO/IEC29500-1:2012] 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/IEC29500-1:2012] ST_VerticalAlignment bottom enumeration value. |
1 |
Top |
Equivalent to the [ISO/IEC29500-1:2012] ST_VerticalAlignment top enumeration value. |
2 |
Bottom |
Equivalent to the [ISO/IEC29500-1:2012] ST_VerticalAlignment bottom enumeration value. |
3 |
Center |
Equivalent to the [ISO/IEC29500-1:2012] ST_VerticalAlignment center enumeration value. |