Ask Your Question

Calc spreadsheet copy/paste [closed]

asked 2018-12-13 20:55:17 +0200

Petlew gravatar image

updated 2018-12-13 20:57:26 +0200

I have a set of standard spreadsheet blanks to use for various numbers of members in sports club competitions.

If I just highlight, copy/paste the cells and paste them into a new spreadsheet the formatting does not accompany the paste.

How can I copy/paste spreadsheet blanks into a new workbook and retain the original formatting?

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by Petlew
close date 2018-12-14 10:39:49.994999

3 Answers

Sort by » oldest newest most voted

answered 2018-12-14 10:35:26 +0200

Petlew gravatar image

Thank you very much, both methods work well. However I saw johnSun's first, so began using that, I suspect its a slightly longer way round than the templates method, but I don't have that many to move so I'll stick with the early way.

Now for the admission, the sheets were originally setup in MS Excel before I decided to switch to Libra Office. In Excel what I wish to do was much easier, only having to click in the topmost left cell above the rows numbers "copy" and "paste" into the new sheet in a new workbook. Highlighting all used cells and copy/paste got the same result as with OO, pasted without formatting. This only worked with all formatting in place using the top left cell (which is usually blank).

But I'm very pleased it can be done in OO, in two ways, so thank you again.

edit flag offensive delete link more


You can of course do the same in LO - click the top left of the sheet left of Col A and above Row 1 to select the entire sheet, then copy and paste to a new spreadsheet or tab with formatting. Just tried both in LO successfully. Lots of ways to skin this particular feline.

robleyd gravatar imagerobleyd ( 2018-12-14 12:21:45 +0200 )edit

As a matter of fact I found it didn't work. The first part did to the "copy" but after that I only got "paste only" with three greyed out options, "paste" on its own was not offered.

I am trying to copy to a new workbook, not into the same one I am copying from, is that a difference?

Petlew gravatar imagePetlew ( 2018-12-14 14:56:56 +0200 )edit

As I say above, I did both, copy to new tab in same sheet and new tab in new spreadsheet with success; I used Ctr-C and Ctrl-V. I just tried again using the relevant icons and the Edit menu tools, both worked. Note if you accidentally select all on the target sheet, all Paste options will be greyed out. Make sure your cursor is in A1.

robleyd gravatar imagerobleyd ( 2018-12-15 00:06:06 +0200 )edit

answered 2018-12-14 07:48:04 +0200

robleyd gravatar image

updated 2018-12-14 07:49:18 +0200

What I understand you are trying to do is what templates are designed for.

Save the 'standard blanks' as templates, then open new empty documents based on the templates. More information in the Getting Started Guide

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more

answered 2018-12-13 21:56:19 +0200

JohnSUN gravatar image

Try to copy not range, try to copy whole sheet

image description

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-12-13 20:55:17 +0200

Seen: 66 times

Last updated: Dec 14 '18