Copying just text, not formulas, in OpenOffice Calc
- 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.