2.4.293 SXLI

The SXLI record specifies pivot lines for the row area or column area of a PivotTable view.


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

rgsxli (variable)

...

rgsxli (variable): An array of SXLIItem.

Zero or two records of this type appear in the file for each PivotTable view depending on the values of the cRw and cCol fields of the associated SxView record.

If the value of either of the cRw or cCol fields of the associated SxView is greater than zero, then two records of this type MUST exist in the file for the associated SxView. The first record contains row area pivot lines and the second record contains column area pivot lines.

The count of SXLIItem structures in rgsxli, which are row area pivot lines, MUST equal the cRw field of SxView.

The count of SXLIItem structures in rgsxli, which are column area pivot lines, MUST equal the cCol field of SxView. 

The associated SxView record is the SxView record of the PivotTable view.