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

Problem solved, I am constantly amazed at how easy a problem is solved
with just a little nudge in the right direction!

Thanks to you all! And, thanks to all who administer and maintain the
mailing list!

BB


On 03/03/2018 10:03 AM, Michael D. Setzer II wrote:
> If you put a $ in front of the column and/or Row, it will have the copies remain 
> unchanged. (Can also be with sheet name linking to that).
>
> Would have to see the good and bad versions of formulas to see how it 
> would be changed. 
>
>
>
>
>
> On 3 Mar 2018 at 9:51, Art wrote:
>
> Subject:              Re: [libreoffice-users] LO calc, how to copy partial 
> sheet onto a new
>       sheet
> To:                   users@global.libreoffice.org
> From:                 Art <ky1k@myfairpoint.net>
> Date sent:            Sat, 3 Mar 2018 09:51:20 -0500
>
> > 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 data to log new quantities of data for each of the new days.
> >
> > And, no matter how I copy it, the formulas are not copied properly. I
> > can see the corrupted formulas after the copy operation. And, I can edit
> > each cell to make it right, but it's far to much effort/time to edit all
> > the formulas in each of the columns. I want 365 days worth of data, each
> > day has 8 entries, so I would have to edit almost 3000 (365*8)
> > individual formulas.
> >
> > I think Michael might be on the right track and has given me some input
> > regarding what to search the help file for. Some of the data should
> > indeed NOT be changed, while some of it should!!! I had no idea that
> > absolute or partial absolute address existed! It's a diet spreadsheet,
> > so 7 columns have to refer back to the columns that need to retrieve the
> > raw data on calories, carbs etc. And that data does not change. Let me
> > try to decipher the help file, although many times it doesn't help much
> > because I don't understand so many of the terms it refers to-so I get
> > lost easily. Somewhat of a spreadsheet newbie.



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