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.
>
> BB
>
>
>
> On 03/02/2018 11:05 PM, Brian Barker wrote:
> > 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 Barker
> >
>
>
>
> --
> 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
+------------------------------------------------------------+
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:[email protected]
mailto:[email protected]
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+
http://setiathome.berkeley.edu (Original)
Number of Seti Units Returned: 19,471
Processing time: 32 years, 290 days, 12 hours, 58 minutes
(Total Hours: 287,489)
BOINC@HOME CREDITS
ABC 16613838.513356 | EINSTEIN 140857745.999240
ROSETTA 64915897.511531 | SETI 109315939.406767
--
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
