Bug 149076 - LibreOffice Calc: Support Excel hyperlinks not tied to cells (feature request)
Summary: LibreOffice Calc: Support Excel hyperlinks not tied to cells (feature request)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.2.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: Hyperlink-Calc
  Show dependency treegraph
 
Reported: 2022-05-13 16:56 UTC by angus02010
Modified: 2023-08-04 19:17 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
XLSX hyperlink minimal document (8.87 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2022-05-14 16:52 UTC, angus02010
Details
XLS hyperlink minimal document (25.50 KB, application/vnd.ms-excel)
2022-05-14 16:53 UTC, angus02010
Details

Note You need to log in before you can comment on or make changes to this bug.
Description angus02010 2022-05-13 16:56:12 UTC
Description:
Microsoft Excel allows to select a number and add a hyperlink that is not tied to the cell nor shown in the input line. This is commonly used to attach a document, but still use the cell in numeric formulas.

Even though Calc has other means to achieve the same end, this makes difficult to interoperate with XLSX documents previously created with MS Excel, as it does not allow to:

* Create nor edit this kind of link.
* Access to the stored target path of the link (for instance, to copy it).

It already allows to:

* Open the hyperlink as usual.
* Use the number with the hyperlink in formulas as expected.

This is kind of a show stopper for us, as we have a bunch of "legacy" accounting documents that were made this way, and we need to relocate some paths. This is significantly harder when you can't at least copy them.

Steps to Reproduce:
1.Create a Excel document.
2.Type a number in a cell.
3.Right click, hyperlink it to a document.
    Note the input line is unaffected and you can use the number in formulas.
4.Save the document as XLSX and reopen it in Calc.


Actual Results:
The link can be opened, but not edited. Also, it is not possible to create an equivalent kind of symlink.

Expected Results:
At the very least, be able to access the link path inside. If possible, be able to create them as well.


Reproducible: Always


User Profile Reset: No



Additional Info:
Note how this kind of link is different under the hood to using a field (by using the Insert Hyperlink option / Ctrl+K), and also to using the HYPERLINK formula (tied to the cell).
Comment 1 angus02010 2022-05-13 16:58:50 UTC
Typo: *symlink -> hyperlink
Comment 2 Timur 2022-05-14 12:14:27 UTC Comment hidden (obsolete)
Comment 3 angus02010 2022-05-14 16:52:50 UTC
Created attachment 180120 [details]
XLSX hyperlink minimal document
Comment 4 angus02010 2022-05-14 16:53:19 UTC
Created attachment 180121 [details]
XLS hyperlink minimal document
Comment 5 angus02010 2022-05-14 16:55:30 UTC
(In reply to Timur from comment #2)
> Please attach minimal sample XLSX and XLS if supported.

Minimal sample documents for both formats added. Instead of pointing to a document, they point to the Google URL but they illustrate the same issues.
Comment 6 Regina Henschel 2022-05-14 22:19:13 UTC
Valid request.

Editing and creating new hyperlinks of this kind is missing.

The import has been implemented with 
https://cgit.freedesktop.org/libreoffice/core/commit/?id=92afb61d8bb1b264a945371065115981ecaed0f1
and
https://cgit.freedesktop.org/libreoffice/core/commit/?id=066bdb31f7ff801b7a36c79c43ecbd527ffb2a88

Currently the export produces invalid ODS and the extension is not documented. It is implemented as new attribute of <style:table-cell-properties> element.