Export (0) Print
Expand All
Expand Minimize

2.4.302 SxSelect

Office

The SxSelect record specifies information about selectedcells in the PivotTable report for a PivotTable view. The selection is stored in the PivotTable rule following this record.


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

reserved1

pnn

reserved2

sxaxisAct

iDimAct

iLiStart

iLiAct

iLiMin

iLiMax

rwClick

colClick

rwClickPrev

colClickPrev

cClick

A

B

C

D

E

unused

reserved1 (2 bytes): MUST be zero, and MUST be ignored.

pnn (1 byte): A PaneType structure that specifies the active pane.

reserved2 (1 byte): MUST be zero, and MUST be ignored.

sxaxisAct (2 bytes): An SXAxis structure that specifies the PivtotTable Axis of the PivotTable selection.

The value of the sxaxisData field of SXAxis MUST be zero.

iDimAct (2 bytes): An unsigned integer that specifies the zero-based field position of the field that is selected within the PivtotTable Axis.

iLiStart (2 bytes): An unsigned integer that specifies the zero-based position of the PivotTable line where the selection operation started. MUST be greater than or equal to the iLiMin field and less than or equal to the iLiMax field.

iLiAct (2 bytes): An unsigned integer that specifies the zero-based position of the PivotTable line that was most recently included in the selection. MUST be greater than or equal to zero and less than or equal to the iLiMax field.

iLiMin (2 bytes): An unsigned integer that specifies the zero-based position of the minimum PivotTable line that could be included in the selection. MUST be greater than or equal to zero and less than or equal to the iLiMax field.

iLiMax (2 bytes): An unsigned integer that specifies the zero-based position of the maximum PivotTable line that could be included in the selection. MUST be greater than or equal to zero. MUST be greater than or equal to the iLiMin field.

rwClick (2 bytes): An RwU structure that specifies the row of the cell where the user last clicked for the PivotTable selection.

colClick (2 bytes): A ColU structure that specifies the column of the cell where the user last clicked for the PivotTable selection.

rwClickPrev (2 bytes): An RwU structure that specifies the row of the cell previously clicked by the user on the PivotTable selection.

colClickPrev (2 bytes): A ColU structure that specifies the column of the cell previously clicked on the PivotTable selection.

cClick (5 bits): An unsigned integer that specifies the number of clicks made by the user to refine the current PivotTable selection.

A - fLabelOnly (1 bit): A bit that specifies that only cells in the row area, column area, or page area are selected.

B - fDataOnly (1 bit): A bit that specifies that only cells in the data area are selected.

C - fToggleDataHeader (1 bit): A bit that specifies whether the PivotTable selection toggle is enabled. The selection toggle enables a method for the user to select values, labels, or both values and labels.

D - fSelectionClick (1 bit): A bit that specifies whether any selections on the PivotTable were refined by the user.

E - fExtendable (1 bit): A bit that specifies whether an additional PivotTable line can be added to the current selection.

unused (6 bits): Undefined and MUST be ignored.

Show:
© 2014 Microsoft