AX2723

Change View command

Use the Change View command to apply a view to a sheet. The command can be configured to apply a specific view, or to present a list of views for the user to select.

Can be used in

Ribbon tabs
Task panes

This command is included in the default AxiomMain.AXL ribbon tab, as part of the File Options group.

When the Change View command is selected from the Command Library as the shortcut target, it displays as command://SelectView or command://SelectViewCommandAdapter (legacy syntax).

Shortcut parameters

If you want to present a list of all available views for the current sheet, then leave the shortcut parameters blank. This list will display as an expandable/collapsible list in task panes and as a drop-down list in ribbon tabs (just like the Change View button on the default Axiom tab). The list of views will dynamically update as the user changes from sheet to sheet.

If instead you want to apply a specific view, then complete the following shortcut parameters:

Item	Description
Target Sheet	The sheet in which to apply the view. You can optionally leave this blank if the same view name is used on multiple sheets. For example, if multiple sheets have a view named Summary, then you can complete only the View Name and the button can be used to apply the view to any of those sheets.
View Name	The view name(s) to apply. Valid entries depend on the type of view to apply: For sheet views, you can enter a single sheet view name. For column views, you can enter one or more column view names, separated by commas. All column view names in the list must be from the same "set" of column views (same ColumnView control row). For row views, you can enter one or more row view names, separated by commas. All row view names in the list must be from the same "set" of row views (same RowView control column). If the specified view name is not found in the specified sheet (or in the current sheet if no Target Sheet is defined), then an error message informs the user that the view was not found. NOTE: In order to use this feature, all view names in the sheet must be unique. Axiom Software will apply the first view that is found with the specified name. For example, if you specify the view name "Default," and the sheet contains both a sheet view and a column view named "Default," then it will apply whichever view it finds first in the sheet.

Item

Description

Target Sheet

The sheet in which to apply the view.

You can optionally leave this blank if the same view name is used on multiple sheets. For example, if multiple sheets have a view named Summary, then you can complete only the View Name and the button can be used to apply the view to any of those sheets.

View Name

The view name(s) to apply. Valid entries depend on the type of view to apply:

For sheet views, you can enter a single sheet view name.
For column views, you can enter one or more column view names, separated by commas. All column view names in the list must be from the same "set" of column views (same ColumnView control row).
For row views, you can enter one or more row view names, separated by commas. All row view names in the list must be from the same "set" of row views (same RowView control column).

If the specified view name is not found in the specified sheet (or in the current sheet if no Target Sheet is defined), then an error message informs the user that the view was not found.

NOTE: In order to use this feature, all view names in the sheet must be unique. Axiom Software will apply the first view that is found with the specified name. For example, if you specify the view name "Default," and the sheet contains both a sheet view and a column view named "Default," then it will apply whichever view it finds first in the sheet.

Visibility

Items that use this command are always visible if the file is a spreadsheet file, regardless of whether the file has any defined views. Items that use this command are hidden if the file is not a spreadsheet file.

You can use the Show restricted items option in the task pane or the ribbon tab to force items that use this command to be visible at all times (but grayed out if unavailable).

Remarks

If the command is configured to display a list of all views, the list may or may be organized by sub-headers that indicate view type (Sheet Views, Column Views, Row Views).

Ribbon tabs: Whether or not the list has sub-headers depends on the Show View Headers in Menu option defined on the file's Control Sheet. By default this setting is enabled, which means the list is organized by sub-headers.
Task panes: Sub-headers do not display in task panes, regardless of the Show View Headers in Menu option.