This document covers the following topics:
A table control is a dialog element representing a spreadsheet. It provides an optional header row for naming the columns and an optional left column for naming the rows.
Once the table control has defined the spreadsheet as such, the columns are defined by adding column-specification controls. The cells of the table control are not defined as dialog elements but are identified by the values of the table control's COLUMN and ROW attributes. The first cell is identified by ROW =1 and COLUMN =1. The cells of each column may be used differently depending on the value of the column specification control's COLUMN-TYPE attribute: they may be used as input fields, selection boxes with items or toggle buttons.
You manipulate table controls with a set of PROCESS GUI statement actions.
| Attribute Name | Query | Set/Modify | In Attr. Window |
|---|---|---|---|
| BACKGROUND-COLOUR-NAME | X | X/X | |
| BACKGROUND-COLOUR-VALUE | X | X/X | |
| CHECKED | X | X/X | |
| COLUMN | X | X/X | |
| DIL-TEXT | X | X/X | |
| FOREGROUND-COLOUR-NAME | X | X/X | |
| FOREGROUND-COLOUR-VALUE | X | X/X | |
| ROW | X | X/X | |
| STRING | X | X/X |
The attributes that are valid for cells in table controls in general are not always available depending on the value of the column specification control's attribute COLUMN-TYPE. Such a value might be, for example, "input field control". The cell can then be used like an input field control. For this input-field cell, only a subset of the attributes is available.
The following table specifies which attributes are not applicable to specific COLUMN-TYPE.
| COLUMN-TYPE | Attributes NOT Available |
|---|---|
| Input field control | CHECKED |
| Selection box control | CHECKED |
| Toggle button control | STRING |
Change Event, Click Event, Delete Row Event, Double Click Event, Enter Event, Enter-Cell Event, Fill Event, Insert-Row Event, Leave Event, Leave-Cell Event, Top Event (all events may be suppressed).
The following events are not always triggered:
click event - only for toggle-button fields,
dbl-click event - for input-fields and toggle-buttons,
change event - only for input-fields and for selection-boxes.