AX2261
Axiom spreadsheet file setup
Axiom files are enhanced spreadsheets used for reports, templates, plan files, utilities, and driver files. Each spreadsheet Axiom file has a Control Sheet and supports special features, such as:
- Bringing data from the database into Axiom files
- Saving data from Axiom files to the database
- Inserting or changing rows by using calc method libraries (available in file groups only)
- Enhanced navigation and view controls throughout the workbook
- Inherited settings for freezing panes, sheet protection, and other spreadsheet options
The defining characteristic of an Axiom spreadsheet file is a Control Sheet where many of the settings for that file are defined. Other settings are defined in the individual sheets through use of control columns, control rows, and reserved feature tags. This
With a few exceptions, Axiom file features and Control Sheet settings apply to all uses of spreadsheet Axiom files. For example, plan files and report files have the same base functionality. The same features are used to bring data into the file, and to save data to the database. The difference is the context and purpose of the file, not its inherent functionality.
NOTE: Use of calc method libraries is limited to templates/plan files. For information on maintaining calc method libraries and configuring calc method controls, see Calc method libraries.
