P&K 2714

Operation within the tables

Product has been archived / Produkt wurde archiviert

The order and the width of all columns can be changed by clicking into a column header or between column headers and dragging as desired. This is practical if values are in a particular order, because Tab has to be pressed just once in order to reach the next column.

If the data in the columns are too wide to be displayed, then the symbols (in brackets) will be hidden in the column titles (e.g. Temperature (T₀) ). Widening of the column will show that particular symbol.

The buttons "+" and "-" are used to insert or delete data sets. With the button "Dup" the current data set can be duplicated. The new row will become the last row in the table. This is useful if a data set is to be generated with minor difference to the current one. To insert a row, select the lower gray row before pressing the "+" button.

Individual fields, in which a selection is possible, are marked yellow. To activate the selection click once in a cell in order to select this; click a second time in order to activate the selection (no doubleclick).

With the cursor or Tab key, the focus can be moved between individual fields.

The illustrated section can be scrolled one row up or down by moving the cursor across the upper or lower edge of the table form.

Some tables can be sorted. With a right mouse button click into the considerable column, a Pull-Down Menu will be opened, and Sort Ascending or Sort Descending can be selected.

In some tables, a Row-Editor can be invoked. The Row-Editor shows one dataset only and can have more or less features then the grid dialog.

Sometimes single Columns can be imported via the Popup Menu. From the selected file, the values are taken and written to the position, from which the dialog was invoked. One value will be read per line from an ASCII file (includes CSV format) .

Some tables feature a search function. See Find in table

See: Calculator and Alter Column Values.

Filter

This feature allows to filter out a column with its value. Only rows with this value in the filtered column and not this column will be shown. The filter can be set to most of the columns (except when they are declared unique). All available column names are shown in the selector next to "Filter:". Once a column is selected, a corresponding value out of this column can be selected in the selector to the right of the equal sign. Filtering is accomplished on a text basis rather than on a value basis (e.g. 1.0 doesn't equal 1).

Using the filter feature will reorder the rows. Only columns, which are not defined as unique, can be selected. Some table can be sorted (Right Mouse Button Click into the column of regard.)

A filter might be active during import / export to exclude or include rows of data.

Table Import and Export

In most tables, data can be imported or exported with the buttons in the tool bar. The sequence of the columns and which columns are used, depends on the current column order and the current filter setting. With a button in the tool bar, a form can be opened which gives information about the current settings.

Single Columns can be imported via the Popup Menu. From the selected file, the values are taken and written to the position, from which the dialog was invoked. One value will be read per line from an ASCII file (includes CSV format) .

Available formats for import and export

CSV	Columns are separate by commas (Comma Separated Values). If a text contains commas, it must be written in " " (Quotation marks). The decimal character is the point. Values can optionally contain an exponent (e.g.: 6.E-9), however no additional separators are allowed.
TXT	Columns are separated by spaces. If a text contains spaces, it must be written in ' ' (Apostrophe). The decimal character is the point. Values can optionally contain an exponent (e.g.: 6.E-9), however no additional separators are allowed.
Current Project Extension	Individual tables can be loaded from project files. The loaded table must fit logically into the project. The export creates a new project file, which contains only the exported table.
*	On selection of the file type [With Options (.)], the form Table Import Options will be opened, in which further parameters are available.

The formats can be selected in the appropriate dialogs under the type of file. The filter function is switched off for other formats than CSV, TXT and *!

Preview

The tables can be viewed appealingly as an HTML-file by using the preview function. see Report function.

Also see: Calculator