AX2294

Setting up action code processing for Axiom files

You can use action codes to automatically perform certain actions in a sheet when the sheet is updated with data. These codes can be used to lock and unlock cells, and to copy cell contents from one location to another.

In general, action codes are processed after Axiom queries are run, and after calc methods are inserted or changed in a sheet. Some additional processing options are also available using special commands.

Action code processing depends on the placement of reserved action tags in the sheet. There are two components:

• The ActionCodes tag, which defines a control column and a control row for the action code processing.
• Matching action tags to specify "action cells" for processing. Each intersection of matching action tags in the control column and the control row specifies an action cell for processing. The paired tags specify the action to perform.

You can have lock, unlock, and copy pairs within the same action control row and control column. You can also combine lock, unlock, and copy tags, by delimiting the tags with a comma.

Action code processing is a flexible feature that can be set up in a variety of ways. See the detailed topics in this section for more details on setting up each type of operation.

NOTE: Action code processing can be resource-intensive. When designing action codes in a file, care should be taken to minimize the performance impact of this process. The number of actions and the frequency of their processing should be limited to only processing when absolutely necessary.