thanks for the reply.. When in 16.04 I pushed f4 or attempted data> Relative/absolute References I got 5.1.4.2 no references found.. reply.. nothing else..
copy from one sheet to another sheet in the same and only open my installed Libre office calc spreadsheet session still gives a full cell by cell reference to the cells in the original copied from sheet.. The newly created by copy sheet its almost as it the reference is working in reverse.. When i want something from another sheet i just type =(sheet name, and then I find the cell in the external sheet and click on it and hit return. ON return I examine the formula content of the cell in my working sheet and find it is referenced to the copied from cell in the external sheet.. virtually the copy mechanism for my purposes remains useless. While i like some features of 5.1.4.2, it is not stable and things have been moved around quite a bit. OK, but more documentation is needed on the help keys and i would be glad to help with some of that,, if needed. What I think is needed is standard training program.. not help in this place or that but in a standard place. using a standard spreadsheet populated with a standardized set of data. Every cell is has the standard known content; that would allow all help and training to be done by example.. as the frustrated learners become familiar with the standard content they will grasp much quicker the instructional intent of the words and the numbers of words needed to explain will be reduced by a lot as everyone will understand and have loaded for the instruction the standard content training module. this would be extremely useful when upgrades and version changes move things around .. It would also make it possible fore everyone to understand where to send persons looking for answers.. for example got to standard training module 9ll that explains what to do or how to .... and that training modules always works with the standard content spread sheet.. -------------------------------------------- On Sun, 12/11/16, Bruce Hohl <[email protected]> wrote: Subject: Re: [libreoffice-users] i of the most disturbing things about 5.0 libreoffice To: "[email protected]" <[email protected]> Date: Sunday, December 11, 2016, 9:05 AM 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 -- 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
