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

Can I link to aonther cell in the same spreadsheet?

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


Joined: 20 Apr 2007
Posts: 4

PostPosted: Fri Apr 20, 2007 11:37 am    Post subject: Can I link to aonther cell in the same spreadsheet? Reply with quote

Hi,

I need to link a cell to another cell in a different sheet within the same spreadsheet.

Can this be done and if so, how?

Thanks for any help,

Eric
Back to top
View user's profile Send private message
squenson
Super User
Super User


Joined: 09 Mar 2007
Posts: 690
Location: Nis, Serbia

PostPosted: Fri Apr 20, 2007 11:52 am    Post subject: Reply with quote

Mer,

Use the dot as separator, try <your_sheet>.<your_cell>, example Sheet2.C23
_________________
Help us to help you: Add [Solved] to the title of the thread if you agree with the answer
>>> Do you know the new OOo support forum http://user.services.openoffice.org/en/forum/index.php? <<<
Back to top
View user's profile Send private message
Mer
Newbie
Newbie


Joined: 20 Apr 2007
Posts: 4

PostPosted: Fri Apr 20, 2007 12:00 pm    Post subject: Reply with quote

Didn't work,

Here's what I'm trying:

=HYPERLINK("[OutlineDrawings.xls]Sheet4.A5","O-1261")

I'm just getting started in spreadsheets so I'm sorry in advance for the questions.

I'm in Sheet1 named Outline Drawings. The name of the spreadsheet is OutlineDrawings.xls.

I want to link the text in a cell in Sheet1 to cell, A5 in Sheet4.

Thanks,

Eric
Back to top
View user's profile Send private message
squenson
Super User
Super User


Joined: 09 Mar 2007
Posts: 690
Location: Nis, Serbia

PostPosted: Fri Apr 20, 2007 12:05 pm    Post subject: Reply with quote

Eric,

If you type in cell A1 oh Sheet1:
Code:
=Sheet4.A5
this should work.
_________________
Help us to help you: Add [Solved] to the title of the thread if you agree with the answer
>>> Do you know the new OOo support forum http://user.services.openoffice.org/en/forum/index.php? <<<
Back to top
View user's profile Send private message
Mer
Newbie
Newbie


Joined: 20 Apr 2007
Posts: 4

PostPosted: Fri Apr 20, 2007 12:41 pm    Post subject: Reply with quote

Didn't work, sorry.

Right now in cell A293 is: O-1261

I want that text to link to cell A5 in Sheet4 so when I click on the O-1261 it will take me to cell A5 in Sheet4.

Thanks,

Eric
Back to top
View user's profile Send private message
squenson
Super User
Super User


Joined: 09 Mar 2007
Posts: 690
Location: Nis, Serbia

PostPosted: Fri Apr 20, 2007 1:01 pm    Post subject: Reply with quote

Now I understand your question!

Select the source cell, type
Code:
=HYPERLINK("#Sheet4.A5";"0-1261")
Why a # before the sheet name? This is the delimiter between file name and sheets.
_________________
Help us to help you: Add [Solved] to the title of the thread if you agree with the answer
>>> Do you know the new OOo support forum http://user.services.openoffice.org/en/forum/index.php? <<<
Back to top
View user's profile Send private message
Mer
Newbie
Newbie


Joined: 20 Apr 2007
Posts: 4

PostPosted: Fri Apr 20, 2007 1:20 pm    Post subject: Reply with quote

Thank You!!

Eric
Back to top
View user's profile Send private message
dgrgic
General User
General User


Joined: 23 Apr 2007
Posts: 10

PostPosted: Mon Apr 23, 2007 3:18 am    Post subject: Reply with quote

This helped. Thank You.
But this is an absolute address and will not point to right place if destination cell is moved (with insert row or similar).
Do u have alternative solution that will take this into account as well?!

Tnx again,
Damir
Back to top
View user's profile Send private message
santosog
Newbie
Newbie


Joined: 10 May 2007
Posts: 1

PostPosted: Thu May 10, 2007 12:26 am    Post subject: Reply with quote

Define a name to the cell and create a hyperlink to the cell name instead of the cell row and column.

=HYPERLINK("#cellname";"O-1261")

Hope this helps.
Back to top
View user's profile Send private message
dgrgic
General User
General User


Joined: 23 Apr 2007
Posts: 10

PostPosted: Mon May 21, 2007 4:23 am    Post subject: tnx Reply with quote

It did tnx.
Back to top
View user's profile Send private message
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