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

2018-03-03 Thread Brian Barker
At 14:08 03/03/2018 -0500, Bonly "Art" Bonly wrote: Problem solved, ... Good-oh! At 09:51 03/03/2018 -0500, Bonly "Art" Bonly wrote: ... no matter how I copy it, the formulas are not copied properly. I suspect there *is* a way to do this, but no matter ... ... I can edit each cell to make

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

2018-03-03 Thread Art
gt; Subject: Re: [libreoffice-users] LO calc, how to copy partial > sheet onto a new > sheet > To: users@global.libreoffice.org > From: Art <k...@myfairpoint.net> > Date sent:Sat, 3 Mar 2018 09:51:20 -0500 > >

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

2018-03-03 Thread Michael D. Setzer II
: [libreoffice-users] LO calc, how to copy partial sheet onto a new sheet To: users@global.libreoffice.org From: Art <k...@myfairpoint.net> Date sent: Sat, 3 Mar 2018 09:51:20 -0500 > Hi Brian, Michael, et al, >

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

2018-03-03 Thread Art
Hi Brian, Michael, et al, Brian, yes, the procedure you gave works, as stated. But, now I realized that I can't expand the spreadsheet to make additional days by copying the previous day of data. So, I have a few days of data, but need to duplicate those columns so I can have more days worth of

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

2018-03-02 Thread Brian Barker
At 21:45 02/03/2018 -0500, Bonly "Art" Bonly wrote: I did the complete duplicate on a new sheet ... That sounds as if you copied and pasted "on a new sheet". Have you also tried copying the sheet using the technique I described - creating the new sheet in the process - instead? Brian

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

2018-03-02 Thread Brian Barker
At 13:38 02/03/2018 -0800, Girvin Herr wrote: On 03/02/2018 01:26 PM, Brian Barker wrote: o Copy and paste using Paste Special, as you suggest, but tick the > Link option in the Paste Special dialogue. [...] o Make a complete copy of the original sheet: right-click the sheet > tab and select

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

2018-03-02 Thread Art
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

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

2018-03-02 Thread Girvin Herr
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

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

2018-03-02 Thread Brian Barker
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

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

2018-03-02 Thread Art
Hi All, 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