https://bugs.documentfoundation.org/show_bug.cgi?id=149076
Bug ID: 149076
Summary: LibreOffice Calc: Support Excel hyperlinks not tied to
cells (feature request)
Product: LibreOffice
Version: 7.3.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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).
--
You are receiving this mail because:
You are the assignee for the bug.
