HyperLink problems

[CharlieK]

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

[scsisys]

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

[CharlieK]

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

[CharlieK]

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.

[ken johnson]

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).