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

[Solved]How do I use Hyperlinks to link cells in different s

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


Joined: 05 May 2011
Posts: 3

PostPosted: Thu May 05, 2011 7:23 am    Post subject: [Solved]How do I use Hyperlinks to link cells in different s Reply with quote

i have a spreadsheet for a 90 bottle wine rack, sheet 2 contains detailed info for each bottle Domaine, Country, Year etc. sheet 1 is a 9x10 grid representing the wine rack. What I am struggling with is getting a hyperlink to link a cell on sheet 1 to a cell on sheet 2 using the text in sheet 2 (ie Domaine) as the link in sheet 1 ( its location on the rack). I can make a hyperlink or have the text visible but not both.
many thanks in advance


Last edited by bobbysknob on Sat May 07, 2011 2:04 pm; edited 1 time in total
Back to top
View user's profile Send private message
ken johnson
Super User
Super User


Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

PostPosted: Thu May 05, 2011 5:14 pm    Post subject: Reply with quote

I'm not sure about the direction you are wanting the link to go; Rack Grid to Table or vice versa, both are possible.
To demonstrate one way, the attached doc (HyperDrinks.ods) has two rack grid positions (D6 and F4) that you will be taken to depending on which sheet2 table row hyperlink is clicked.
I've used the HYPERLINK function along with the CELL and SUBSTITUTE functions to construct the links' destination within the sheet1 Rack Grid. The sheet1 Rack Grid cell, to which the clicked hyperlink takes you, is extracted from an extra column on sheet2 (Rack Cell Address).
Each hyperlink's displayed text (2nd parameter) is extracted from the table of Domaine, Country, Year, Etc.
When done this way the Hyperlinks are very easily set up as the formula is filled across columns and down rows.
The original Domaine, Country, Year, Etc table could be hidden.
http://www.mediafire.com/view/?tj2htciwwmy3pfg
Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).


Last edited by ken johnson on Thu Oct 04, 2012 7:44 pm; edited 1 time in total
Back to top
View user's profile Send private message
bobbysknob
Newbie
Newbie


Joined: 05 May 2011
Posts: 3

PostPosted: Sat May 07, 2011 8:00 am    Post subject: Reply with quote

Ken,
Thanks for your response, how ever it doesn't quite solve the problem I'm trying to solve,
What I would like to achieve is to be able to enter info into sheet2 A1 and have that also appear in sheet1 B2 and have that become a hyperlink back to sheet2 A1.
The reasoning behind this is that sheet2 holds all the detailed info over a number of columns and sheet1 is an graphical image of the wine rack and I only need Domaine name in sheet1. As the wine in the rack is consumed/replaced I update sheet2 and sheet1 is automatically updated.
This worked fine in Excel but moving away from Windoze to Linux has meant the change to OO.
Regards, Andy.
Back to top
View user's profile Send private message
ken johnson
Super User
Super User


Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

PostPosted: Sat May 07, 2011 1:49 pm    Post subject: Reply with quote

Like this then?...
http://www.mediafire.com/view/?dyktena23frozos
Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).


Last edited by ken johnson on Thu Oct 04, 2012 7:41 pm; edited 1 time in total
Back to top
View user's profile Send private message
bobbysknob
Newbie
Newbie


Joined: 05 May 2011
Posts: 3

PostPosted: Sat May 07, 2011 2:00 pm    Post subject: Reply with quote

Ken,
Thank you for your help, that's exactly what I was after.
Andy
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