|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | HYPERLINK wizard gives a wrong URL if you want to go on another sheet | ||
|---|---|---|---|
| Product: | Calc | Reporter: | oooforum (fr) <oooforum> |
| Component: | ui | Assignee: | AOO issues mailing list <issues> |
| Status: | CONFIRMED --- | QA Contact: | Pedro <pedrova> |
| Severity: | Normal | ||
| Priority: | P3 | CC: | pedrova |
| Version: | 4.1.1 | ||
| Target Milestone: | --- | ||
| Hardware: | All | ||
| OS: | All | ||
| Issue Type: | DEFECT | Latest Confirmation in: | 4.1.1 |
| Developer Difficulty: | --- | ||
Confirmed defect on 4.1.1 |
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.