Open Scrollsheet dialog

How to fill in the dialog box fields...

Fill in the dialog box fields as indicated below. You may also accept presented default values and options. Disregard grayed fields and options. When done, press Ok to continue. Or press Cancel to abort. If the file you want to open is a text file, this dialog will open a second time, with those fields active that allow you to specify the information which is only needed when importing foreign file formats.

Window
Use this radio button field either to select a size for the new window
or to specify how to merge data into an existing scrollsheet:

• normal = default size assigned by Windows™,
• fit to data = automatic fit of data to be shown,
• maximize = maximize new window,
• minimize = minimize as icon.

  The following two options instruct Wintrack to open the source scrollsheet, merge its data with a target scrollsheet and to close the source as soon as the data are merged. The target scrollsheet is the one displayed in the topmost scrollsheet window as the command is invoked. Columns of the source scrollsheet are transferred to the target scrollsheet creating new columns there as needed:

• add time series = transfer of data from the source to the target is controlled by time stamp or time stamp and date, expected in the first columns of both scrollsheets. For each time stamp / date in the target scrollsheet, Wintrack looks for a matching row in the source scrollsheet. If one is found, its data are transferred to the target scrollsheet. The maximal allowed time difference between matching time stamps is specified in the time tolerance field. This option works only with sampling intervals of 1s or longer. No new rows are added to the target scrollsheet.
• merge by name = transfer of data from the source to the target is controlled by case names which are expected in the first column of both scrollsheets. From each row of the source scrollsheet, data are transferred to the row in the target scrollsheet that has the same name. If no such row is found, a new one is appended to the target scrollsheet.

Options
If you are importing text files, use this check box field to select any combination of options:

• read column names = import column names from the first row of the source data,
• read column comments = import column comments from the second row of the source data,
• auto format numbers = use numbers in first data row as a template for formatting columns that contain numeric data.

scrollsheet file
Use this file field to specify the name and location of the file you want to open. You may specify Wintrack scrollsheet files (.WTB), tab-delimited text files (.TXT), comma-delimited text files (.CSV), and space-delimited text files with fixed column width (.LOG).

fixed columns
If you are importing text files, use this number field to specify the number of non-scrolling columns at the left edge of the scrollsheet.

time tolerance
If you have selected the add time series option in the Windows field, use this number field to specify the maximal allowed time difference between matching time stamps.

Note that...

When encountering a text file, Wintrack determines the column/field delimiter as follows. If the file contains any tab-characters, tab is used as delimiter. Else, the file is scanned for commata. If any are found, comma is used as delimiter. If a file contains neither tabs nor commata, it is assumed to be space-delimited with fixed column width. Tab-delimited text is the preferred format for data import from other applications. In this format cell data may contain spaces and/or commata. Space-delimited files may not be imported correctly if they contain empty cells.

Additional information...

• See the topic Open Scrollsheet command for basic information on the command.
• The equivalent macro statement is explained in the topic Open Scrollsheet statement.
• There are toolbar shortcuts to open a new scrollsheet.
• Inside scrollsheets provides advanced information on scrollsheets.
• See Creating and using macros to learn how to use and create macros.
• Keyboard Shortcuts gives an overview on keyboard shortcuts.
• Using the Wintrack toolbar gives an overview of toolbar shortcuts.