fudmer, You can find LibreOffice documentation and help sites from the links on this page: http://www.libreoffice.org/get-help/community-support/ A modern Office Suite like LO has a huge number of features but you need only study and understand the features needed for their requirements.
On Mon, Dec 12, 2016 at 10:16 AM, fudmer rieley <[email protected]> wrote: > > > 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
