SET

LANSA Integrator

previous page next page

SET

The SET command is used to change the sheet settings of the specified sheet.

The SET command must be preceded by an OPEN command with write mode.

 

                                                         Required

 

 SET ----------------------------------------------------------->

 

                                                         Optional

 

          >-- SHEET ------------ sheet1 ------------------------>

                                 value

 

          >-- FREEZE ----------- value ------------------------->

 

          >-- SELECTED --------- *YES -------------------------->

                                 *NO

 

          >-- GRIDS ------------ *YES -------------------------->

                                 *NO

 

          >-- ORIENTATION ------ *PORTRAIT --------------------->

                                 *LANDSCAPE

 

          >-- PROTECT ---------- *YES -------------------------->

                                 *NO

 

          >-- PASSWORD --------- value ------------------------->

                                 *NONE

 

          >-- MARGIN ----------- value ------------------------->

 

          >-- HEADER ----------- *LEFT ------------------------->

                                 *RIGHT

                                 *CENTER

 

          >-- FOOTER ----------- *LEFT ------------------------->

                                 *RIGHT

                                 *CENTER

 

          >-- CONTENT ---------- value ------------------------->

 

          >-- PRINTAREA -------- value ------------------------->

 

          >-- PRINTTOFIT ------- *YES -------------------------->

                                 *NO

 

          >-- PRINTSCALE ------- value -------------------------|

 

Keywords

SHEET

A specific sheet name can be entered otherwise the default value of sheet1 will be used.

FREEZE

Set horizontal row freeze or column vertical freeze.
The value is the horizontal row and the vertical column component values comma separated.
An empty string value is used to allow a component value to be ignored.

SELECTED

Set this sheet to be the selected sheet.
Possible values are *YES or *NO.

GRIDS

Show or hide the sheet grids.
Possible values are *YES or *NO.

ORIENTATION

Specify the sheet orientation.
Possible values are *LANDSCAPE or *PORTRAIT.

PROTECT

Enable or disable sheet protection.

PASSWORD

The worksheet protection password is optional and is used in combination with the PROTECT keyword. The special value of *NONE causes the password to be removed.

MARGIN

Set sheet margins.
The value is top margin, bottom margin, left margin, right margin, header margin and footer margin component values comma separated.
An empty string value is used to allow a component value to be ignored.
The unit of measurement is in inches as a float value.

HEADER

Specify which header content to change. The possible values are *LEFT,*RIGHT or *CENTER.

FOOTER

Specify which footer content to change. The possible values are *LEFT, *RIGHT or *CENTER.

CONTENT

The header or footer content text.
Special substitution values can be used within the header and footer text.
&D Date
&T Time
&P Page Number
&N Total Number of Pages
&B Bold
&U Underline
&I Italics
&S Strike Through
&E Double Underline
&X Superscript
&Y Subscript
&F Workbook Name
&AWorksheet Name
&"font name" Font Name
&nn Font Size (Must be a two digit number. 01 to 99)
&NL New Line

PRINTAREA

Set print area.
The value is a cell range specified by comma separated values row1, column1, row2, column2.

PRINTTOFIT

Enable or disable fits to page mode.
The possible values are *YES or *NO.

PRINTSCALE

Set print scale factor.

 

previous page start next page