How do I copy and paste only the results of a calculation without copying the formula behind it? I'm learning to use Open Office Calc. I remember other spreadsheets that had a values function, or simply a menu choice to paste values instead of the formulas, but this idea seems to be missing from Open Office, or called by some other name. Thanks for any help.
Take the 2minute tour
×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
Use In the dialog uncheck paste all, check numbers and uncheck formulas. This is in every version of OO/LO, that I've used. 

