Ask Your Question
0

copy small array (2x20, text, numbers and formulae) does not paste to new spreadsheet [closed]

asked 2012-11-01 16:19:23 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I want to copy some headings to a new, different spreadsheet (not to another sheet in the same spreadsheet, which is no problem). It is a 2x20 matrix, with cells holding names, numbers and formulae (which basically sum some of the numbers in the matrix).

Nothing happens, whether I use Copy and Paste right clicks on the mouse, or CTRL-C and CTRL-V, simple paste or paste special with All ticked

What am I doing wrong please ?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 22:55:01.938905

Comments

which OS and which LibO version are you using? what is for format of your source matrix? (xls, xlsx, ods....)

ROSt52 gravatar imageROSt52 ( 2012-11-02 03:54:42 +0100 )edit

LibreOffice 3.5.6.2, running on W7 Ultimate, and using ods to a freshly opened ods. My point is that the 2 rows of column headings will paste into a new sheet in the same spreadsheet, but will not paste into a new spreadsheet. I had not thought of Move/Copy Sheet, and might give it a try.

old_gobbo gravatar imageold_gobbo ( 2012-11-02 23:59:15 +0100 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2012-11-02 00:33:06 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Either create a new, empty spreadsheet first and copy/paste into it. Or to copy a whole sheet to a new spreadsheet, right-click on the sheet name tab and choose Move/Copy Sheet; select Action Copy, select Location To document -New Document, click OK.

edit flag offensive delete link more
0

answered 2012-11-08 09:35:36 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Thanks, w_whalley: this seems a mite cumbersome (have to delete rest of sheet) ~BUT IT WORKS.

Thank you very much. And for my next question, how the ... do you search this site to find a subject - or to find your own question if you were stupid enough not to click email the updates ?

edit flag offensive delete link more

Comments

Go to your profile (click on your tag name) to see a list of your questions and answers.

w_whalley gravatar imagew_whalley ( 2012-11-08 15:25:12 +0100 )edit

Question Tools

Stats

Asked: 2012-11-01 16:19:23 +0100

Seen: 449 times

Last updated: Nov 08 '12