[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
open.kinda.guy
Newbie

Joined: 24 Dec 2005
Posts: 1

 Posted: Sat Dec 24, 2005 4:03 pm    Post subject: Relative Reference HELP I feel like a simpleton. In excel if i wanted a relative reference spanning many rows all I had to do is R[-2]C[3] Then select all the rows and do a ctrl enter and Wallah. I cannot for the life of me accomplish this in OO I just want to sum colums C thru G into K on every row It works SUM(C1:G1) for one row But I cannot copy that to 500 hundred rows quickly? Merry Christmas Harry
AndrewZ
Moderator

Joined: 21 Jun 2004
Posts: 4140

 Posted: Sat Dec 24, 2005 4:16 pm    Post subject: Actually C1:G1 is a relative reference, and if you copy and paste it down in K, it will sum C through G. To make C1:G1 absolute (not relative), you would need to write \$C\$1:\$G\$1.
Super User

Joined: 03 Nov 2004
Posts: 727

 Posted: Sat Dec 24, 2005 6:09 pm    Post subject: To copy to 500 rows quickly Put the formula in the first row of the column, click on the little handle in the lower right corner, drag to row 500 or what ever. Formula will fill down referencing each new row. This is pretty much the same as it was in XL. Keyboard is: Put the formula in the first row, press shift and highlight that cell and holding shift scroll down the column all the way to the final cell wanted use Alt> Edit> Fill> Down that is AltE>i>d and the formula will fill to bottom referencing each new row. Like ahz said use of the \$ is the same as in XL and will keep the reference as typed not changing in each new cell.
David
Super User

Joined: 24 Oct 2003
Posts: 5668

Posted: Sun Dec 25, 2005 10:19 am    Post subject: Re: Relative Reference HELP

 open.kinda.guy wrote: I just want to sum colums C thru G into K on every row It works SUM(C1:G1) for one row But I cannot copy that to 500 hundred rows quickly?

There's always more than one way to swing a cat:

The sum is in H1? There is a small, square "handle" in the lower right of the cell with the cursor in it. As Booklady suggested, you can drag down, OR ...Drag down just a couple to select then, and they remain black, showing selection. Now scroll down to the required row, using the right scroll bar. Now choose Edit / Fill Selected.

David.
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum