Bug 75889

Summary: Hyperlinks in formula cells cannot be edited
Product: LibreOffice Reporter: Petrovic <Petrovic>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: normal    
Priority: medium CC: jbfaure
Version: 4.1.5.3 release   
Hardware: Other   
OS: Windows (All)   
Whiteboard:
i915 platform: i915 features:
Attachments: 3 printscreens added together to illustrate the bug
Microsoft Excel 97 Test Document
The original MS Excel file in which the bug appeared.

Description Petrovic 2014-03-07 14:26:41 UTC
Created attachment 95303 [details]
3 printscreens added together to illustrate the bug

The problem-document originates from my (soon to be discard) old PC with Windows XP. It is Office '97 Excel file.
I've converted lots-and-lots of excel sheets to .ods files and I'm realy enthousiastic about LibreOffice (Calc).

Step 1. Opening my .ods file. No problem here.
Step 2/printscreen 1. This document contains lots of hyperlinks as you can see.
Step 3/printscreen 2. Clicking a cell results in a expected error. ("Expected", because my new Windows 8.1 computer has different path names.)
Step 4/printscreen 3. Editing the hyperlink within the cell show an empty Hyperlink window.
Comment 1 Jean-Baptiste Faure 2014-05-01 09:06:29 UTC
Without a test file showing the problem, it is impossible to try to reproduce and fix the bug if one exists.
Please, attach a test file without confidential data.

Thank you for your understanding.
Best regards. JBF
Comment 2 Petrovic 2014-05-11 14:28:28 UTC
Created attachment 98843 [details]
Microsoft Excel 97 Test Document

As requested: a Microsoft Excel 97 Test Document
Comment 3 Petrovic 2014-05-11 15:31:08 UTC
I've created and attached a new (=just made) "Test Document.xls" (in Microsoft Excel 97 SR-2 format).

When I try to recreate my problem, I could not recreate it!
If I now use the Hyperlink dialog, there is really a dialog! Just how it's supposed to work.

In order to facilitate you in solving this bug, I've modified (=removed privacy information) the original document so you can see the problem for yourself.
I've called it Original File Edited.xls
I hope this is sufficient "proof".
Comment 4 Petrovic 2014-05-11 15:32:37 UTC
Created attachment 98857 [details]
The original MS Excel file in which the bug appeared.
Comment 5 Jean-Baptiste Faure 2014-05-20 04:42:08 UTC
Confirmed as NEW.
Indeed, I reproduce the problem. I do not see a mean to modify the hyperlinks in your test file. The problem seems to be linked to the "Excel_BuilIn_Hyperlink" style.

Best regards. JBF

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.