AX1310

Setting up views for Axiom files

Spreadsheet Axiom files can use multiple types of views that specify which rows and columns in a sheet are hidden or shown. Views can also be used to set row and column sizing.

You might have a single view in a sheet for formatting purposes only, or you might have several different views so that users can switch between different views of the data. For example, you might want users to be able to switch between viewing the data by quarters or by months. Or you might use views to hide optional "detail" rows or columns that users can then expose as needed. The ability to change which rows or columns are shown at any one time can help make complex and detailed spreadsheets easier to read.

You can set default views to apply automatically when the file is opened. Once a file is opened, users can select and apply views by using the Change View menu on the default Axiom ribbon tab (or by using the Change View command in any custom task pane or ribbon tab).

Axiom Software provides three types of views:

• Sheet Views control the overall view of a sheet. They can be used to set row and column sizing, and to flag certain rows and columns as hidden. Only one sheet view can be active at a time.
• Column Views can be used to toggle sets of columns as shown or hidden. Multiple column views can be active at a time.
• Row Views can be used to toggle sets of rows as shown or hidden. Multiple row views can be active at a time.

In general, sheet views are intended for cases where you want to affect the entire sheet and provide a small handful of different viewing options. For example, you might have a Summary sheet view that shows only the high-level data and then a Detail sheet view that exposes the detailed data. Depending on what the user is doing at any one time, they might only need to see the high-level data or they might need to dive into the details. The user can switch between the two views as needed.

Column and row views are intended for cases where you want the user to be able to dynamically toggle certain rows and columns as shown or hidden. This is a similar experience to Excel's AutoFilter feature, where users can view a list of items and select which ones they want to show, in any combination. For example, you could have column views set up to show columns by quarter. The user could choose to show only the columns for Q1, or show both Q1 and Q2, or show all four quarters, or show any combination of quarters.

You can use any combination of sheet views, column views, and row views in a sheet. Column views and row views do not have any area of overlap, but sheet views may overlap with column or row views. If you are using sheet views with column or row views, be sure that you understand how the views will interact, and be sure to test the setup. For more information, see Using multiple view types in a sheet.