Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 08 Nov 2012 15:25:12 +0100copy small array (2x20, text, numbers and formulae) does not paste to new spreadsheethttps://ask.libreoffice.org/en/question/7368/copy-small-array-2x20-text-numbers-and-formulae-does-not-paste-to-new-spreadsheet/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 ?
Thu, 01 Nov 2012 16:19:23 +0100https://ask.libreoffice.org/en/question/7368/copy-small-array-2x20-text-numbers-and-formulae-does-not-paste-to-new-spreadsheet/Comment by old_gobbo for <p>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).</p>
<p>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</p>
<p>What am I doing wrong please ?</p>
https://ask.libreoffice.org/en/question/7368/copy-small-array-2x20-text-numbers-and-formulae-does-not-paste-to-new-spreadsheet/?comment=7436#post-id-7436LibreOffice 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.Fri, 02 Nov 2012 23:59:15 +0100https://ask.libreoffice.org/en/question/7368/copy-small-array-2x20-text-numbers-and-formulae-does-not-paste-to-new-spreadsheet/?comment=7436#post-id-7436Comment by ROSt52 for <p>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).</p>
<p>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</p>
<p>What am I doing wrong please ?</p>
https://ask.libreoffice.org/en/question/7368/copy-small-array-2x20-text-numbers-and-formulae-does-not-paste-to-new-spreadsheet/?comment=7390#post-id-7390which OS and which LibO version are you using?
what is for format of your source matrix? (xls, xlsx, ods....)Fri, 02 Nov 2012 03:54:42 +0100https://ask.libreoffice.org/en/question/7368/copy-small-array-2x20-text-numbers-and-formulae-does-not-paste-to-new-spreadsheet/?comment=7390#post-id-7390Answer by old_gobbo for <p>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).</p>
<p>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</p>
<p>What am I doing wrong please ?</p>
https://ask.libreoffice.org/en/question/7368/copy-small-array-2x20-text-numbers-and-formulae-does-not-paste-to-new-spreadsheet/?answer=7592#post-id-7592Thanks, 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 ?
Thu, 08 Nov 2012 09:35:36 +0100https://ask.libreoffice.org/en/question/7368/copy-small-array-2x20-text-numbers-and-formulae-does-not-paste-to-new-spreadsheet/?answer=7592#post-id-7592Comment by w_whalley for <p>Thanks, w_whalley: this seems a mite cumbersome (have to delete rest of sheet) ~BUT IT WORKS.</p>
<p>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 ?</p>
https://ask.libreoffice.org/en/question/7368/copy-small-array-2x20-text-numbers-and-formulae-does-not-paste-to-new-spreadsheet/?comment=7600#post-id-7600Go to your profile (click on your tag name) to see a list of your questions and answers.Thu, 08 Nov 2012 15:25:12 +0100https://ask.libreoffice.org/en/question/7368/copy-small-array-2x20-text-numbers-and-formulae-does-not-paste-to-new-spreadsheet/?comment=7600#post-id-7600Answer by w_whalley for <p>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).</p>
<p>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</p>
<p>What am I doing wrong please ?</p>
https://ask.libreoffice.org/en/question/7368/copy-small-array-2x20-text-numbers-and-formulae-does-not-paste-to-new-spreadsheet/?answer=7387#post-id-7387Either 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.
Fri, 02 Nov 2012 00:33:06 +0100https://ask.libreoffice.org/en/question/7368/copy-small-array-2x20-text-numbers-and-formulae-does-not-paste-to-new-spreadsheet/?answer=7387#post-id-7387