OPTIONS.TRANSITION

Macro Sheets Only

Equivalent to choosing the Options command from the Tools menu and then selecting 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

List of Command-Equivalent Functions