639x
003094
2023-05-02

Table Functions

The tables provide a variety of editing tools that facilitate data input and evaluation in tables. You can access them using the table menus and buttons as well as the shortcut menus of table cells.

Editing Table

You can edit a table with the options common in Excel spreadsheets. The most important functions are summarized in the following overview.

Function Shortcut Button Effect
Cut Ctrl + X Remove the content of the cell and save it in the clipboard.
Copy Ctrl + C Copy the cell content to the clipboard.
Insert Ctrl + V Insert the content of the clipboard into the cell. If the content of the clipboard is larger than a cell, the cells of subsequent table columns and rows are overwritten. A warning is displayed before.
Copy Row Ctrl + + Copy Row Overwrite the next row with the content of the current row.
Empty Row Ctrl + - Empty Row Delete the content of the row without deleting the row itself.
Insert Row Ctrl + i Insert Row Insert a new, empty row. The subsequent rows are moved downwards.
Delete Row Ctrl + r Delete Row Delete the current row. The subsequent rows are moved upwards.
Select / Open F7 Opening List Edit Object Open a list or a dialog box for selection in a cell.
Edit in Dialog Box Open Editing Dialog Box Open a dialog box where you can enter the data of the current row.

Editing Cells

In addition to the options for editing tables described above, functions are available to adjust the values of several cells. Select the corresponding cells as a "Selection", for example, by dragging the pointer over several table rows while holding down the left mouse button. Clicking on a table header selects the entire table column, and clicking on a row number selects the entire table row.

It is not important whether the cells are empty or not. Use one of the editing functions in the "Selection" menu to change the contents of selected cells. The functions are described in the following table. They are also available as buttons and in the shortcut menu of the selected cells.

Function Button Effect
Delete Delete Selection Delete all of the contents of the selected cells.
Add Add Selection Add/subtract a value to/from cells that contain numerical values.
Multiply Multiply Selection Multiply cells that contain numerical values by a specified factor.
Divide Divide Selection Divide cells that contain numerical values by a divisor.

After selecting the corresponding function, the "Operation" dialog box appears. Enter the addend, factor, or divisor.

Adjusting Table View

To adjust the presentation in the table, use the functions in the "View" menu or the corresponding buttons.

The functions are as follows:

Function Button Effect
Filled rows only Filled Rows Hide empty table rows
Marked rows only Marked Rows Show selected rows only
Selected objects only Selected Objects Show only the objects selected in the graphic
Show colored relation scale Relation Scale Red and blue bars are shown in the Result Tables.

Exporting Table

To export the current table to MS Excel, click the Export Current Table button.

MS Excel opens automatically. The worksheet contains all the content of the RSECTION table, including headers.

Info

To transfer several tables to Excel all at once, use the Export > Tables function in the File menu. Then, you can select the relevant tables in a dialog box.

Parent Chapter