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

Hi :)
Yes, good point!  You can fine-tune it by only using the $ in one part of the 
cell reference so that copying in one direction does change which cells are 
looked up.  


For example writing this in say D4
=$A1 + C$3
means that as you copy the formula down the rows the A part doesn't change, it 
stays a A, obviously.  The 1 part changes.  The C part also stays the same 
because of the direction we are copying in but the 3 also doesn't change because 
it's been fixed by the $ sign.  


Copying the same formula across several columns the A will still stay fixed 
because it's been fixed by the $ sign, the 1 wont change because we are staying 
on the same row.  The C will change tho because it hasn't been fixed.

Regards from
Tom :)




----- Original Message ----
> From: Stephan Zietsman <sziets@gmail.com>
> To: users@global.libreoffice.org
> Sent: Mon, 13 June, 2011 9:59:33
> Subject: Re: [libreoffice-users] copy down, copy and paste in calc.
>
> 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.
>
> Regards
> Stephan
>
> -- 
> 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

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