3.7.5 Workbook: BrtBookView

The next record in this example, BrtBookView (section 2.4.310) specifies a single workbook view, as specified in the following table.

Size

Structure

Value

001D

BrtBookView - BrtBookView

0004

    LONG - xWn

0x00000078

0004

    LONG - yWn

0x0000001E

0004

    DWORD - dxWn

0x00005CD0

0004

    DWORD - dyWn

0x00003930

0004

    DWORD - iTabRatio

0x00000258

0004

    DWORD - itabFirst

0x00000000

0004

    DWORD - itabCur

0x00000000

1 bit

    BYTE - fHidden

0x0

1 bit

    BYTE - fVeryHidden

0x0

1 bit

    BYTE - fIconic

0x0

1 bit

    BYTE - fDspHScroll

0x1

1 bit

    BYTE - fDspVScroll

0x1

1 bit

    BYTE - fBotAdornment

0x1

1 bit

    BYTE - fAFDateGroup

0x1

1 bit

    BYTE - unused

0x0

Structure of BrtBookView

xWn: 0x00000078 specifies that the X coordinate for the top-left corner of the window that contains the workbook is 120 twips.

yWn: 0x0000001E specifies that the Y coordinate for the top-left corner of the window that contains the workbook is 30 twips.

dxWn: 0x00005CD0 specifies that the width of the window that contains the workbook is 23760 twips.

dyWn: 0x00003930 specifies that the height of the window that contains the workbook is 14640 twips.

iTabRatio: 0x00000258 specifies that the ratio of the width of the sheet tabs to the width of the horizontal scroll bar is 600.

itabFirst: 0x00000000 specifies the first sheet in this workbook view, which is the BrtBundleSh (section 2.4.313) record in the collection of all records directly following BrtBeginBundleShs (section 2.4.13).

itabCur: 0x00000000 specifies the active sheet in this workbook view, which is the BrtBundleSh record in the collection of all records directly following BrtBeginBundleShs.

fHidden: 0x0 specifies that the window that contains the workbook is not hidden.

fVeryHidden: 0x0 specifies that the window that contains the workbook is not hidden.

fIconic: 0x0 specifies that the window that contains the workbook is not minimized.

fDspHScroll: 0x1 specifies that the horizontal scrollbar is displayed in the workbook view.

fDspVScroll: 0x1 specifies that the vertical scrollbar is displayed in the workbook view.

fBotAdornment: 0x1 specifies that the sheet tabs are displayed in the workbook view.

fAFDateGroup: 0x1 specifies to group dates with the filtering options in the user interface.