Copying just text, not formulas, in OpenOffice Calc
How do I copy and paste the text (not the formulas) from one Calc sheet to another in OpenOffice?
- Select the cells you want to copy, and use Ctrl-C to copy them.
- Select the cell where you want to copy the cells.
- Open the Edit->Paste Special menu.
- In the Selection section, ensure that the Paste All and Formulas options are not selected. Select all other options in that section.
- Click OK, and the cells will be copied without the formulas.
Didn't work for me but found that if I copied the result from a simple =EXACT etc formula, ie results were either TRUE or FALSE, and pasted it to Notepad, the results appeared as text and I could copy and paste them back to the worksheet.