Project worksheet

Top  Previous  Next

Objects are provided for defining the screen pages. An object can be defined for each row in the Excel spreadsheet.

 

A screen page starts with the object #Page=name and ends with a blank line or with a line that does not start with the object prefix ‘#’.

The Page object defines the screen page (position and dimension) in which all the objects below are placed. An object starts with the #Object name. All rows that do not have the object prefix in the first column are comment lines.

 

Each EPAM object always has the following basic properties. Not every object supports all properties. Certain parameters are sometimes interpreted differently. Some properties are Mandatory and must always be specified, whilst others are Optional.

 

 

Column

Designation

M/O

Description

A

Object

M

Object name, possibly followed by =<ID>

B

Text/File

O/M

Object-dependent text or file.

C

Font

O

Font for text output. The font name refers to the font definition (font, style, size,...) in the Fontmap worksheet.

D

X [Pixel]

O

Position of the object in pixels from the left edge of the Container object. e.g. Page

Constant in pixels
Variable of type INT

E

Y [Pixel]

O

Position of the object in pixels from the top edge of the Container object. e.g. #Page

Constant in pixels
Variable of type INT

F

DX [Pixel]

O

Width of the object in pixels.

Constant in pixels
Variable of type INT

G

DY [Pixel]

O

Height of the object in pixels.

Constant in pixels
Variable of type INT

H

Color

O

Foreground and text color.

Constant (see: Colors)
Variable of type DWORD

I

Backcolor

O

Background color

Constant (see: Colors)
Variable of type DWORD

J

Format

 

Format definition, e.g. for the border

K

Action

O

Executable action, e.g. on actuation.

L

Limit1

O

Lower limit value as constant or variable.

M

Limit2

O

Upper limit value as constant or variable.

N

ActionLimit1

O

Executable action if VarValue is below Limit1.

O

ActionLimit2

O

Executable action if VarValue is above Limit2.

P

VarValue

O

Variable name

Q

VarType

O

Data type of VarValue, Limit1 and Limit2.

R

VarState

O

Status variable, for controlling the object status. This variable must be a numerical data type.

S

Option

O

Additional options that have an effect on the behavior or the display of the object.

T

Function

O

Contains predefined functions for converting variable values, e.g. with unit system conversion

U

Init Action

O

Action is executed on Init (initialization) of object.

V

Exit action

O

Action is executed on Exit (closing) of object.

W

Comment

O

Comment

X

Language column

O

Language-dependent texts and fonts from column X