Re: [libreoffice-users] LO calc, how to copy partial sheet onto a new sheet

On 03/02/2018 01:26 PM, Brian Barker wrote:
> At 16:03 02/03/2018 -0500, Bonly "Art" Bonly wrote:
> > I've developed a spreadsheet to manage my diet. I foolishly put 
> > several groups of columns that belong on a separate page onto sheet 
> > 1.....complete with formulas, proper formatting etc. How do I move 
> > the groups of columns and rows (with formulas and formatting info) 
> > onto a new sheet? I can do it using the Paste Special command, but 
> > the formulas come out all wrong, and would require a massive amount 
> > of re-edits to produce usable results, most of the problems are the 
> > formulas.
>
> It's difficult to know without being aware of all details, but here 
> are some ideas:
>
> o Copy and paste using Paste Special, as you suggest, but tick the 
> Link option in the Paste Special dialogue. That way, the new sheet 
> will refer back to values in the original.
>
> o Make a complete copy of the original sheet: right-click the sheet 
> tab and select Move/Copy Sheet... . Delete material from both sheets 
> as required.
>
> o Use a careful combination of the above schemes.
>
> If your spreadsheet is sensibly designed, correcting any formulae 
> should generally require attention only to one instance and the use of 
> the Fill function.
>
> I trust this helps.
>
> Brian Barker
Greetings,
Optionally for bullet #2, I find it easy to click on the upper left 
block where the row and column IDs converge (left of "A" and above "1"). 
This selects the entire sheet. I then use Ctrl+c to copy everything, 
then go to the blank sheet, click on the upper left block on that sheet 
to select it and use Ctrl-v to insert the data and formatting. Note that 
I found that this does not copy the Print Range settings.
HTH.
Girvin Herr


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