You can define a spreadsheet layout by selecting the:
- Columns you want to display.
- Order these columns appear in the spreadsheet.
- Column headings.
- Columns' width.
The columns you can select correspond to common and block-specific fields. Columns corresponding to common block fields appear with only the field name. For example, the following text appears for the common field Current Value:
Curr Value
Columns corresponding to block-specific fields use the following naming convention:
typefieldname
The type is a two or three-character abbreviation for the block type and the fieldname is the name of the block field. For example, suppose you see the following text:
AI Smooth
AI is the block abbreviation and identifies the field as an Analog Input specific field. The text Smooth indicates the field name and corresponds to a block field (in this case the A_SMOTH field). The Block Type Abbreviations table lists the abbreviations for each block.
NOTE: If you remove a column from the spreadsheet that Database Manager uses to sort data, the column is also removed from the sort order.
