The DCON record stores options from the Consolidate dialog box (Data menu).
Record Data
|
Offset |
Name |
Size |
Contents |
|
4 |
iiftab |
2 |
Index to the data consolidation function (see the following table) |
|
6 |
fLeftCat |
2 |
= 1 if the Left Column option is turned on |
|
8 |
fTopCat |
2 |
= 1 if the Top Row option is turned on |
|
10 |
fLinkConsol |
2 |
= 1 if the Create Links To Source Data option is turned on |
The iiftab field, described in the following table, corresponds to the Function option in the Consolidate dialog box (Data menu).
|
Function |
Iiftab |
|
Average |
0 |
|
Count Nums |
1 |
|
Count |
2 |
|
Max |
3 |
|
Min |
4 |
|
Product |
5 |
|
StdDev |
6 |
|
StdDevp |
7 |
|
Sum |
8 |
|
Var |
9 |
|
Varp |
10 |