SET

From 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