You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
does the package support hyperlinks created using variables?
For example I have a column where I create a string using the Excel HYPERLINK formula, something like =HYPERLINK("{{url}}","{{display_text}}") but this does not act as a hyperlink (i.e. does not open the link) when I open the rendered Excel workbook. If I edit the workbook and press Enter on each cell then it converts to a proper hyperlink.
I have a workaround where I use OpenPyXL to convert each of these cells to a hyperlink after rendering the workbook, but it would be nice if I could do this directly in xltpl.
thanks.
The text was updated successfully, but these errors were encountered:
Hi,
does the package support hyperlinks created using variables?
For example I have a column where I create a string using the Excel HYPERLINK formula, something like =HYPERLINK("{{url}}","{{display_text}}") but this does not act as a hyperlink (i.e. does not open the link) when I open the rendered Excel workbook. If I edit the workbook and press Enter on each cell then it converts to a proper hyperlink.
I have a workaround where I use OpenPyXL to convert each of these cells to a hyperlink after rendering the workbook, but it would be nice if I could do this directly in xltpl.
thanks.
The text was updated successfully, but these errors were encountered: