Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index






----- Original Message ----
From: Steve Edmonds <steve.edmonds@ptglobal.com>
To: users@global.libreoffice.org
Sent: Mon, 13 June, 2011 11:31:11
Subject: Re: [libreoffice-users] copy down, copy and paste in calc.



On 13/06/11 8:59 PM, Stephan Zietsman wrote:
Steve Edmonds  wrote:
When I want to copy the same formula to a range of cells  without the
references indexing this is usefull, but the formula  only copies to the
top cell.

Another usefull  thing would be;
click into a cell with formula and drag the bottom  right black square
down, the formula repeats indexing the  references. (does this now).
click into a cell with formula while  holding ctl (cmd) down and drag the
bottom right black square down,  the formula repeats without indexing the
references, i.e. copies  literally as with numbers. (does not do this now).
If you want to copy a  formula without "indexing the reference", then
you can take a look at  absolute references.  It is described in the
LibreOffice  wiki

(http://help.libreoffice.org/Calc/Addresses_and_References,_Absolute_and_Relative).

   A short summary is:
Let's say cell C1 contains the following formula  (without the quotes):
"= A1 + B1"
If you copy the formula in  cell C1 to cell C2 (by either Copy&  Paste,
or by dragging the  corner of cell C1) you will get "= A2 + B2" in cell
C2.
If this  is not what you wanted, you can change the reference in C1 to
an  absolute reference.

To do this, select the cell C1 and press  SHIFT+F4.  The formula in
cell C1 will change to "= $A$1 +  $B$1".  If you copy that to cell C2,
it will stay "= $A$1 +  $B$1".

If you want a more detailed explanation of absolute and  relative cell
referencing, read the wiki page or ask in this mailing  list for more
info.

Thanks Stephan and Tom.
I already  understand the use of the absolute referencing. I may not have 
expressed  myself well enough to avoid confusion.
1. Enter say the digit 9 into a cell.  Click into the cell, copy. Select 
5 cells and paste. 9 pastes into all 5  cells.

2. Now in your email, select a word or number and copy. Select 5  cells 
and paste. The word only pastes into the top 1 of the 5  cells.

It would be nice if the behavior in 2 was the same as in  1.

steve


Hi :)
That is inconsistent and i hadn't noticed.  It happens in LO3.3.2 on Ubuntu 
10.04 too.  can you post a bug-report about it?
9
Regards from
Tom :)


-- 
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.