2.4.260 BrtBeginSxSelect
The BrtBeginSxSelect record specifies the selection properties of a PivotTable view and specifies the beginning of a collection of records as defined by the Worksheet part ABNF (section 2.1.7.62). The collection of records specifies a PivotTable rule (section 2.2.5.3.9) used to identify cells of the selection. This record MUST be ignored if irstRelID is NULL or points to an invalid PivotTable (section 2.1.7.40) part.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
pnn |
|||||||||||||||||||||||||||||||
|
A |
B |
C |
D |
E |
F |
sxaxisAct |
iDimAct |
||||||||||||||||||||||||
|
... |
iLiStart |
||||||||||||||||||||||||||||||
|
... |
iLiMic |
||||||||||||||||||||||||||||||
|
... |
iLiMac |
||||||||||||||||||||||||||||||
|
... |
rwAct |
||||||||||||||||||||||||||||||
|
... |
colAct |
||||||||||||||||||||||||||||||
|
... |
rwPrev |
||||||||||||||||||||||||||||||
|
... |
colPrev |
||||||||||||||||||||||||||||||
|
... |
cClick |
||||||||||||||||||||||||||||||
|
irstRelID (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
pnn (4 bytes): A Pnn (section 2.5.108) that specifies the window pane that contains the selection in the PivotTable view<22>.
A - fLabelOnly (1 bit): A bit that specifies whether only cells in the page area (section 2.2.5.3.8.1.3), row area, or column (1) area are included in this selection. This value MUST be equal to 0 if the fDataOnly field is 1.
B - fDataOnly (1 bit): A bit that specifies whether only cells in the data area (section 2.2.5.3.8.1.4) are included in this selection. This value MUST be equal to 0 if the fLabelOnly field is 1.
C - fToggleDataHeader (1 bit): A bit that specifies whether the PivotTable view selection toggle is enabled. The selection toggle enables a method for the user to select values, labels, or both values and labels.
D - fExtendable (1 bit): A bit that specifies whether the selection can be extended with additional selections.
E - fSelectionClick (2 bits): This value MUST be 0, and MUST be ignored.
F - reserved (2 bits): This value MUST be 0, and MUST be ignored.
sxaxisAct (1 byte): An unsigned integer that specifies the area of the PivotTable view in which the active cell of the selection lies. This value MUST be a value from the following table.
-
Value
Meaning
0x00
The area of the PivotTable view in which the active cell of the selection lies is not specified.
0x01
The row area of the PivotTable view specified by irstRelID contains the active cell of the selection.
0x02
The column (1) area of the PivotTable view specified by irstRelID contains the active cell of the selection.
0x04
The page area of the PivotTable view specified by irstRelID contains the active cell of the selection <23>.
iDimAct (4 bytes): An unsigned integer that specifies the zero-based position within the PivotTable axis (section 2.2.5.3.7) of the pivot field (section 2.2.5.3.2) in which the active cell of the selection lies. If each of sxaxisAct.sxaxisRw, sxaxisAct.sxaxisCol, sxaxisAct.sxaxisPage, sxaxisAct.sxaxisData is 0 then this value MUST be 0. If sxaxisAct.sxaxisRw is 1, then this value MUST be less than the value of the cisxvd field of the BrtBeginISXVDRws (section 2.4.97) record of the PivotTable part specified by irstRelID. If sxaxisAct.sxaxisCol is 1, then this value MUST be less than the value of the cisxvd field of the BrtBeginISXVDCols (section 2.4.96) record. If sxaxisAct.sxaxisPage is 1, then this value MUST be 0.
iLiStart (4 bytes): An unsigned integer that specifies the pivot line (section 2.2.5.3.8.3) where the selection operation started. The value of this field MUST be greater than or equal to iLiMic and less than or equal to iLiMac.
If sxaxisAct.sxaxisRw is 1, then this value specifies a zero-based index into the collection of SXLI (section 2.1.7.40) rules following the BrtBeginSXLIRws (section 2.4.253) record in the PivotTable part specified by irstRelID. If sxaxisAct.sxaxisCol is 1, then this value specifies a zero-based index into the collection of SXLI rules following the BrtBeginSXLICols (section 2.4.252) record in the PivotTable part specified by irstRelID. If sxaxisAct.sxaxisPage is 1, then the value MUST be 0.
iLiMic (4 bytes): An unsigned integer that specifies the minimum pivot line the selection contains.
If sxaxisAct.sxaxisRw is 1, then this value specifies a zero-based index into the collection of SXLI (section 2.1.7.40) rules following the BrtBeginSXLIRws record in the PivotTable part specified by irstRelID and MUST be less than or equal to the value of the csxlis field of the BrtBeginSXLIRws record. If sxaxisAct.sxaxisCol is 1, then this value specifies a zero-based index into the collection of SXLI rules following the BrtBeginSXLICols record in the PivotTable part specified by irstRelID and MUST be less than or equal to the value of the csxlis field of the BrtBeginSXLICols record. If sxaxisAct.sxaxisPage is 1, then the value MUST be 0.
iLiMac (4 bytes): An unsigned integer that specifies the maximum pivot line the selection contains.
If sxaxisAct.sxaxisRw is 1, then this value specifies a zero-based index into the collection of SXLI (section 2.1.7.40) rules following the BrtBeginSXLIRws record in the PivotTable part specified by irstRelID and MUST be less than or equal to the value of the csxlis field of the BrtBeginSXLIRws record. If sxaxisAct.sxaxisCol is 1, then this value specifies a zero-based index into the collection of SXLI rules following the BrtBeginSXLICols record in the PivotTable part specified by irstRelID and MUST be less than or equal to the value of the csxlis field of the BrtBeginSXLICols record. If sxaxisAct.sxaxisPage is 1, then the value MUST be 0.
rwAct (4 bytes): An UncheckedRw (section 2.5.155) that specifies the row of the active cell the selection contains. If sxaxisAct.sxaxisRw is 1, then this value MUST be within the row area. If sxaxisAct.sxaxisCol is 1, then this value MUST be within the column (1) area. If sxaxisAct.sxaxisPage is 1, then this value MUST be within the page area.
colAct (4 bytes): An UncheckedCol (section 2.5.153) that specifies the column (1) of the active cell the selection contains. If sxaxisAct.sxaxisRw is 1, then this value MUST be within the row area. If sxaxisAct.sxaxisCol is 1, then this value MUST be within the column (1) area. If sxaxisAct.sxaxisPage is 1, then this value MUST be within the page area.
rwPrev (4 bytes): An UncheckedRw that specifies the row that is clicked to begin the selection.
colPrev (4 bytes): An UncheckedCol that specifies the column (1) that is clicked to begin the selection.
cClick (2 bytes): An unsigned integer that specifies the number of clicks to make this selection. The value MUST be greater than or equal to 1. The value cycles through 1 to N, where N is the number of different ways the selection can be extended.
irstRelID (variable): An XLNullableWideString (section 2.5.167) that specifies the relationship identifier to the PivotTable view that the selection applies to.