OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

How to copy formula in one cell to another, relative?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
CalcBeginner
General User
General User


Joined: 29 Feb 2012
Posts: 11

PostPosted: Wed May 02, 2012 8:06 pm    Post subject: How to copy formula in one cell to another, relative? Reply with quote

Is there a way to copy a relative formula from one cell to another cell that is not contiguous?

Thanks for any pointers.
Back to top
View user's profile Send private message
pitonyak
Administrator
Administrator


Joined: 09 Mar 2004
Posts: 3655
Location: Columbus, Ohio, USA

PostPosted: Wed May 02, 2012 8:16 pm    Post subject: Reply with quote

My guess is that I do not understand your question.

In cell B2, enter the formula =D5

Now, copy cell B2 to the clipboard and paste it at C5. I expect that the formula will now be E8. Is this not correct?
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address
CalcBeginner
General User
General User


Joined: 29 Feb 2012
Posts: 11

PostPosted: Thu May 03, 2012 4:25 am    Post subject: Reply with quote

You're right. That does work. I have no idea why I couldn't figure that out myself.

Thanks for the answer!
Back to top
View user's profile Send private message
pitonyak
Administrator
Administrator


Joined: 09 Mar 2004
Posts: 3655
Location: Columbus, Ohio, USA

PostPosted: Fri May 04, 2012 5:32 pm    Post subject: Reply with quote

Glad it worked.... Smile
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2005 phpBB Group