Hyperlink Bug in calc - bug 62289

users
#1

Hi everyone,

Would appreciate if some of you could confirm this bug for me.

I'm on Windows XP sp3, with LibreOffice 4.0.1 release...

https://bugs.freedesktop.org/show_bug.cgi?id=62289

Bug report:

A hyperlink defined on one worksheet that is linked to another sheet/tab in the same workbook that is named only with a number, when clicked, takes you to the ROW NUMBER in the same sheet, instead of the desired sheet.

Steps to reproduce:

1. Create a new/blank worksheet

2. Create an additional sheet

3. Rename the sheet to any number

4. Add a hyperlink in sheet1, and make the target the other sheet that has a number for the name

5. Click the hyperlink

6. Instead of taking you to the desired sheet, you go to the ROW that has the same number as the sheet you are trying to go to.

#2

Tanstaafl wrote:

Hi everyone,

Would appreciate if some of you could confirm this bug for me.

I'm on Windows XP sp3, with LibreOffice 4.0.1 release...

https://bugs.freedesktop.org/show_bug.cgi?id=62289

Bug report:

A hyperlink defined on one worksheet that is linked to another sheet/tab
in the same workbook that is named only with a number, when clicked,
takes you to the ROW NUMBER in the same sheet, instead of the desired
sheet.

Steps to reproduce:

1. Create a new/blank worksheet

2. Create an additional sheet

3. Rename the sheet to any number

4. Add a hyperlink in sheet1, and make the target the other sheet that
has a number for the name

5. Click the hyperlink

6. Instead of taking you to the desired sheet, you go to the ROW that
has the same number as the sheet you are trying to go to.

Confirmed.
Version 4.0.1.2 (Build ID: 84102822e3d61eb989ddd325abf1ac077904985)

Dave

#3

Hi Dave,

Cross-posting this to the dev list in hopes someone will see it and pick this bug up...

Would appreciate if you would comment in the bug and confirm that you see the same problem.

This is a big problem for us - we have a LOT of worksheets with sheets named for years (ie, 2010, 2011, 2012, 2013...), and this makes it very very difficult to navigate these workbooks...

Thanks,

Charles

#4

For the benefit of others, there is no bug.
You need to include a position on the sheet, say: Target 2014,A1
This will take you to cell A1 on Sheet 2014.

Tink.

#5

So the bug is in the window that pops up for target (press the target button). It inserts sheet incorrectly as the target. This sounds an easier fix.
But if I enter 2014,A1 as the target I get the error invalid range.

Steve

#6

Steve

Replace the comma with a stop.

Alas it still does not work correctly.
It moves the cursor to Sheet 2014 Cell A1, but it also moves the Hyperlink
to Sheet 2014 as well.
I have not the time to sort that out at present.
Perhaps someone more intuitive can help.

Tink.

#7

And for the group.

Steve

Replace the comma with a stop.

Alas it still does not work correctly.
It moves the cursor to Sheet 2014 Cell A1, but it also moves the Hyperlink
to Sheet 2014 as well.
I have not the time to sort that out at present.
Perhaps someone more intuitive can help.

Tink.

Thanks. It worked for me. Highlighted text in sheet zyz to be the hyperlink, then insert hyperlink and then typed in the target 2012.a1

The hyperlink stayed ok on the original page. It seems it is just adding the hyperlink with the target button that is broken. When you select a sheet it inserts, say 2012 and it should insert 2012.a1 as a minimum.
Steve

#8

Steve

No luck with either Hyperlink from the INSERT menu, or Hyperlink from the
Functions.
The Help pages are anything but on this subject.

Can you send me a copy of your file so that I can try it.

Many thanks, Tink.

#9

Steve

There is no bug.
Not all Hyperlinks will be to another Sheet, so adding a sheet location
would cause more problems.
The Documentation could be improved though.

Thank you for your example, it works.
I tried adding another Hyperlink to your Sheet 2012 and it moved the Link to
Sheet 2011, just as I have been experiencing.
It follows then that there must be: A difference in the interpretation, i.e.
a bug in the Mac version, or a difference in the instruction, i.e. my entry
into the drop down frame.
Here is my entry:
<http://nabble.documentfoundation.org/file/n4044189/Link.jpg>

Adding a Name does not apply.
I cannot see what other arrangement I could have tried.

Tink.

#10

Hi Steve

Doh!
The solution is unbelievably simple.
It does not much matter what technique you use as long as you have 2011.A1,
or equivalent, in a Hyperlink.
To make it work you have to SAVE the file before you use the Hyperlink.
Any attempt to test it first will mess up your Sheets.
Would you say this constitutes a BUG?

Tink.

#11

Hi.
What version LO are you using. I will fire up my mac and check there too, my last test was 3.6 on Suse.
Steve

#12

Hi.
  Just ried 3.6 on my mac, it works the same as 3.6 on Suse. What do you mean in your reference to "the drop down frame". I insert the hyperlink by selecting (highlighting) the text in the cell that is to contain the hyperlink and then typing in 2012.A12 where you show it. The text "Next Year" is the text that I highlighted.
Steve

#13

Works for me without saving. I just create a new calc document, insert a sheet and rename to 1012. Go back to the first sheet, type some text in a cell "Goto 2012", highlight it and Insert>Hyperlink, type in 2012.A1 for the target and all works fine.
Steve

#14

Steve

I have tried this on Mac 10.8.2 and Mac 10.8.3
For LibreO, I have tried 4.0.1 and 4.0.2.1 with no variation in the results.
There must be something in the way I have it set up in the Preferences.
Now I know how to cope with it, it isn't much of a problem as it only
happens when you set up a new sheet.
Very odd though.

Tink.

#15

Steve

There is no bug.

Yes, there is.

When you add the hyperlink using the GUI (Insert > Hyperlink > Document > Target > OtherSheet), where OtherSheet name is only a number, it adds a hyperlink that doesn't take you to that sheet, it only adds a link to 'Number', which results in the hyperlink taking yo to that RowNum in the current sheet.

This is *obviously* not what the user wanted, because they intentionally chose the other sheet.

What it should do is add a hyperlink to SheetName.A1 (and let the user decide whether or not to change the target cell or not). Apparently this is what it used to do, hence, this is a regression.

#16

Tanstaafl

Sorry, but there is no bug.

Tink

Sorry, but you are wrong.

The Program has no way of knowing whether you want to move to another place
on the same sheet, or whether you want to move to another sheet.

Seriously??? What, pray tell is unclear about:

Click 'Insert' > 'Hyperlink' > 'Document' > 'Target' > 'OtherSheet' ?

Seriously. I, the user, by doing the above, am *telling* it to go to a *different sheet*. You honestly don't think that is clear enough for the program?

If you give it the full path i.e. 2012.A1, then it can accept the hyperlink.
You appear to assume that all hyperlinks will be to another spreadsheet.

And you obviously did not read - or did not comprehend - my email - try again.

Hyperlinks are also used in the Writer and Drawing modules.

Irrelevant to my point.

In order to cater for all the different circumstances, I cannot see how it
could have been coded otherwise.
Surely it is up to the User to input precisely what they want.

That is *precisely what I am doing.

#17

For the benefit of others, there is no bug.

For the benefit of others, there is most certainly a bug. Tink, stop saying otherwise.

You need to include a position on the sheet, say: Target 2014,A1
This will take you to cell A1 on Sheet 2014.

1. The GUI itself allows me to select *just* a sheet name, nothing else is required, or even asked for:

Click 'Insert' > 'Hyperlink' > 'Document' > 'Target in Document' button > 'OtherSheet'

2. If the sheet name is anything other than *just* a number, clicking the hyperlink takes me to the desired sheet.

3. If the target sheet name is just a number, it takes me to that number row but in the CURRENT sheet, NOT in the target sheet.

Interestingly, what *cell* it decides to land on in the target sheet seems to be random.

#18

Tanstaafl

If I enter 2014.A1 as the Hyperlink target, a click on it takes me to sheet
2014 cell A1
If I enter 2012.C12 the link takes me to Sheet 2012 Cell C12
So where is the Bug?

Go to the bug and read the comments.

Tink.

#19

Tanstaafl

If I enter 2014.A1 as the Hyperlink target, a click on it takes me to sheet
2014 cell A1
If I enter 2012.C12 the link takes me to Sheet 2012 Cell C12
So where is the Bug?

<sigh>

The first and foremost bug is that apparently you cannot read and/or understand what I am saying.

My point is, if, using the GUI, when adding a hyperlink, and I select a SHEET named with a number, I obviously am telling Libreoffice to link to that SHEET, NOT the row# on the CURRENT sheet.
If you cannot see that, then please just don't reply any more because I am tired of repeating myself.

Go to the bug and read the comments.

I have. I am the bug creator.

#20

Guys,

What are we discussing about? Ok, the bug isn't the hyperlink which
doesn't work, but it's easy reproducable following the steps Tanstaafl
did provide easy and clearly.

The bug is with other words the hyperlink creating, instead of the
hyperlink processing.

There are 2 options now : or you keep on weening about the structure
and exact wordings of the message, or you use the energy to find a
solution. I do support as well, in another domain, and my choice is
always to help the enduser. I hope LO can improve the support by
helping people. This way, you send people to MS, which is very sad.

(and yes, I once entered a bug myself, on which I received so much
negative comment, I'd think twice to enter a bug again... such a pity)

Met vriendelijke groeten, Salutations distinguées, Kind Regards,

DRIES FEYS
CORPORATE SERVICES • Specialist Software Developer