Enabling template validation
In order to use template validation, you must design your template sheets so that rows 1-2 are reserved for system-generated codes. These codes are used by Axiom to perform functions such as tracking sheet structure.
If row 1 is blank the first time that you create or insert a calc method in a template sheet, Axiom will place system-generated codes in row 1. The codes span the used area of the sheet, or through column AD, whichever is greater. Template validation is now enabled for that sheet of the template.
If you are using template validation, then you should not manually place any content in the reserved rows or modify any existing contents. If Row 1 contains content other than system-generated codes, then template validation is not applied and no validation features will be available.
NOTES:
- Currently, only row 1 is being actively used by Axiom for template validation purposes. Row 2 is reserved for future validation features. We recommend reserving both rows in your templates so that you can immediately take advantage of any future validation features, without needing to restructure your templates.
- Template validation controls are optional, but we strongly recommend that you use them, to help ensure the integrity of your data, and to provide enhanced features for template and calc method management.
Validation will apply to any sheet in the template that has an associated calc method library and uses the reserved rows. If a particular sheet in a template does not need to be validated, then you can place content in row one of that sheet, and then validation will not apply to that sheet.
Example validation codes in a template
Formatting reserved rows
In the majority of cases, rows 1-2 will not be visible to end users in plan files, due to freeze panes settings. If desired, you can also hide the rows in the template using standard spreadsheet functionality, to help prevent administrators from accidentally editing these rows.
The system-generated codes placed in these rows may be lengthy. Therefore, you may want to change the font size for these cells to 1pt, so that the cell contents do not impact any column auto-fit settings in the template.
