LibreOffice Calc: Reset positions of split dividers

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 ...

• You can define what will be printed by checking View -> Preview Page Breaks and then moving around the blue borders.
• You can now define the size of the printed content under Format -> Page -> Sheet -> Scale. You can choose between three sc...

Getting rid of your old LibreOffice

Remove your old LibreOffice:

sudo apt-get remove libreoffice*

You probably also want to get rid of the dead PPAs you might have installed for LibreOffice 4.x:

• Op...

If you paste multiple lines of text into a cell, Calc's AutoCorrect will change the first character of the last line to uppercase:

foo  =>  foo
bar      bar
baz      Baz

To fix this, go to Tools / AutoCorrect Options, choose the *O...

If you're a frequent user of LibreOffice, I strongly recommend to checkout out the VLOOKUP function (SVERWEIS in German). It allows you to treat a column pair as a hash map, where ...

Ruby's String#split returns an array of substrings from the given string. Usually, this is missing the split characters:

>> 'user@example.com'.split('@')
=> ["user", "example.com"]

If you want to join those parts later on, you migh...

Copy data from LibreOffice Calc

When you copy data from multi-line cells in LibreOffice Calc, quotation marks are automatically added, which you may not want.

For example with license keys:

09:46:24 [...

Upgade to LibreOffice 3.5.3+ or disable hardware accelleration in Tools → Options → LibreOffice → View → Graphic output.