ProvideX V8.20 > Language Reference > 2. Directives

144

Column, Row Values

How ProvideX interprets these ...

col=1, row=1

The topmost cell is 1,1

col and/or row = -1

By default, there are also column and row headers you

can gain access to using column and/or row = -1. You

cannot include these headers in any range specifications.

col=n, row=0

Entire column; i.e., GRID DELETE 100,3,0 deletes

column 3 of the grid whose control ID is 100. GOTO and

FIND formats of the grid directive require both column and

(col <> 0, row = 0

or omitted)

line coordinates. You cannot omit the row in those formats.

col=0, row=n

Entire row; i.e., GRID DELETE 100,0,2 deletes row 2 of

the grid whose control ID is 100. GOTO and FIND formats

of the grid directive require both column and line

(col = 0 or omitted,

coordinates. You cannot omit the column in those formats.

row <> 0)

col=n, row=n

Column and row; i.e., GRID DELETE 100,3,2 deletes

both an entire column (column 3) and an entire row (row 2) of

(col and row are <> 0)

the grid whose control ID is 100. GRID GOTO 100,3,2

sets focus on the cell located in column 3, row 2.

When setting a grid property, setting both the row and column to zero allows you to

set that property as a default for the entire grid (or for a specified column if the row

is set to zero and column is set to a non-zero number). If a specific row (row=n,

column=0) or an individual cell (row=n, column=n) is specifed, then defaults no

longer apply to these cells (rows cannot have default settings, but you can set values

for all cells in the row), so if a new property default is set for a column or the entire

grid, then the row or individual cells will be excluded.

Format Definition

The FMT=def$ option allows you to define the format for cells in the grid. In the

following syntax, the round and square brackets are part of the format:

FMT=[col_title](cell_type:col_name$) Alignment Width

Where:

Alignment character: L (left), C (centred), R (right). Default: L.

Alignment

cell_type

Cell type for the column. The default cell type is "Normal". See

Cell Types for a list of available cell types.

col_title

Text string appearing as the title in the top row of the grid.

col_name$

Column name. This can be a string or numeric variable.

width

Width of the column in .

Example:

"[Client ID](Multi_line:CST_ID$)L10 [Name](Normal:CST_NAME$)L10"