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 > Date sent:Sat, 3 Mar 2018 09:51:20 -0500 > >> Hi Brian, Michael

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 Date sent: Sat, 3 Mar 2018 09:51:20 -0500 > Hi Brian, Michael, et al, > > Brian, yes, the procedure you gave

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 d

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 Barke

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 Mo

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 mov

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 formula

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