|
Table of Variables dialog |
Scroll |
It allows to create or edit the table of variables of current file.
Dialog Table of Variables contains the actual table and the buttons above it to invoke commands.
Description of Controls
The element |
Description |
|
|
Read from File |
The button allows you to import into Variable table information from MS Excel file. The contents of the imported file must meet certain requirements. After you click the button, the file opening dialog appears on the screen. Select the required file and click the Open button. The data from the selected file will be transferred to the table of variables. |
|
Save to File |
The button allows you to save the table of variables in the MS Excel file. The button becomes available after entering information into the table. After you click the button, the file recording dialog appears on the screen. Set the location and file name and click Save. The table of variables will be written to the MS Excel file. If the column headings are empty or contain the same variable name, the table cannot be saved. In this case, after pressing the Save to File button, a message will appear on the screen: Cannot save the table. |
|
Read External Variables |
The button allows you to transfer external variables and their values from a file to Variable table. |
|
Insert row above |
A group of buttons allows you to change the number of rows in a table. The Delete Rows button is available after selecting a row or cell. |
|
Insert row below |
|
|
Delete Rows |
|
|
Insert Column to the Left |
The group of buttons allows you to change the number of columns in a table. The Delete column button is available after selecting a column or cell. |
|
Insert Column to the Right |
|
|
Delete Column |
|
|
Move Up |
The group of buttons allows you to move the selected lines in the vertical direction. Buttons are available after selecting a row or cell. |
|
Move Down |
|
|
Show only first column when inserting |
If the button is pressed, while inserting this file into another document in Variable table only the first column will be displayed – a column with comments. |
In the central part of the dialog, either a new or already created table is displayed.
The first row of the table is highlighted; its cells, starting with the second, are used to display the names of variables. Cells of the first column with a “Comment” heading are intended for explanations of variable sets. The remaining table cells are for numeric values of variables.
The row added to the empty table has the comment “New row”. When adding the next line, the selected line is copied.
When adding columns, the dialog for entering the column name appears on the screen.
To enter or edit a comment or a variable value, click in the cell, enter the data and press <Enter>. You can use the arrow keys to navigate to the adjacent cells.
To select a row, click to the left of its first cell. To select a column, click its header.
Set values of variables button located at the bottom of the dialog allows you to transfer the values of external variables from the Variable Table to a file. The button is available after selecting a row or cell. After you click the button, the external variables of the file take on the values indicated in the highlighted line of the Variable Table. Values will be assigned only to those variables whose names match the column headings of the table. Simultaneously with the transfer of values dialog Table of Variables closes with changes.
To close the dialog and save the changes, click Apply. The values of the external variables of the file do not change.
To close the dialog and save the changes, click Cancel.
|
When inserting a file with external variables into another document, all buttons except the Show only first column when inserting button is not available. Editing the table is also not available. |
See Also
