How do I copy the results of a calculation without copying the formula behind it? Open Office Calc [duplicate]
Solution 1:
Use Edit-->Copy then Edit-->Paste Special (or Copy and Paste Special... from the context (right-click) menu).
In the dialog uncheck paste all, check numbers and uncheck formulas.
This is in every version of OO/LO, that I've used.