SETWSY

Purpose:

Sets the top and bottom locations of the Worksheet.

Syntax:

SETWSY(ytop, ybottom)

ytop

-

A real, the top location. If 0 <= ytop <= 1, ytop is specified in normalized coordinates. If ytop > 1, ytop is specified in fixed pixels.

ybottom

-

A real, the bottom location. If 0 <= ybottom <= 1, ybottom is specified in normalized coordinates. If ybottom > 1, ybottom is specified in fixed pixels.

Example:

setwsy(0.1, 0.9)

 

The height of the displayed Worksheet is adjusted such that the top and bottom sides of the Worksheet are set to 10% of the total Worksheet area height. The height of the displayed Worksheet is 80% of the total Worksheet area height.

Example:

setwsy(0.05, 0.95)

 

The location of the displayed Worksheet is adjusted such that the top side of the Worksheet is 5% of the Worksheet area height and the bottom margin is 95% of the Worksheet area height. The width of the displayed Worksheet is 90% of the total Worksheet area height.

Example:

setwsy(10, 400)

 

The location of the Worksheet area is adjusted such that the top side of the displayed Worksheet is 10 pixels from the top of the Worksheet area and the bottom side of the Worksheet is 400 pixels from the top side of the Worksheet area. The height of the displayed Worksheet is 390 pixels.

Example:

setwsy(100)

 

The location of the Worksheet area is adjusted such that the top side of the displayed Worksheet is 100 pixels from the top of the Worksheet area and the bottom side of the Worksheet is unaffected resulting in a fixed top Worksheet margin of 100 pixels.

Remarks:

If ytop = ybottom = -1.0, the Worksheet is auto-sized to the total Worksheet area height.

 

The normal coordinate system is determined such that 0.0, 0.0 is the upper left corner of the Worksheet and 1.0, 1.0 is the lower right corner.

 

Because normalized coordinates essentially specify the Worksheet size as a fraction of the Worksheet display area, the relative size of the Worksheet will adjust as the size of the application changes. Use device coordinates to fix the Worksheet to specific size in pixels.

 

See SETWSCOORDS to set all the coordinates of the Worksheet.

See Also:

COLLAYOUT

GETWSCOORDS

GETWSIZE

GETWSXL

GETWSXR

GETWSYB

GETWSYT

GETWSIZE

LAYOUT

MOVEWIN

ROWLAYOUT

SETWMARGIN

SETWSCOORDS

SETWSX