Besides adding and removing columns, the Recipe Builder lets you customize the spreadsheet by restricting input into specific columns and by changing a column heading. For example, if you want operators to change only override values, make the other columns in the Recipe Operations window non-modifiable.
You can modify columns attributes using the Column Details dialog box. This dialog box displays the Column Heading field and the Modifiable check box.
Column Heading Field
The Column Heading field enables you to enter the heading you want for the selected column. The field contains the current heading of the selected column. You can enter up to 39 characters into field.
Modifiable Check Box
The Modifiable check box controls whether values in the selected column are modifiable. When the box is selected, the column is modifiable. When the box is cleared, the column is not modifiable.
Follow the instructions in the following table to use the Column Details dialog box.
To display the Column Details dialog
box:
- On the Window menu, click Edit Display Format The Window Display Format dialog box appears.
- From the Column Layout list box, select the column you want to modify.
- Select the Modify button, or in the Column Layout list box, double-click the column. The Column Details dialog box appears.
When you finish using the Column Details dialog box you can apply the changes you have made.
To apply column changes:
- From the Column Details dialog box, click OK. The Recipe Builder updates the Column Layout list box to reflect the changes you made.
- From the Window Display Format dialog box, click OK. The Recipe Builder updates the spreadsheet for the selected column.
