https://issues.apache.org/ooo/show_bug.cgi?id=125612
Issue ID: 125612
Issue Type: ENHANCEMENT
Summary: HYPERLINK wizard give a wrong URL if you want to go on
another sheet
Product: Calc
Version: 4.1.1
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: ui
Assignee: [email protected]
Reporter: [email protected]
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.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
