Read more

LibreOffice Calc: How to paste cells without overwriting other cells

Henning Koch
April 18, 2012Software engineer at makandra GmbH

The default behavior of Calc is that when you paste cells from the clipboard, it overwrites whatever cells occupy the same space on the spreadsheet. If you would like to insert the cells in the clipboard instead by pushing the existing cells to the bottom or the right, you can do it like this:

  • Go to Edit / Paste Special
  • The paste dialog has a segment Shift Cells. Choose Down or Right depending on what you want to do.
Illustration book lover

Growing Rails Applications in Practice

Check out our e-book. Learn to structure large Ruby on Rails codebases with the tools you already know and love.

  • Introduce design conventions for controllers and user-facing models
  • Create a system for growth
  • Build applications to last
Read more Show archive.org snapshot
Posted by Henning Koch to makandra dev (2012-04-18 16:18)