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

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 <southofmexico@yahoo.com>
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 <brucehohl@gmail.com> wrote:
>
>  Subject: Re: [libreoffice-users] i of the most disturbing things about
> 5.0 libreoffice
>  To: "users@global.libreoffice.org" <users@global.libreoffice.org>
>  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 <
> 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

-- 
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