Open office

From miki
Jump to navigation Jump to search

Tips

Calc — Remove the delete confirmation box

By default, backspace is mapped to immediate deletion, and delete to open a dialog box with different delete options.

This can be changed in menu ToolsCustomize..., panel Keyboard. (Make sure Calc radio button is selected), pick Category Edit:

  • 1st Function Delete Contents is the one showing dialog box (default Delete)
  • 2nd Function Delete Contents is the one that deletes without confirmation (default Backspace)

Calc — Move rows or columns

See [1]:

  1. Click row/column head
  2. Drag row/column by clicking in the selected area (NOT on header)
  3. Hold ALT to insert where you want it to be

Note that ALT+drag may conflict in Gnome with shortcut to move Windows (see Preferences → Windows → Windows movement).