Share via

2.2.14.2 Slicer View

  • Article

A slicer view specifies the display of a slicer (section 2.2.14) on a worksheet. A slicer view is displayed as a list of slicer items (section 2.2.14.1.4). A slicer view is specified by the sequence of records that conform to the SLICER rule (as defined in section 2.1.7.48.

Each slicer view is associated with a slicer cache (section 2.2.14.1) as specified in section 2.2.14.2.1. The filtering state of slicer items displayed in the slicer view is specified by the associated slicer cache.

Each slicer view is associated with a drawing ([ISO/IEC29500-1:2016] section 20.5), contained in the drawing part ([ISO/IEC29500-1:2016] section 12.3.8) associated with the worksheet with which the slicer view is associated. The associated drawing ([ISO/IEC29500-1:2016] section 20.5) contains a slicer element of type CT_Slicer ([MS-XLSX] section 2.6.68) that contains a name attribute that matches the stName field of the BrtBeginSlicer (section 2.4.202) record that specifies the slicer view.

For information about slicer formatting see slicer styles (section 2.2.6.3.1).