Calc/Cell Edition Modes

The Modes

Selection Mode

Default mode. Subtleties: "Formula Bar" may be hidden, and input line removed ; "Formula View" mode; Array formula.

Reference Input Mode

Entered upon: In Selection Mode, entering text beginning with an "=", "+" or "-".

References can then be selected with the keyboard (arrow keys and navigation keys) and mouse, and referenced cells get a colored background matching the color of the reference in the formula (in cell but not formula bar.)

Leaving the mode on:

• Enter or Tab keys (validating the entry, back to Selection Mode)
• Escape key (canceling, back to Selection Mode)
• Click in the formula (in cell or in input line of the formula bar.) Entering Standard Edit Mode (with a bug because some referenced cells keep the colored border)

See Also

• Specifications:
  • Transparent selection.
  • Show Formula Syntax in tip help.
  • Enhanced Data Input.
  • Enhanced Formula Input.
• User Documentation:
  • Documentation/OOo3_User_Guides/Getting_Started/Navigating_within_spreadsheets
  • Documentation/OOo3_User_Guides/Getting_Started/Selecting_items_in_a_spreadsheet
  • Documentation/OOo3_User_Guides/Getting_Started/Entering_data_using_the_keyboard
  • Documentation/OOo3_User_Guides/Getting_Started/Editing_data
• Issues
  • http://www.openoffice.org/issues/show_bug.cgi?id=73766
  • http://www.openoffice.org/issues/show_bug.cgi?id=85984
  • http://www.openoffice.org/issues/show_bug.cgi?id=10305