Re: [libreoffice-users] i of the most disturbing things about 5.0 libreoffice

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 <paolo_debortoli@yahoo.com>
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 <tanstaafl@libertytrek.org>
> wrote:
> On 12/9/2016 12:13 AM, fudmer rieley <southofmexico@yahoo.com> 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: users+unsubscribe@global.libreoffice.org
> 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: users+unsubscribe@global.libreoffice.org
> 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: users+unsubscribe@global.libreoffice.org
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