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

Author Message
fatgreta
Power User

Joined: 12 Feb 2004
Posts: 80

 Posted: Wed Oct 01, 2008 7:28 am    Post subject: Copy / Paste Question Hi, I have a row of cells, B11 - B49. In cells C11 - C49, I want to calculate the percentage of each cell compared to the total in cell B6. So for cell B11 I write =B11/B6, and that works fine. I want to then be able to copy and paste that into the cells C12-C49, so that it reads =B12/B6; =B13/B6, etc. When I use copy and paste, though, it fills in the value as =B12/B7; =B13/B8, etc. I now there used to be a way to do this in excel, many years ago at least. Is there a way to do it with OO? I've tried every available option in Paste Special, but none of them seem to work. Thanks, Chris
JohnV

Joined: 07 Mar 2003
Posts: 8995
Location: Lexinton, Kentucky, USA

 Posted: Wed Oct 01, 2008 8:55 am    Post subject: =C11/B\$6
DiGro
Super User

Joined: 02 Jun 2004
Posts: 1210
Location: Hoorn NH, The Netherlands

Posted: Wed Oct 01, 2008 8:59 am    Post subject: Re: Copy / Paste Question

 fatgreta wrote: So for cell B11 I write =B11/B6, and that works fine.

Add two dollar-signs, one before the B of B6 an one in front of the 6 of B6, so that code reads:
 Code: =B11/\$B\$6

This makes B6 to be an ABSOLUTE reference.
.Now you can, with the small handle in the bottom right corner of cell C11, drag that formula down as far as you want.

fatgreta wrote:
 Code: =B12/B6; =B13/B6
, etc. When I use copy and paste, though, it fills in the value as =B12/B7; =B13/B8, etc.

This will make that the above cells now read:
 Code: =B12/\$B\$6; =B13/\$B\$6, =B14/\$B\$6 and so on

and will always refer to cell B6
_________________
DiGro

Windows 7 Home Premium and OOo 3.3 NL (Dutch)
fatgreta
Power User

Joined: 12 Feb 2004
Posts: 80

Posted: Wed Oct 01, 2008 9:01 am    Post subject:

 JohnV wrote: =C11/B\$6

Outstanding! Thanks so much.

Chris
DiGro
Super User

Joined: 02 Jun 2004
Posts: 1210
Location: Hoorn NH, The Netherlands

Posted: Wed Oct 01, 2008 9:03 am    Post subject:

 JohnV wrote: =C11/B\$6

However, absolute correct.

Now it is clear to me how you beat me to this one John
_________________
DiGro

Windows 7 Home Premium and OOo 3.3 NL (Dutch)
 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