OpenOffice Spreadsheet - Drag&Drop

2009-04-12 21:35:17

  1. Drag highlighted cells (not columns nor rows).
  2. Drop pastes over the target cells.
  3. Ctrl+Drop copies over the target cells.
  4. Ctrl+Shift+Drop creates linkes over the target cells.
  5. Alt+Drop inserts new target cells removing the source cells.
  6. Ctrl+Alt+Drop inserts new target cells copying the source cells.
  7. Ctrl+Shift+Alt+Drop inserts new target cells, linked to the source cells.

From OO.org Forums. Need to remember this.