fudmer, The copy and paste results you experienced are likely due to the formula "anchoring" feature which can be set under "Sheet > Relative/Absolute References" or pressing the F4 key. Try "un-anchoring" or setting cells to "Relative References" (no "$" in the formulas) before copy & paste.
Absolute references ($'s) can be set for the row, column and /or sheet in a formula. This impacts the results of copy and paste within a sheet, between sheets and between files / workbooks. This feature can be quite useful but is a bit hard to explain so search the LibreOffice help for "relative addresses" for more information and do some tests to see how it works. On Fri, Dec 9, 2016 at 12:39 PM, Paolo Debortoli <[email protected]> wrote: > It doesn't happen to me in LibreOffice 5.2.3.3. may be you can > right-click destination and choose 'paste special', then choose from the > menu. Hope this help. Paolo > > > > > > On Friday, December 9, 2016 2:33 PM, Tanstaafl <[email protected]> > wrote: > On 12/9/2016 12:13 AM, fudmer rieley <[email protected]> wrote: > > so on sheet one you do a bunch of calculations > > and decide to copy that part of your work to the next sheet sheet 2 > > then you look at the stuff in the cells on sheet two and they are > > referenced back to the sheet 1. making working on sheet 2 > > slow, difficult and rendering calc nearly inoperative and virtually > useless.. > > > > LO 3.5.7.2 does not do that.. and it should not be done that way > > the sheets should be able to be copied and made independent of > > each other. Is there some way to do that? > > You'll need to explain your problem better. Can you provide a concrete > example? > > -- > To unsubscribe e-mail to: [email protected] > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- > unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > > -- > To unsubscribe e-mail to: [email protected] > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- > unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
