DCON: Data Consolidation Information (50h)

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