Once a column has been added to the template definition, only limited information can be edited, regardless of whether the template has been saved. However, it is possible to edit formulae, as shown in the following table.
NOTE: Formulae of an imported template cannot be edited. To view/edit column properties, either double-click the Column Name, or click the Column Name, then click the Openbutton to display the Column Detailsdialog.
For all columns, the Column Headingcan be amended as required.
For Data Review columns it is possible to change the date range together with which result should be shown (i.e. Recent, Highest, Lowest or Mean). In addition, you can hide the column by selecting the Hiddencheck box. This would normally be required if this column was being used in a calculation and you did not want the column to be displayed in the marksheet.
NOTE: Hidden columns are not exported to Excel.
For all formula columns, you can view the structure of the formula by clicking the Viewbutton, which opens the Formula Detaildialog.
For Data Entry Formula columns, you can change the read-only status by selecting or deselecting the Read-onlycheck box. Your choice will depend on whether you wish to allow users to overtype a calculated result.