Re: [libreoffice-users] SOLVED: ODS question

Fred James 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

There is a quicker way, particularly if you want to copy several sheets...
1) Open both files
2) Go to file to copy from
3) Select the sheet (to copy more than one at the same time, hold Ctrl 
while clicking each sheet's tab - selected ones change colour, from grey 
to white for me but that probably varies between systems)
4) Right click on one of the selected tabs and choose "Move/Copy Sheet"
5) Select "Copy" action, required file to copy to, and where to place 
the copies in that file relative to any existing sheets
6) Click OK and you're done.

If you really want to copy them one at a time for some reason, you can 
just repeat those steps, selecting a different sheet each time at step 3.

Mark.


--
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