Re: [libreoffice-users] copy down, copy and paste in calc.

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