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

HyperLink problems

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


Joined: 14 Jun 2012
Posts: 3
Location: Minnesota

PostPosted: Thu Jun 14, 2012 1:36 pm    Post subject: HyperLink problems Reply with quote

I'm having some hyperlink problems in Calc.

The hyperlink is from the first sheet in Calc, to one of approximately 30 sheets.

To make my hyperlink...
- select the cell I want the hyperlink in..
- click on the hyperlink button up on the tool bar
In the Hyperlink box, on the left side, "document" is selected
- I click on the folder symbol following the "path" box, and locate the folder that contains my open office document.
- Click on the "target" symbol following the Target box, when "Target in Document" opens, I expand the "sheets", scroll down to the sheet I want, select it (sometimes by double clicking, or simply selecting it, and clicking apply.
- Close the "target in Document" box
- Click on "apply" in the main Hyperlink box, and then clicking close.

When I click on the hyperlink that I just created, (the sheet name begins with "LR"), instead of taking me to the sheet with that name, that I most certainly selected out of my list of sheets.... Its taking me to column LR in the first sheet! LR is many, many columns off my screen.

Whats going on? This is not the first time this has happened... Sometimes it works like it should, and then sometimes....

Is there a limit as to how many hyperlinks you can have?

Thanks

Charlie

OpenOffice 3.4.0
Windows 7 64-bit
Back to top
View user's profile Send private message
scsisys
OOo Advocate
OOo Advocate


Joined: 17 Dec 2009
Posts: 248

PostPosted: Thu Jun 14, 2012 4:46 pm    Post subject: Reply with quote

The samples below work for getting to the sheet(s) named "LRtest" OR "LR test"
or "LR" and end up in cell A1 on each example for me.

=HYPERLINK("#LRtest";"a1") OR =HYPERLINK("#LR test";"a1") OR =HYPERLINK("#LR";"a1")

scsisys
_________________
OO 3.2.1
Win XP /SP3
Back to top
View user's profile Send private message
CharlieK
Newbie
Newbie


Joined: 14 Jun 2012
Posts: 3
Location: Minnesota

PostPosted: Fri Jun 15, 2012 2:28 am    Post subject: Reply with quote

The sheet I'm trying to hyperlink to is named "LR66"

When I use:

=HYPERLINK("#LR66";"a1")

Its doing the exact same thing... It is staying on the first sheet, but moving far to the right, to the column LR
Back to top
View user's profile Send private message
CharlieK
Newbie
Newbie


Joined: 14 Jun 2012
Posts: 3
Location: Minnesota

PostPosted: Fri Jun 15, 2012 2:50 am    Post subject: Reply with quote

Using =HYPERLINK("#LR66";"a1") Does the exact same thing. It links to a cell in column "LR" in the first sheet.

Doing it my regular way, using the hyperlink button in the tool bar, if I change the name of the sheet from LR66 to zLR66, it works just as it should.

Any clues as to why its doing this? Every sheet that I'm having a problem with, I could probably rename with a small "z" before the name, but its pretty messy, and much harder to read.

The next sheet that I'm having problems linking to is "LR77". Exactly the same thing. If I do the link like normal, it links to a cell on the first sheet in column "LR". If I change the name of the sheet to "zLR77", it works perfectly.
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: Fri Jun 15, 2012 2:56 am    Post subject: Reply with quote

Perhaps your user profile is corrupt and needs to be reset...
http://user.services.openoffice.org/en/forum/viewtopic.php?p=58403#p58403

Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
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