Date: prev next · Thread: first prev next last
2018 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.