Hyperlink Bug in calc - bug 62289

users
#21

I understand perfectly what you are saying.
I just do not understand why you cannot enter the cell location as well as
the sheet number.
When I do it, it just works.

I know the Hyperlink has not asked for the cell reference, but you could
give it anyway.
There are far too many bugs waiting to be corrected.
I just do not see why this needs to be corrected.

Please do not take offense, I started off trying to help.

Tink.

#22

Actually the bug is exactly as described. Testing with LibreOffice 4.0.2 rc1

The problem is in interpreting an incomplete hyper link.

1) If the complete hyper link is entered Sheet 2.A2 it becomes #Sheet 2.A2
And movement to that sheet and cell is reliable.

2) If you insert the hyperlink without the cell reference, e.g. #Sheet 2,
it takes you that sheet but looks to retain the last cell referenced, i.e.
the landing cell is erratic.

3) And if as Tanstaafl reports in fdo#62289
<https://bugs.freedesktop.org/show_bug.cgi?id=62289> even if you use the
GUI and select the numbers only page name, e.g. 3 so hyperlink is #3 ,the
link is interpreted incorrectly and you remain on the same page--and
apparently in that numbered row.

So there is definitely an issue with the Target in Document GUI picker
allowing an incomplete hyper link. Or equally an inconsistent
parser/handling logic for incomplete hyperlink targets--would think that
absent a complete hyperlink target, the parser should identify the sheet and
default to a consistent cell--A1 I would imagine.

Stuart

#23

Precisely, and I agree A1 is the most logical choice for the default...

So, the user would click the sheet name (#2), and the target should be entered as #2.A1, which the user would then be free to modify if desired.

Thanks for confirming Stuart

#24

I understand perfectly what you are saying.
I just do not understand why you cannot enter the cell location as well as
the sheet number.
When I do it, it just works.

I didn't say I couldn't do it, and I didn't say it didn't work if I did that.

I know the Hyperlink has not asked for the cell reference, but you could
give it anyway.

Agreed, but this is irrelevant to the bug report.

There are far too many bugs waiting to be corrected.
I just do not see why this needs to be corrected.

Maybe because it would (most likely) be trivial?

And I don't recall any Libreoffice developer ever saying 'Hey, we have too many bugs, please stop reporting them unless they are 'really important'(tm)...

Please do not take offense, I started off trying to help.

Ok, no problem, probably it is just a language thing...

Anyway, my whole point of the bug is that what the user intends, because they intentionally selected the other SHEET (named with a number), does not occur.

As Stuart just pointed out, the best fix would be for the picker to just add the .A1 to the sheetname (regardless of whether or not it is a number), then let the user edit it if desired.