Bug 75889 - Hyperlinks in formula cells cannot be edited
Summary: Hyperlinks in formula cells cannot be edited
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 4.1.5.3 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-03-07 14:26 UTC by Petrovic
Modified: 2015-01-23 14:51 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:


Attachments
3 printscreens added together to illustrate the bug (108.87 KB, image/jpeg)
2014-03-07 14:26 UTC, Petrovic
Details
Microsoft Excel 97 Test Document (14.00 KB, application/vnd.ms-excel)
2014-05-11 14:28 UTC, Petrovic
Details
The original MS Excel file in which the bug appeared. (36.00 KB, application/vnd.ms-excel)
2014-05-11 15:32 UTC, Petrovic
Details

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.