----- Original Message ----
> From: Steve Edmonds <[email protected]>
> To: [email protected]
> 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 [email protected]
In case of problems unsubscribing, write to [email protected]
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
