In This Topic
Click on a function name for an explanation of that function. You can also view the
Full Index with descriptions, or a
Sorted Index.
Functions which interact with the user or have a visible effect
Functions for accessing and re-ordering the elements in a set
Functions for reading, writing and executing external files
Functions for manipulating simple text-based spreadsheets
Functions that deal with purely numerical data
Functions which do not strictly fall into other categories
Functions used for formatting, converting, and searching within text strings
Functions for testing the types of variables, and assigning values to them
Functions that deal with accessing Microsoft Access Databases (mdb).
These functions are ones that do something on the user's system or run some kind of command. They are called "Action Only" because they can only be placed in the "Action" field of a Friendly Page control. This allows you to execute them when the user clicks a button, edits a text box or selects something from a list, but they can't be used in a normal formula edit box.
The reason for this is that formulas are evaluated on demand, at any time, such as when a drawing is exported. If these action-only functions were in normal formulas they would be run at arbitrary times which could lead to unwanted consequences.