From The Document Foundation Wiki
Jump to navigation Jump to search

If you want to retrieve the formula but not to adapt the references, you can:

  1. Press F2 in the cell that contains the formula
  2. Select the formula in the dislayed input area
  3. Copy
  4. Press Esc to leave the input area
  5. Select the target cell
  6. Press F2 to display the input area and paste.