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.
We can use the formula average to find the average marks scored by the class as shown below.
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.
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
A menu as shown below will be displayed.
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.
We can use the formula average to find the average marks scored by the class as shown below.
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.
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
A menu as shown below will be displayed.
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.
No comments:
Post a Comment