Code Yarns ‍👨‍💻
Tech BlogPersonal Blog

LibreOffice Calc: Copy and paste results of formulas

📅 2012-Sep-11 ⬩ ✍️ Ashwin Nanjappa ⬩ 🏷️ copy, formula, libreoffice, libreoffice calc, paste ⬩ 📚 Archive

Paste Special to 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