LibreOffice Calc: Copy and paste results of formulas

Paste Special to paste results of formulas

Problem

LibreOffice Calc is the spreadsheet application in the LibreOffice suite. In LibreOffice Calc, if the cells of a spreadsheet hold the results of formulas, then those results cannot be copied and pasted to a different cell. This is because the formula is copied instead of the result.

Solution

To copy the results of the formulas instead of the formulas themselves, do this:

  1. Copy the cells as usual.
  2. Right-click at the cell where you want to paste the results and choose Paste Special.
  3. In the Paste Special dialog, under the Selection section, uncheck all the different types of selection. Check only Numbers (assuming that the results are numbers). Choose OK.

The results of formulas should be pasted now instead of the formulas. This trick can also be used to do in-place replacement of cells with formulas with their results.

Tried with: LibreOffice 3.6.0.4

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.