View table - Totals calculation
Data tab /
Edit total calculation
In this dialog box, the cells of the total calculation of a table can
be configured. Only the columns that are visible in the table (i.e.
that are not hidden) can be used in the calculation. Under each column name,
you will see a corresponding number. This number represents the index used
in the calculation for a table column.
Please note that for actions such as adding, moving, or deleting
table columns, that only the index of the visible columns is
adjusted in the area of the total amount. The contents of a
column are not automatically moved, but they may be deleted,
depending on the action. Adjustments to the content must be
performed by the users themselves. Columns are always added or
deleted at the end of the total amount area.
Opens a menu where you can select whether you'd like to add a
or a Calculation
The currently selected control is removed. Place controls for the calculation
in the free cell underneath the column index of the column that needs to be
Opens the Formula editor
Opens a menu with the following functions:
- Insert row
- Delete row
- Merge cells
- Divide cells
- Select user-defined background color
Moves columns and cells with controls to the left or right,
Moves rows up or down, respectively.
Move content via drag & drop
Cell contents can also be moved to empty cells via drag & drop.
However, in contrast to moving via the arrow buttons, only the
contents of the cells will be moved, not the properties of the cells.