[Feature Request]: Add support for hyperlinks

[genadis]

Problem to solve
Currently there seems to be no way to add hyperlinks
(http://officeopenxml.com/WPhyperlink.php)

Proposed solution
Add option to write to document.xml.rels via formatter context. So we would be able to implement hyperlinks.

Describe alternatives you've considered
I've considered implementing via formatter similar to convCRLF(). But hyperlinks require writing Relationship to document.xml.rels.

[NestorPerez13]

I have the same problem, i need to add an hyperlink to an excel sheet, firstly it appear like this:

As soon as i click ok, excel escapes the URL and it appear like this:

Carbone is unable to parse that "hyperlink", however the visible text in the cell is correct, if someone knows a workaround to solve this i would appreciate.

[steevepay]

@NestorPerez13 It is not possible yet to apply hyperlinks to an XLSX/ODS template.
We are investigating the proposed solution from @genadis.
Hold on, we will come back to you.

[steevepay]

To let you know, the next version of Carbone will support hyperlinks with ODS and ODT files.
At this moment, there is some limitations with DOCX and XLSX.

[genadis]

@steevepay great news!
Are there plans for DOCX and XLSX? or add option to write to document.xml.rels via formatter context?

Thanks!

[steevepay]

Carbone is writing to the file document.xml.rels but the feature needs to be improved to support lists of hyperlinks for DOCX and XLSX (for example the screenshot of @NestorPerez13).

[steevepay]

Dynamic hyperlinks are available since the v3.0.0 for Carbone Enterprise Edition, here is the documentation:
https://carbone.io/documentation.html#dynamic-hyperlinks

[rriemann]

I thought of using Carbone to generate GDPR audit reports. So can you confirm that I cannot use Carbone free software to place a clickable URL from JSON in an odt file?

Our reports are sensitive, so that using free software on premise is a big plus.