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

I did the complete duplicate on a new sheet and my data in the formulas
in the new sheet are corrupted.

I then stripped down the spreadsheet to make less sheets, and far less
columns and rows.

And, now, I can't even copy columns from one place to another, ON THE
SAME SHEET without corrupting the formulas. Each days worth of data is 8
columns, and I want to take the existing 1 day of data and make it into
365 days worth of data. So, that's far to much editing of the formulas
to be useful.

I will send my shortened/abbreviated spreadsheet to anyone who asks via
direct email, with some notes on the sheet.

I'm totally lost.

BB


On 03/02/2018 04: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



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