2.4.309 Sxvd
The Sxvd record specifies pivot field properties and that specifies the beginning of a collection of records as defined in the Worksheet substream ABNF. This collection of records specifies details for a pivot field.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
sxaxis |
cSub |
||||||||||||||||||||||||||||||
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
M |
cItm |
||||||||||||||||||
|
cchName |
stName (variable) |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
sxaxis (2 bytes): An SXAxis structure that specifies the PivotTable axis that this pivot field is on. If the sxaxis.sxaxisData field equals 1, there MUST be a corresponding SXDI record with an isxvd field that specifies this Sxvd record.
cSub (2 bytes): An unsigned integer that specifies the number of subtotal functions used for this pivot field. MUST equal the count of subtotal fields of this record whose value is 1. The subtotal fields of this record are fDefault, fSum, fCounta, fAverage, fMax, fMin, fProduct, fCount, fStdev, fStdevp, fVariance, and fVariancep. For more information, see Subtotalling.
A - fDefault (1 bit): A bit that specifies whether the default subtotal function is applied. The default subtotal is separately determined for each data item. If the fDefault field equals 1 and the sxaxis.sxaxisRw field equals 1 or if the sxaxis.sxaxisCol field equals 1 or if the sxaxis.sxaxisPage field equals 1, there MUST be one SXVI record with the itmType field of the SXVI record equal to 1. MUST be a value from the following table:
-
-
-
Value
Meaning
0
The default subtotal function is not applied.
1
The default subtotal function is applied.
-
-
B - fSum (1 bit): A bit that specifies whether the sum subtotal function is displayed. If the fDefault field equals 1, this value MUST be 0. If the fSum field equals 1 and the sxaxis.sxaxisRw field equals 1 or if the sxaxis.sxaxisCol field equals 1 or if the sxaxis.sxaxisPage field equals 1, there MUST be one SXVI record with the itmType field of the SXVI record equal to 2. MUST be a value from the following table:
-
-
-
Value
Meaning
0
The sum subtotal function is not displayed.
1
The sum subtotal function is displayed.
-
-
C - fCounta (1 bit): A bit that specifies whether the count subtotal function is displayed. If the fDefault field equals 1, this value MUST be 0. If the fCounta field equals 1 and the sxaxis.sxaxisRw field equals 1 or if the sxaxis.sxaxisCol field equals 1 or if the sxaxis.sxaxisPage field equals 1, there MUST be one SXVI record with the itmType field of the SXVI record equal to 3. MUST be a value from the following table:
-
-
-
Value
Meaning
0
The count subtotal function is not displayed.
1
The count subtotal function is displayed.
-
-
-
D - fAverage (1 bit): A bit that specifies whether the average subtotal function is displayed. If the fDefault field equals 1, this value MUST be 0. If the fAverage field equals 1 and the sxaxis.sxaxisRw field equals 1 or if the sxaxis.sxaxisCol field equals 1 or if the sxaxis.sxaxisPage field equals 1, there MUST be one SXVI record with the itmType field of the SXVI record equal to 4. MUST be a value from the following table:
-
-
-
Value
Meaning
0
The average subtotal function is not displayed.
1
The average subtotal function is displayed.
-
-
E - fMax (1 bit): A bit that specifies whether the max subtotal function is displayed. If the fDefault field equals 1, this value MUST be 0. If the fMax field equals 1 and the sxaxis.sxaxisRw field equals 1 or if the sxaxis.sxaxisCol field equals 1 or if the sxaxis.sxaxisPage field equals 1, there MUST be one SXVI record with the itmType field of the SXVI record equal to 5. MUST be a value from the following table:
-
-
-
Value
Meaning
0
The max subtotal function is not displayed.
1
The max subtotal function is displayed.
-
-
F - fMin (1 bit): A bit that specifies whether the min subtotal function is displayed. If the fDefault field equals 1, this value MUST be 0. If the fMin field equals 1 and the sxaxis.sxaxisRw field equals 1 or if the sxaxis.sxaxisCol field equals 1 or if the sxaxis.sxaxisPage field equals 1, there MUST be one SXVI record with the itmType field of the SXVI record equal to 6. MUST be a value from the following table:
-
-
-
Value
Meaning
0
The min subtotal function is not displayed.
1
The min subtotal function is displayed.
-
-
-
G - fProduct (1 bit): A bit that specifies whether the product subtotal function is displayed. If the fDefault field is 1, this value MUST be 0. If the fProduct field is 1 and the sxaxis.sxaxisRw field equals 1 or if the sxaxis.sxaxisCol field equals 1 or if the sxaxis.sxaxisPage field equals 1, there MUST be one SXVI record with the itmType field of the SXVI record equal to 7. MUST be a value from the following table:
-
-
-
Value
Meaning
0
The product subtotal function is not displayed.
1
The product subtotal function is displayed.
-
-
-
H - fCount (1 bit): A bit that specifies whether the count numbers subtotal function is displayed. If the fDefault field is 1, this value MUST be 0. If the fCount field equals 1 and the sxaxis.sxaxisRw field equals 1 or if the sxaxis.sxaxisCol field equals 1 or if the sxaxis.sxaxisPage field equals 1, there MUST be one SXVI record with the itmType field of the SXVI record equal to 8. MUST be a value from the following table:
-
-
-
Value
Meaning
0
The count numbers subtotal function is not displayed.
1
The count numbers subtotal function is displayed.
-
-
-
I - fStdev (1 bit): A bit that specifies whether the standard deviation subtotal function is displayed. If the fDefault field is 1, this value MUST be 0. If the fStdev field equals 1 and the sxaxis.sxaxisRw field equals 1 or if the sxaxis.sxaxisCol field equals 1 or if the sxaxis.sxaxisPage field equals 1, there MUST be one SXVI record with the itmType field of the SXVI record equal to 9. MUST be a value from the following table:
-
-
-
Value
Meaning
0
The standard deviation subtotal function is not displayed.
1
The standard deviation subtotal function is displayed.
-
-
J - fStdevp (1 bit): A bit that specifies whether the standard deviation population subtotal function is displayed. If the fDefault field equals 1, this value MUST be 0. If the fStdevp field equals 1 and the sxaxis.sxaxisRw field equals 1 or if the sxaxis.sxaxisCol field equals 1 or if the sxaxis.sxaxisPage field equals 1, there MUST be one SXVI record with the itmType field of the SXVI record equal to 10. MUST be a value from the following table:
-
-
-
Value
Meaning
0
The standard deviation population subtotal function is not displayed.
1
The standard deviation population subtotal function is displayed.
-
-
-
K - fVariance (1 bit): A bit that specifies whether the variance subtotal function is displayed. If the fDefault field is 1, this value MUST be 0. If the fVariance field is 1 and the sxaxis.sxaxisRw field equals 1 or if the sxaxis.sxaxisCol field equals 1 or if the sxaxis.sxaxisPage field equals 1, there MUST be one SXVI record with the itmType field of the SXVI record equal to 11. MUST be a value from the following table:
-
-
-
Value
Meaning
0
The variance subtotal function is not displayed.
1
The variance subtotal function is displayed.
-
-
-
L - fVariancep (1 bit): A bit that specifies whether the variance population subtotal function is displayed. If the fDefault field is 1, the value MUST be 0. If the fVariancep field equals 1 and sxaxis.sxaxisRw field equals 1 or if the sxaxis.sxaxisCol field equals 1 or if the sxaxis.sxaxisPage field equals 1, there MUST be one SXVI record with the itmType field of the SXVI record equal to 12. MUST be a value from the following table:
-
-
-
Value
Meaning
0
The variance population subtotal function is not displayed.
1
The variance population subtotal function is displayed.
-
-
-
M - reserved (4 bits): MUST be zero, and MUST be ignored.
cItm (2 bytes): A signed integer that specifies the number of pivot items for this pivot field. This value MUST match the number of SXVI records following this record and MUST be less than or equal to the following formula:
-
-
32500 + the cSub field
-
cchName (2 bytes): An unsigned integer that specifies the length, in characters, of the stName field. If the value is 0xFFFF then stName is NULL. The value MUST be 0xFFFF or greater than zero and less than or equal to 255.
stName (variable): An XLUnicodeStringNoCch structure that specifies the caption of this pivot field. A non-NULL value specifies that this string is used to override the stFieldName field in SXFDB record from the associated cache field, as specified in pivot fields. The length is specified in cchName. This field exists only if the value of cchName is not 0xFFFF. If this PivotTable view is not an OLAP PivotTable view and this string is non-NULL, then stName MUST be unique within all Sxvd records in this PivotTable view.