2.4.202 BrtBeginSlicer
The BrtBeginSlicer record specifies a slicer view (section 2.2.14.2) in this worksheet and specifies the beginning of an empty collection of records as defined by the Slicers (section 2.2.14) part ABNF.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
A |
B |
C |
D |
unused |
dwStartSlicerItem |
||||||||||||||||||||||||||
|
... |
dwColumnCount |
||||||||||||||||||||||||||||||
|
... |
dwLevel |
||||||||||||||||||||||||||||||
|
... |
dxRowHeight |
||||||||||||||||||||||||||||||
|
... |
stName (variable) |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
stSlicerCacheName (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
stCaption (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
stStyle (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
A - fCaptionVisible (1 bit): A bit that specifies if the caption is displayed.
B - fHasCaption (1 bit): A bit that specifies whether the stCaption field exists.
C - fHasStyle (1 bit): A bit that specifies whether the stStyle field exists.
D - fLockedPosition (1 bit): A bit that specifies if the slicer view is locked.
unused (4 bits): This value is undefined, and MUST be ignored.
dwStartSlicerItem (4 bytes): An unsigned integer that specifies the zero-based index of the first slicer item (section 2.2.14.1.4.1) displayed by the slicer view.
dwColumnCount (4 bytes): An unsigned integer that specifies the number of columns (1) in the slicer view. This value MUST be greater than or equal to 1 and less than or equal to 20,000.
dwLevel (4 bytes): An unsigned integer that specifies the OLAP level of the OLAP hierarchy of the slicer source data (section 2.2.14.1.1) used by the slicer view.
If the slicer source data is OLAP, then the value MUST be greater than or equal to 0 and MUST be less than cLevels of the BrtBeginPCDHierarchy (section 2.4.146) record specified by the BrtBeginSlicerCacheDef record specified by stSlicerCacheName. If the OLAP hierarchy has the OLAP All level, then the value MUST be other than 0.
-
This value MUST be 0 if the slicer source data is non-OLAP.
dxRowHeight (4 bytes): An unsigned integer that specifies the row height of the slicer view in EMUs.
stName (variable): An XLWideString (section 2.5.169) that specifies the name of the slicer view. This value MUST be a unique case insensitive name within scope of the workbook. The length of this value MUST be greater than or equal to 1 character and less than or equal to 32,767 characters.
stSlicerCacheName (variable): An XLWideString that specifies the name of the slicer cache (section 2.2.14.1). There MUST be a BrtBeginSlicerCacheDef (section 2.4.204) record within this workbook with the stName field equal to the value of this field.
stCaption (variable): An XLWideString that specifies the caption of the slicer view. This value MUST exist if and only if fHasCaption is equal to 1. If this string exists, the length MUST be greater than or equal to 1 character.
stStyle (variable): An XLWideString that specifies the slicer style (section 2.2.6.3.1) of the slicer view. This value MUST exist if and only if fHasStyle is equal to 1. If this field exists, this string MUST match the stName of a BrtBeginSlicerStyle (section 2.4.219) record within the workbook, or MUST be equal to one of the built-in slicer style names listed in the following table.
-
Built-In Slicer Style Names
SlicerStyleLight1
SlicerStyleLight2
SlicerStyleLight3
SlicerStyleLight4
SlicerStyleLight5
SlicerStyleLight6
SlicerStyleOther1
SlicerStyleOther2
SlicerStyleDark1
SlicerStyleDark2
SlicerStyleDark3
SlicerStyleDark4
SlicerStyleDark5
SlicerStyleDark6