Apache OpenOffice Community Forum

How do I replace a formula in a cell with the value the formula computed? I do not want someone else to be able to see how a value was arrived at.

Click on the cell.
Press F2, then F9, then Enter.

For a group of cells, you have to copy the cells to the clipboard, then use Edit > Paste Special, and unselect "All" then unselect "Formulas". Make sure "Values" is still checked, then OK.

Edit: PS:

An easier way to achieve a read-only product is to export your sheet as a PDF and send that out.

Thanks, I finally got it.