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