GRID Control Grid

Column, Row Values

How ProvideX Interprets These

col = 1, row = 1

The topmost cell is 1,1

col = 0, row = 0

All columns and rows respectively; i.e.,

GRID DELETE 100,0,0 deletes the entire grid whose control ID is 100.

col = num, row = 0
(col <> 0, row = 0 or omitted)

Entire column; i.e., GRID DELETE 100,3,0 deletes column 3 of the grid whose control ID is 100.

Note that the GOTO and FIND formats of the grid directive require both column and line coordinates. You cannot omit the row in those formats.

col = 0, row = num
(col = 0 or omitted, row <> 0)

Entire row; i.e., GRID DELETE 100,0,2 deletes row 2 of the grid whose control ID is 100.

Note that the GOTO and FIND formats of the grid directive require both column and line coordinates. You cannot omit the column in those formats.

col =num, row=num
(col and row are <> 0)

Column and row; i.e.,

GRID DELETE 100,3,2 deletes both an entire column (column 3) and an entire row (row 2) of the grid whose control ID is 100.

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

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.

The following cell types can be assigned using the FMT= option in the GRID directive or via the 'Celltype$ grid object property:

Cell type	Description
"Button"	Cell works like a button if clicked. Cell can be changed if not locked (on double click). Set 'Lock property to 1 to achieve standard button behaviour for cell.
"CheckBox"	Check box with no 3D effect ('Value=0 or 1,'Text=label).
"CheckBoxRaised"	3D check box that looks raised.
"CheckBoxRecessed"	3D check box that looks recessed.
"CheckMark"	Check box that uses a check mark.
"CheckMarkRaised"	Raised check box that uses a check mark
"CheckMarkRecessed"	Recessed check box that uses a check mark.
"DropBox"	Text cell that, when editing, allows user to make selection from a drop down list. The drop list is loaded from the 'Text$ property.
"DropBoxHideBtn"	Same as "DropBox", but the drop down button is shown only when focus is on the cell.
"Ellipsis"	Normal text cell that will show "… if text exceeds displayable area. Ctrl - Enter can be used to force a new line in the cell (inserts $0D0A$ into cell value).
"EllipsisDrop"	Same as "Ellipsis", but forces the cell to drop vertically only during an edit. Ctrl - Enter can be used to force a new line in the cell (inserts $0D0A$ into cell value).
"Lookup"	Small button at the right side of cell used to invoke lookup - button image is defined via the cell’s 'Bitmap property. If no image is given, button shows three dots.
"LookupHideBtn"	Same as "Lookup", but indicates that the button is hidden when the cell is not selected.
"Multi_line"	Normal text cell that can contain multiple lines of text. * Note* Ctrl - Enter can be used to force new line (value $0D0A$).
"Normal"	Normal text cell containing one line of data.
"Query"	Same as "Lookup", but user is unable to edit the cell.
"QueryHideBtn"	Same as "LookupHideBtn", but user is unable to edit the cell.
"SingleLine"	Normal text cell that allows for a single line of entry, expanding the cell horizontally according to the overlap rules. It does not allow vertical expansion, like a multiline.
"UseTextNormal" "UseTextSingleLine" "UseTextEllipsis"	Similar to "Normal","SingleLine" and"Ellipsis" respectively, except value of 'Text$ property is displayed. During input and editing, the'Value$ property is presented and entered into the cell.
"VarDropBox"	Text cell that, when editing, allows user to make a selection from a dropdown list or enter any other value. Drop list selections are loaded using 'Text$ property.
"VarDropBoxHideBtn"	Same as "VarDropBox", but the drop down button is shown only when focus is on the cell.