USERBVIEW: Workbook Custom View Settings (1A9h)

The USERBVIEW record stores settings for a custom view in the workbook.

Record Data BIFF8

Offset

Name

Size

Contents

4

iViewId

4

ID for the custom view.

8

iTabid

4

Tab index for the active sheet (1-based).

12

guid

16

Globally unique identifier for the custom view.

28

x

4

Horizontal position of window.

32

y

4

Vertical position of window.

36

dx

4

Width of window.

40

dy

4

Height of window.

44

wTabRatio

2

Ratio of the width of the workbook tabs to the width of the horizontal scroll bar; to obtain the ratio, convert to decimal and then divide by 1000.

46

grbit1

2

Option flags.

48

grbit2

2

Option flags.

50

wMergeInterval

2

Time interval between automatic merges of shared workbook.

52

(Reserved)

2

54

st

var

Name of custom view as a unicode string; for more information see "Unicode Strings in BIFF8" on page 264.


The grbit1 field contains the option flags listed in the following table.

Bits

Mask

Name

Contents

0

0001h

fDspFmlaBar

= 1 if the formula bar is displayed

1

0002h

fDspStatus

= 1 if the status bar is displayed

2

0004h

fNoteOff

= 1 if the comment indicator is off

3

0008h

fDspHScroll

= 1 if the horizontal scroll bar is displayed

4

0010h

fDspVScroll

= 1 if the vertical scroll bar is displayed

5

0020h

fBotAdornment

= 1 if the workbook tabs are displayed

6

0040h

fZoom

= 1 if the workbook window is maximized

8 – 7

0180h

fHideObj

= 10 if the Hide All option is turned on
= 01 if the Show Placeholders option is turned on
= 00 if the Show All option is turned on

15 – 9

FE00h

(Reserved)


The grbit2 field contains the option flags listed in the following table.

Bits

Mask

Name

Contents

15 – 0

FFFFh

(Reserved)

Reserved; must be 0 (zero)