How to copy, paste formulas in OpenOffice Spreadsheet?
To copy and paste the formula from one cell to another, follow the below steps.
Step 1: Select and copy the cell that contains the formula.
Step 2: Paste it in the cell where you want to use the formula.
Step 3: The cell reference will change when you copy, paste the formula.
Example:If you copy the sum formula =SUM(B2:B6) and paste it in other cell, then it will change as =SUM(C2:C6)