Open Scrollsheet command

How to open a scrollsheet...

1. Select Open Scrollsheet from the File Menu.
2. A dialog box appears. Press the Help button if you need instructions on how to fill in the dialog box fields. Fill in the fields that are not grayed or accept defaults and press Ok to continue. Or press Cancel to abort.
3. If the file you want to open is a text file, this will be recognized automatically and the dialog will open a second time with those fields active that allow you to specify additional information which is needed to import text files.
4. Wintrack will open the document and, depending on the selected options, display it on screen as the active document or merge its data with a previously opened scrollsheet.

   You use this command not only to open Wintrack scrollsheets, but also to import tables that have been saved as text files by other Windows™ applications, for example by MS Excel™.

How to merge two scrollsheets...

1. Open the target scrollsheet as described above. In the Open Scrollsheet dialog, select one of the following options: normal, fit to data, maximize or minimize.
2. Open the source scrollsheet as described above. In the Open Scrollsheet dialog, now select either the option add time series or merge by name. The data of the source sheet will be merged into the target sheet and the source sheet will close as soon as the operation is completed.

Related commands...

To save scrollsheets to disk, you use the Save Scrollsheet or Save Scrollsheet As commands. New scrollsheets are created using the New Scrollsheet command. The Save Scrollsheet As command also lets you copy scrollsheets to the Windows™ clipboard, so you can paste their content into other Windows™ applications The Analyze Case and Filter Case commands use scrollsheets to report their results: you may later reopen such a scrollsheet and continue to add results to it. The Run Macro command can use scrollsheets as parameter tables. Numeric scrollsheet data can be transformed using the Z-Transform Scrollsheet command.

Additional information...

• See Open Scrollsheet dialog for details on the associated dialog box.
• The equivalent macro statement is explained in Open Scrollsheet statement.
• There is a toolbar shortcut 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.