Equivalent to clicking the Options command on the Tools menu and then clicking the Transition tab in the Options dialog box. Sets options relating to compatibility with other spreadsheets.
Syntax
OPTIONS.TRANSITION(menu_key, menu_key_action, nav_keys, trans_eval, trans_entry)
OPTIONS.TRANSITION?(menu_key, menu_key_action, nav_keys, trans_eval, trans_entry)
Menu_key is text specifying which alternate menu key to use.
Menu_key_action is the number 1 or 2 specifying options for the alternate menu or Help key. In Microsoft Excel for the Macintosh, menu_key_action is ignored.
| Menu_key_action | Alternate menu or Help key activates |
| 1 or omitted | Microsoft Excel menus |
| 2 | Lotus 1-2-3 Help |
Nav_keys is a logical value that corresponds to the Transition Navigation Keys check box, which if TRUE uses alternate navigation keys that correspond to the navigation keys for Lotus 1-2-3. In Microsoft Excel for the Macintosh, nav_keys is ignored.
Trans_eval is a logical value that corresponds to the Transition Formula Evaluation check box.
If trans_eval is TRUE, Microsoft Excel uses a set of rules compatible with that of Lotus 1-2-3 when calculating formulas. Text is treated as 0. TRUE and FALSE are treated as 1 and 0. Certain characters in database criteria ranges are interpreted the same way Lotus 1-2-3 interprets them.
If trans_eval is FALSE or omitted, Microsoft Excel calculates normally.
Trans_entry is a logical value that corresponds to the Transition Formula Entry check box.
This argument is available only in Microsoft Excel for Windows.
If trans_entry is TRUE, Microsoft Excel accepts formulas entered in
Lotus 1-2-3 style.
If trans_entry is FALSE or omitted, Microsoft Excel only accepts formulas entered in Microsoft Excel style.
Related Functions
OPTIONS.LISTS.DELETE Deletes a custom list
OPTIONS.LISTS.GET Returns contents of custom AutoFill lists
OPTIONS.VIEW Sets various view settings
Return to index