DataLoad Window
Menu Functions
Using Spreadsheets
DataLoad Options
Importing Data
Data Validation
Sorting Data
Protecting Loads

User Guide Home
DataLoad Home

Spreadsheet Formatting

DataLoad provides a number of options for formatting its spreadsheets and using these helps to make loads more readable and self documenting. These options are discussed below.

Column Titles

DataLoad's spreadsheets' columns can have titles that assist the user by indicating what each column should contain. When DataLoad opens a Forms Playback file it attempts to identify the correct name for each column and these are inserted in the spreadsheet's title row. For all other loads the title bar is initially blank and titles can be set by the user. With Macro loads DataLoad will assist with this and if a column doesn't have a title then one is automatically inserted when data, keystrokes or a command is entered in the first row of that column.

Titles not only provide a useful reference but also enable DataLoad to automatically insert Macro commands into the spreadsheets. As a user tabs through the spreadsheet in a Macro load, columns that have a command for a title will have that command inserted into the cell, thus saving typing effort. This facility is only of use if the spreadsheet is structured such that each row is identical. This functionality is optional and may be disabled using the Options form from the Tools menu.

Whatever type of load is being used the title row can be edited so the column names are changed to something more appropriate. The title bar is edited through the column setup window and this may be opened by selecting Column Titles & Setup from the Edit menu, by clicking the right mouse button and selecting the "Titles" entry from the pop-up menu, or by double clicking on the title row itself. This window is used to set the titles to headings that are more meaningful than the default value.

DataLoad can be set to automatically size columns to fit the titles. This functionality is enabled on the Options form and when enabled the column width is automatically adjusted to just fit the column title. This ensures the title is always readable and that the column is to too narrow for the title text.

Default Cell Colours

The background colour of cells can be set automatically in Macro loads. This not only makes it look more attractive but is very useful in distinguishing between cell types. Default colours can be set for data, command and keystroke cells and cells are painted that colour as soon as DataLoad identifies what the cell contains. By default all cells are white, but by using the Options form, which is accessed via the Tools menu or by using it's toolbar icon, default colours for spreadsheet cells can be chosen.