2.4.251 BrtBeginSXLI

The BrtBeginSXLI (section 2.4.251) record specifies properties of a pivot line (section 2.2.5.3.8.3) and specifies the beginning of a collection of records as defined by the PivotTable (section 2.1.7.40) part ABNF. The collection of records specifies a pivot line in a PivotTable view (section 2.2.5.3).


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

cSic

itmtype

reserved

cisxvis

iData

cSic (2 bytes): An unsigned integer that specifies the number of pivot line entries (section 2.2.5.3.8.4) to reuse from the previous pivot line (as specified by the BrtBeginISXVIs (section 2.4.98) record in the previous SXLI collection) within the SXLIRWS or SXLICOLS collection that contains this record (for PivotTable definitions, see section 2.1.7.40).

itmtype (1 byte):  A PivotItemType (section 2.5.105) that specifies the type of this pivot line.

reserved (1 byte): This value MUST be 0, and MUST be ignored.

cisxvis (4 bytes): An unsigned integer that specifies the count of pivot line entries specified by the BrtBeginISXVIs record contained in this SXLI (for definition, see section 2.1.7.40) collection. This value MUST be equal to the count of elements in the rgisxvis array in the BrtBeginISXVIs record. The pivot line entries used in this pivot line will be those reused from the previous pivot line, as specified by cSic, in addition to those specified by the BrtBeginISXVIs record.

iData (4 bytes): An ISXDI (section 2.5.82) that specifies the data item (section 2.2.5.3.7.5.1) to use for this pivot line. If the data field (section 2.2.5.3.7.5.2) is on the row axis or column (1) axis using this pivot line, this value MUST NOT equal -1. Otherwise, this value MUST be 0 and MUST be ignored.