xls_SET PAGE SETUP

xls_SET PAGE SETUP(reference;sheet;papersize;scalingfactor;startpagenumber;fitworksheetwidth;fitworksheetheight;optionflags)

Parameter          Type             Description
reference          Longint      ->  Excel handle
sheet              Longint      ->  Sheet number
papersize          Longint      ->  Papersize
scalingfactor      Longint      ->  Scaling factor in percent
startpagenumber    Longint      ->  Start with page number
fitworksheetwidth  Longint      ->  Fit worksheet width 
                                    to this number of pages
                                    (0 = use as many as needed)
fitworksheetheight Longint      ->  Fit worksheet height
                                    to this number of pages
                                    (0 = use as many as needed)
optionflags        Longint      ->  Options

Description

The command xls_SET PAGE SETUP sets the page setup of the sheet.

papersize see paper size table below:


Options:
0x01 = Print pages in row
0x02 = Portrait
0x04 = Paper size, scaling factor, and paper orientation (portrait/landscape) are not initialised
0x08 = Print black and white
0x10 = Draft quality
0x20 = Print cell notes
0x40 = Use default paper orientation (landscape for chart sheets, portrait otherwise)
0x80 = Use start page number above