| Summary: | Fails to open hyperlink with .xlsx file type and #Sheet1!C2, works with .xls file type | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | gekacheka |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | miguelangelrv |
| Priority: | medium | ||
| Version: | 4.1.3.2 release | ||
| Hardware: | x86 (IA32) | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
This looks like a simple hyperlink parsing bug. 0. Hyperlink works to open file if url ends with .xlsx and has no # fragment 1. Hyperlink FAILS to open file if url ends with .xlsx and has #Sheet1!C2 fragment 2. Hyperlink works to open file if url ends with .xls and has #Sheet1!C2 fragment When it fails, the error message is Windows cannot find '...xlsx#Sheet1!C2' where the #fragment seems erroneously included in the filename it is trying to find. Steps to reproduce: 1.1. Ctrl+N (new spreadsheet) 1.2. File / Save-as File name c:\temp\Test-1A Save as type (.xlsx) 1.3 Ctrl+N (new spreadsheet) 1.4 For cell A1 enter hyperlink =HYPERLINK("file:/c:/temp/Test-1A.xlsx#Sheet1!C2", "linkA") 1.5 invoke hyperlink (may require control-click) Result: Dialog title "c:\temp\Test-1A.xlsx#Sheet1!C2" Dialog text "Windows cannot find 'c:\temp\Test-1A.xlsx#Sheet1!C2'. Make sure you typed the name correctly, ..." Expect: Opens c:\temp\Test-1A.xlsx and focuses on sheet1 cell C2 For 2: (same steps as 1, but save-as file type .xls, and use hyperlink file type .xls) 2.1. Ctrl+N (new spreadsheet) 2.2. File / Save-as File name c:\temp\Test-1B Save as type (.xls) 2.3 Ctrl+N (new spreadsheet) 2.4 For cell A2 enter hyperlink =HYPERLINK("file:/c:/temp/Test-1B.xls#Sheet1!C2", "linkB") 2.5 invoke hyperlink (may require control-click) Result as expected: Opens c:\temp\Test-1B.xls and focuses on Sheet1 cell C2. (If the file could not be found, the error message is different: Dialog title: "LibreOffice 4.1.3.2" Dialog text: "c:\temp\Test-1B.xls does not exist" ) LibreOffice: 4.1.3.2 OS: WindowsXP sp3