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

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