Collabora Office 23.05 Help
You can define a table control to display the records as you like. In other words you can define data fields for displaying or editing data like in a database form.
The following fields are possible in a table control: text, date, time and currency field, numeric field, pattern field, check box and combo box. In the case of combined date/time fields, two columns are created automatically.
The number of selected lines, if any are selected, is in parentheses after the total number of records.
To insert columns into the table control, click in the column heads and bring up the context menu. The following commands are available:
Calls a submenu to select a data field to adopt it in the table control.
Configure the table control using drag and drop: Open the data source browser and drag the desired fields out of the data source browser and on to the column heads of the table control. A pre-configured column is created.
Opens a submenu to select a data field to replace the data field selected in the table control.
Deletes the currently selected column.
Opens the properties dialog of the selected column.
Hides the selected column. Its properties are not changed.
Calls a submenu where you can select the columns to show again. To show only one column, click the column name. You see only the first 16 hidden columns. If there are more hidden columns, choose the More command to call the Show Columns dialog.
Calls the Show Columns dialog.
In the Show Columns dialog you can select the columns to be shown. Hold down the Shift or key to select multiple entries.
Click All if you want to show all columns.
If you use the keyboard only to travel through controls in your document, you will find one difference to the other types of controls: the Tab key does not move the cursor to the next control, but moves to the next column inside the table control. Press +Tab to move to the next control, or press Shift+ +Tab to move to the previous control.
The form document must be in Design mode.
Press F6 to select the document.
+Press Shift+F4 to select the first control. If the Table Control is not the first control, press Tab until it is selected.
Press Enter to enter the edit mode. The handles are shown farther out from the control border.
In the edit mode, you can open the edit mode context menu by pressing Shift+F10.
If you want to edit columns, press Shift+Space to enter column edit mode. Now you can rearrange the order of columns with +Arrow keys. The Delete key deletes the current column.
Press the Esc key to exit the edit mode.