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).
Typo: *symlink -> hyperlink
Please attach minimal sample XLSX and XLS if supported.
Created attachment 180120 [details] XLSX hyperlink minimal document
Created attachment 180121 [details] XLS hyperlink minimal document
(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.
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.