Copy value in Open Office Calc

6

1

I have a handful of cells in several spreadsheets that contain =AVERAGE(<some range>) and when I try to copy them into another spreadsheet I just copy the function and get #REF!.

Is there any way to copy values? If it matters I'm using csv files.

Jarl Haggerty

Posted 2011-05-23T21:35:41.527

Reputation: 163

Answers

5

Copy them, then Right click -> Paste special, tick "Numbers" and hit enter.

John Lyon

Posted 2011-05-23T21:35:41.527

Reputation: 288

1Also my favourite way of Paste Special is Shift+Ctrl+v - very handy and quick/ – r0berts – 2013-12-12T16:41:20.120

Asked: 2011-05-23T21:35:41.527

Viewed: 2 722 times

Active: 2013-12-12T16:37:17.043