Faq/Writer/170

How to copy and paste a formula without the result
We want to copy a formula in a table to paste it to another cell or another table. For this, you have to select the cell and not its content before copying it.

In the example below, we want to copy and paste the formula in Table1:A3 to Table2:B3:

Process
 * 1) Select the cell Table1:A3.
 * 2) * The easiest way is to click in the cell, then drag the mouse (using  would select the content and not the cell).
 * 3) * Using the keyboard, place the cursor in the cell and press ' Then '.
 * 4) Copy
 * 5) Click Table2:B3
 * 6) Paste

The formula is pasted and the references adapted.

If you want to retrieve the formula but not to adapt the references, you can:
 * 1) Press  in the cell that contains the formula
 * 2) Select the formula in the dislayed input area
 * 3) Copy
 * 4) Press  to leave the input area
 * 5) Select the target cell
 * 6) Press  to display the input area and paste.