OpenOffice spreadsheets

[CTho9305]

We have 1.1 and 1.03 at work... is there a way to copy values (like Paste Special, Values in Excel)? I looked at the Paste Special options, but saw nothing that was relevant.

 

[Armitage]

<ctrl>-c to copy the cell, the right-click on the cell you want to copy it into. This brings up the "paste special" dialog

Uncheck "paste all", then check numbers and uncheck formulas

 

[CTho9305]

When I tried that, it ignored cells that had formulas in the source cell. I'll look again monday. Your solution worked on my home machine, so maybe I was doing something else wrong at work.