https://bugs.freedesktop.org/show_bug.cgi?id=72927
Priority: medium
Bug ID: 72927
Assignee: [email protected]
Summary: Fails to open hyperlink with .xlsx file type and
#Sheet1!C2, works with .xls file type
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.0.0.3 release
Component: Spreadsheet
Product: LibreOffice
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
