libreoffice paste only numbers not formula

While working with libreoffice spread sheets, we often use formulas to update various fields. For example we might have a column having the marks scored by students of a class in various subjects as shown below.

 photo average_sheet.png

We can use the formula average to find the average marks scored by the class as shown below.

 photo average_formula.png

Now if we want to copy the averages from this sheet to another sheet a simple copy paste will not work. A simple copy paste will result in the pasted value being as below.

 photo normal_paste.png

This is because when we do a simple copy paste we care copying the fomula not the value that has bee derived from the formula. To paste the value alone, ignoring the actual formula, in the new sheet click on Eidt-> paste special

 photo edit_paste_special.png

A menu as shown below will be displayed.

 photo paste_special_menu.png

From this menu select what ever that needs to be pasted.Uncheck the paste all option and select that we need to paste numbers and text and remove the check next to the fomula option. Now click Ok and we will see that only the numbers of the average value will get pasted as shown below.

 photo only_numbers_pasted.png

No comments:

Post a Comment

Follow by Email