Download it now!
Bug 75889 - Hyperlinks in formula cells cannot be edited
Summary: Hyperlinks in formula cells cannot be edited
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.5.3 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 106504 (view as bug list)
Depends on:
Blocks: Hyperlink-Calc
  Show dependency treegraph
 
Reported: 2014-03-07 14:26 UTC by Petrovic
Modified: 2018-10-27 20:30 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


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
spreadsheet that I cannot edit (try editing cells A193:C193) (21.64 KB, application/zip)
2017-03-13 10:26 UTC, John Smith
Details
spreadsheet that cannot always be edited try A193:C193 (27.35 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-03-13 10:34 UTC, John Smith
Details
attachment (confidential) in xlsx format of original spreadsheet that appears uneditable with LibreOffice Calc v.5.2.5.1 (21.64 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-03-13 10:35 UTC, John Smith
Details

Note You need to log in before you can comment on or make changes to this bug.
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
Comment 6 QA Administrators 2016-02-21 08:36:57 UTC Comment hidden (obsolete)
Comment 7 Jean-Baptiste Faure 2016-02-21 17:30:42 UTC
Nothing changed with LO 5.1.2.0.0+ and master.

Best regards. JBF
Comment 8 Petrovic 2016-02-22 11:15:40 UTC
I've just now tested it again with the supplied "The original MS Excel file in which the bug appeared. / Original File Edited.xls" 
And the bug still exists.
I'm using LO 5.1.0.3 on a Windows 8.1 machine.
Comment 9 m.a.riosv 2017-03-12 22:23:21 UTC
*** Bug 106504 has been marked as a duplicate of this bug. ***
Comment 10 John Smith 2017-03-13 10:26:41 UTC
Created attachment 131846 [details]
spreadsheet that I cannot edit (try editing cells A193:C193)
Comment 11 John Smith 2017-03-13 10:34:15 UTC
Created attachment 131847 [details]
spreadsheet that cannot always be edited try A193:C193
Comment 12 John Smith 2017-03-13 10:35:59 UTC
Created attachment 131848 [details]
attachment (confidential) in xlsx format of original spreadsheet that appears uneditable with LibreOffice Calc v.5.2.5.1
Comment 13 John Smith 2017-03-13 10:37:19 UTC
What security vulnerabilities does sharing my spreadsheet make me vulnerable to please and is there a way of brainstorming on mitigating some of these?
Comment 14 Jean-Baptiste Faure 2017-03-14 06:05:46 UTC
(In reply to John Smith from comment #13)
> What security vulnerabilities does sharing my spreadsheet make me vulnerable
> to please and is there a way of brainstorming on mitigating some of these?

I temporarily marked your attachments as obsolete. What plus does they bring to this bug report?

Best regards. JBF
Comment 15 QA Administrators 2018-08-22 02:36:53 UTC Comment hidden (obsolete)
Comment 16 Petrovic 2018-08-22 10:15:23 UTC
I've tested my-reported-bug again, as requested.

The bug is still present.

But to me - and perhaps to others - it is not really that important or inconvenient, since my bug-report is about "converting from MS Office '97 Excel" and all conversion issue's I once got, are since long manually resolved.

Information from Help - About LibreOffice.
Versie: 6.0.5.2 (x64)
Build ID: 54c8cbb85f300ac59db32fe8a675ff7683cd5a16
CPU-threads: 8; Besturingssysteem: Windows 10.0; UI-render: GL; 
Locale: nl-NL (nl_NL); Calc: CL
Comment 17 Timur 2018-08-22 11:33:04 UTC
I understand that bug is about "Editing the hyperlink within the cell show an empty Hyperlink window."
That's true only if you edit within cell, without selecting hyperlinked text first. If you select hyperlinked text (keep in mind you may have multiple links within single cell), path is shown and can be edited.
We may have ana issue that hyperlink should be picked without selecting text, but that's another issue-
So I'll close this bug.

Anyway, we have Bug 79972 I add to see also. Also numerical content like in the original here.