Inside scrollsheets

Representation of data...

Wintrack scrollsheets are tables which contain combinations of numeric and text data. They are stored on disk in the proprietary Wintrack scrollsheet file format (extension .WTB) which preserves full precision and formatting. Scrollsheets are organized in rows (maximum 61439) and columns (maximum 4098). Each column has a column header that contains a name and a commentary (ASCII text, maximum 32 characters each). There are two types of columns:

• The cells of numeric columns contain only numbers. Numbers may consist of the following characters: 1234567890.e+-. Internally, numeric data is stored at double precision, but every column can be formatted to display numbers at a given decimal precision or as time/date. Numeric columns may also contain date or time. Date is represented in the format dd.mm.yyyy. To indicate that a column contains dates, its commentary is set to "date". Time of day is represented as hh.mm.ss. To indicate that a column contains time of day, its commentary is set to "time". "hours" indicates a column with numbers in hhh.mm.ss format that may grow larger than 24h.
• The cells of text type columns may contain any combination of characters, up to 1024 characters per cell. If any cell in a column contains text, all other cells in that column will be treated as text as well - even if they contain only numeric characters.

Scrollsheets windows...

Wintrack scrollsheets are displayed on screen in scrollsheet windows. If only part of the sheet appears in the window, you can use the scroll bars or the arrow keys to scroll. To ease orientation, column headers are not scrolled vertically, but always displayed near the top of the window. Scrollable data appears in framed cells on alternate white and yellow colored lines. One or more fixed columns, for instance those holding case names or group codes, may be constantly displayed without cell frames near the left edge of the window without being scrolled horizontally with the rest of the window contents. If there is empty space in a scrollsheet window because it is too large for the data it displays, double-click anywhere in the window and it will shrink to fit the displayed data.

Commands to manipulate scrollsheet data...

The Open Scrollsheet command opens scrollsheet files and imports files from MS Excel™ compatible text format. Data copied to the Windows™ clipboard by other applications can be imported into a new scrollsheet using the New Scrollsheet command. Saving data to scrollsheet files and export to MS Excel™ compatible text format is handled by the Save Scrollsheet As command. This command is also used to copy scrollsheets to the Windows™ clipboard for transfer to other applications.

Additional information...

• For an overview of Wintrack documents and files see Wintrack documents and files.