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: [email protected]
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
