SHTPROPS: Sheet Properties (1044h)

This record specifies chart sheet properties.

Record Data—BIFF8

Offset

Name

Size

Contents

4

grbit

2

Property flags

6

mdBlank

1

Empty cells plotted as:
0 = not plotted
1 = zero
2 = interpolated


The grbit field contains the following option flags.

Offset

Bits

Mask

Name

Contents

0

0

01h

fManSerAlloc

1 = chart type has been manually formatted (changed from the default)

1

02h

fPlotVisOnly

1 = plot visible cells only

2

04h

fNotSizeWith

1 = do not size chart with window

3

08h

fManPlotArea

0 = use default plot area dimensions
1 = POS record describes plot-area dimensions

4

10h

fAlwaysAutoPlotArea

1 = user has modified chart enough that fManPlotArea should be set to 0

7-5

E0h

(reserved)

Reserved; must be zero

1

7-0

FFh

(reserved)

Reserved; must be zero


Record Data—BIFF7 and earlier

Offset

Name

Size

Contents

4

grbit

2

Property flags

6

mdBlank

1

Empty cells plotted as:
0 = not plotted
1 = zero
2 = interpolated


The grbit field contains the following option flags.

Offset

Bits

Mask

Name

Contents

0

0

01h

fManSerAlloc

1 = chart type has been manually formatted (changed from the default)

0

1

02h

fPlotVisOnly

1 = plot visible cells only

0

2

04h

fNotSizeWith

1 = do not size chart with window

0

3

08h

fManPlotArea

0 = use default plot area dimensions
1 = POS record describes plot-area dimensions

0

7-4

F0h

(reserved)

Reserved; must be zero

1

7-0

FFh

(reserved)

Reserved; must be zero