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: [email protected] > From: Art <[email protected]> > 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: [email protected] 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
