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 <[email protected]> > To: [email protected] > 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 [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 > > -- 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
