2.4.82 DCon
The DCon record specifies the data consolidation settings of the associated sheet and specifies the beginning of a collection of records as defined by the Macro Sheet Substream ABNF and Worksheet Substream ABNF. The collection of records specifies the source data ranges. Data consolidation settings can exist in a sheet that does not have a data consolidation range.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
iiftab |
fLeftCat |
||||||||||||||||||||||||||||||
|
fTopCat |
fLinkConsole |
||||||||||||||||||||||||||||||
iiftab (2 bytes): An unsigned integer that specifies the function used to aggregate the source data. MUST be a value from the following table:
|
Value |
Function Name |
Meaning |
|---|---|---|
|
0x0000 |
Average |
The average (arithmetic mean). |
|
0x0001 |
Count Numbers |
The count of the numeric values. |
|
0x0002 |
Count |
The count of data values. |
|
0x0003 |
Maximum |
The largest value. |
|
0x0004 |
Minimum |
The smallest value. |
|
0x0005 |
Product |
The product of the values. |
|
0x0006 |
Standard Deviation |
An estimate of the standard deviation of a population, where the sample is a subset of the entire population. |
|
0x0007 |
Standard Deviation Population |
The standard deviation based on the entire population. |
|
0x0008 |
Sum |
The summation of the numeric values. |
|
0x0009 |
Variance |
An estimate of the variance of a population, where the sample is a subset of the entire population. |
|
0x000A |
Variance Population |
The variance of a population, where the population is all of the data to be summarized. |
fLeftCat (2 bytes): A Boolean (section 2.5.14) that specifies how to identify rows for data consolidation. MUST be a value from the following table:
|
Value |
Meaning |
|---|---|
|
0x0000 |
Data consolidation is based on the position of the row in the source data ranges. |
|
0x0001 |
Data consolidation is based on row labels from the leftmost column of the source data ranges. String comparison is case independent and the consolidated data contains a row for each unique row label. The unique row labels appear in the first column in the consolidation range, if it exists. |
fTopCat (2 bytes): A Boolean that specifies how to identify columns for data consolidation. MUST be a value from the following table:
|
Value |
Meaning |
|---|---|
|
0x0000 |
Data consolidation is based on the position of the column in the source data ranges. |
|
0x0001 |
Data consolidation is based on column labels from the top row of the source data ranges. String comparison is case independent and the consolidated data contains a column for each unique column label. The unique column labels appear in the top row of the consolidation range, if it exists. |
fLinkConsole (2 bytes): A Boolean that specifies whether data consolidation will create references to the source data. MUST be a value from the following table:
-
Value
Meaning
0x0000
References are not created to the source data.
0x0001
References are created to the source data.