Issue 125612 - HYPERLINK wizard gives a wrong URL if you want to go on another sheet
Summary: HYPERLINK wizard gives a wrong URL if you want to go on another sheet
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 4.1.1
Hardware: All All
: P3 Normal with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact: Pedro
Depends on:
Reported: 2014-09-11 14:11 UTC by oooforum (fr)
Modified: 2014-10-01 19:42 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.1
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description oooforum (fr) 2014-09-11 14:11:00 UTC
Steps to reproduce:
1- Open a spreadsheet and stay in Sheet1, A1 cell
2- Run Function wizard
3- Choose HYPERLINK function
4- In URL field, click on [Select] button
5- Go to Sheet2, select A1 cell and click on [Maximize] button
6- In URL field, text is now "Sheet2.A1" (without double quotes)
7- In CellText field, input "Jump to Sheet2" (with double quotes)
8- Press [OK] button
9- Now click on this hyperlink
Expected behavior: you jump to Sheet2
Wrong behavior: Windows alert that Sheet2 is not found

Help F1 says that syntax must be:
=HYPERLINK("#Sheet1.A1";"Go to top") 
So, wizard should add the hashtag and double quotes to URL in this case.
Comment 1 Pedro 2014-10-01 19:42:25 UTC
Confirmed defect on 4.1.1