Export (0) Print
Expand All
Expand Minimize

2.4.82 DCon

Office

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 SubstreamABNF and Worksheet Substream ABNF. The collection of records specifies the source dataranges. Data consolidation settings can exist in a sheet that does not have a data consolidation range.


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

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.

Show:
© 2014 Microsoft