Re: [libreoffice-users] SOLVED: ODS question

Hi :)
There's an even easier way!  Sorry this is probably too late! :(

1.  Open both files but get into the one you want to copy from
2.  Right-click on the tab at the bottom of the work-sheet
3.  Choose "Move or Copy worksheet"
4.  in the dialogue choose "copy" and use the drop-down to select the other
file.

I suspect you can do multiple worksheets/tabs at a time.

Of course another way is to simply copy the entire file and then you have
all the tabs/worksheets in the new file.  Maybe need to add or delete a
couple.
Regards from
Tom :)




On 2 January 2015 at 01:35, Fred James <fredjame@fredjame.cnc.net> wrote:

> OS: Mageia 4, 64bit (if that makes a difference?)
> LibreOffice: 4.1.6.2
>
> I have two separate ODS files:  2014 and 2015
>
> I want to copy a sheet (the entire sheet) from 2014 to 2015.
>
> Is this possible, and if so, what is the recommended method?
>
> Actually, there are a few sheets I want to copy from 2014 to 2015, but one
> at a time.
>
> Thank you
> Regards
> Fred James
>
> Sorry ... silly me ... the answer is too easy ...
>         1) go to file to copy from
>         2) go to the sheet to copy
>         3) Edit -> Select All
>         4) go to file to paste into
>         5) go to (or make) sheet to paste into
>         6) select cell A1
>         7) Edit -> Paste Special
> Bingo!
>
> Thanks
> Regards
> Fred James
>
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted