2.4.276 BrtBeginSXView14
The BrtBeginSXView14 record specifies additional properties of a PivotTable view (section 2.2.5.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 additional properties of the PivotTable view relating to PivotTable What-if Analysis (section 2.2.5.3.10) and conditional formatting.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
FRTHeader |
|||||||||||||||||||||||||||||||
|
A |
B |
C |
D |
E |
F |
G |
sxma |
||||||||||||||||||||||||
|
... |
irstAltText (variable) |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
irstAltTextSummary (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
irstWeight (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
FRTHeader (4 bytes): An FRTBlank (section 2.5.55) that specifies the future record (section 2.1.6) information for this record.
A - fFillDownLabelsDefault (1 bit): A bit that specifies the behavior of pivot fields (section 2.2.5.3.2) that are not a part of the PivotTable view if they are later added to a PivotTable view. This value MUST be a value from the following table.
-
Value
Meaning
0
Specifies that pivot fields added to the PivotTable view behave as if the fFillDownLabels fields of BrtSXVD14 (section 2.4.830) records associated with those pivot fields are set to 0x00.
1
Specifies that pivot fields added to the PivotTable view behave as if the fFillDownLabels fields of BrtSXVD14 records associated with those pivot fields are set to 0x01.
-
B - fVisualTotalsForSets (1 bit): A bit that specifies whether hidden pivot items (section 2.2.5.3.3) will be included when calculating totals for named sets (section 2.2.5.2.7.3). This value MUST be a value from the following table.
-
Value
Meaning
0
Include hidden pivot items in the set totals.
1
Do not include hidden pivot items in the set totals.
-
C - fEnableWB (1 bit): A bit that specifies whether PivotTable What-if Analysis is enabled for this PivotTable view.
D - fAutoApply (1 bit): A bit that specifies whether PivotTable What-if Analysis values are automatically allocated.
E - fShowValuesRow (1 bit): A bit that specifies whether to show the values row in the PivotTable report.
F - fCalcMembersInAdvFilters (1 bit): A bit that specifies whether OLAP calculated members participate in manual filters (section 2.2.5.3.5) and advanced filters (section 2.2.5.3.6.1). This value MUST be a value in the following table.
-
Value
Meaning
0
OLAP calculated members do not participate in manual filters and advanced filters.
1
OLAP calculated members participate in manual filters and advanced filters as do other pivot items.
-
G - unused (2 bits): This value is undefined, and MUST be ignored.
sxma (4 bytes): An SXMA (section 2.5.148) that specifies the method of allocation to use for PivotTable What-if Analysis.
irstAltText (variable): An XLNullableWideString (section 2.5.167) that specifies the alternate text for the PivotTable view. This string MUST be less than or equal to 2,000 characters in length.
irstAltTextSummary (variable): An XLNullableWideString that specifies the alternate text summary for the PivotTable view. This string MUST be less than or equal to 2,000 characters in length.
irstWeight (variable): An XLNullableWideString that specifies the Multidimensional Expressions (MDX) of the weight expression for weighted allocations of PivotTable What-if Analysis. This string MUST be less than or equal to 65,535 characters in length.