Bug 72927

Summary: Fails to open hyperlink with .xlsx file type and #Sheet1!C2, works with .xls file type
Product: LibreOffice Reporter: gekacheka
Component: CalcAssignee: 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:

Description gekacheka 2013-12-20 18:29:15 UTC
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
Comment 1 m_a_riosv 2013-12-21 00:36:19 UTC

*** This bug has been marked as a duplicate of bug 72081 ***