AX2304

Enabling double-click drilling

If you want users to be able to drill values in a spreadsheet Axiom file by double-clicking, you must enable double-click drilling for the file. Otherwise, users can initiate drills by using the Drill menu in the File Options group of the Axiom ribbon tab.

To enable double-click drilling for drill down or drill through, you must enable the Axiom Double-Click option for the file.

  • On the Sheet Assistant, this setting is located in the Worksheet Settings section:

  • In the Control Sheet, the setting is located in the Sheet Options section:

To enable double-click drilling for custom drilling, you must enable the option Double-click to drill on the Drilling Control Sheet.

When a user double-clicks a row or cell in the file, drilling options are performed as follows:

  • If custom drilling is defined for the file and Double-click to drill is enabled for it, the custom drill will be performed. Depending on the custom drill configuration, the drill may occur with no further input, or the user may need to select drilling options.
  • Otherwise, if Axiom Double-Click is enabled, then a dialog opens to display the available drill down and drill through options.

NOTE: Axiom supports several different actions that may be initiated by double-clicking. When you double-click on a cell, if multiple double-click actions could apply to this context, then the action performed is evaluated based on priority. For more information, see Double-click behavior.