Table#

Important

This ribbon tab will only show up if a table_small list/table item is selected in the document tree widget. Refer to our video below, which will try to explain the table ribbon behavior.

See also

To learn how to use the table ribbon menu, please refer to Create a Table Output.
In case you want to learn how to use the Export to XLSX or CSV, then please refer to Export Results to Excel.

Contains all important commands regarding table operations:

  • Copy and configured copy to clipboard.

  • Edit: Sorting, hide/show columns, find in table, conditional formatting, rename table…

  • Output: export to report (PLB) or Excel (XLSX) file with different additional properties.

‘’Clipboard’’ ribbon group#

Icon

Command

Description

copy_large

Copy Selection

 Copy selected elements from table to clipboard.

configured_copy_large

Orientation

 Copy configured format to clipboard.

To configure the copy, run configure_large Configure command.

configure_large

Partition

 Configure the configured copy command (format, extend, additional data...).
‘’Edit’’ ribbon group#

Icon

Command

Description

table_sort_large

Sort

 Set the sorting type of the table.

Available options are:

  • Ascending

  • Descending

  • Unsorted default

A column selection is required for sorting. Sorting via context menu is also possible. Steps:

  1. Click on the column with the RMB right_mouse_button_small

  2. Sorting

  3. Select: Ascending/Descending/Unsorted

table_columns_large

Columns

 Hide/show columns.

configure_large

Find

 A find dialog will show up. Via the dialog you can search data in the selected table.

table_find_large

Rename

 Rename column names. First select a column in the table and then click on 'Rename' command.

table_conditional_formatting_large

Conditional Formatting

 Activate conditional formatting for selected columns.
‘’Output’’ ribbon group#

Icon

Command

Description

convert_table_to_plb_large

Output to PLB

 The table will be outputted to a PLB (Report) file.

Use FILE report_browser_large ‘’Generate Report…’’ to generate a PLB file.

convert_table_to_excel_large

Output to XLSX

 The table will be outputted to a XLSX (Excel) file.

Use FILE excel_file_large ‘’Export to XLSX’’ to export all (marked XLSX) tables to excel file(s).

configure_plb_export_large

Settings (PLB Output)

 Set the output settings for PLB/XLSX types. Depending on the output type, the setting dialog will change.

configure_excel_export_large

Settings (XLSX Output)

 Set the output settings for PLB/XLSX types. Depending on the output type, the setting dialog will change.