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

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