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
I need to support hyperlinks. I'm thinking of making a PR for it, but this will probably take a while and I'm not sure how to support cells that contain hyperlinks and normal text at the same time (though I don't personally need it, that seems allowed in the spec).
For anyone looking for a quick fix, you can use the HYPERLINK function like [{:formula, "HYPERLINK(\"#{url}\", \"#{url}\")"}].
So for now I'll just leave this issue here of how they look like in the XLSX:
In the sheet$n.xml row, the hyperlink is referenced via r, like r=C8.
In the sheet$n.xml, in the <workbook/> tag this section:
I need to support hyperlinks. I'm thinking of making a PR for it, but this will probably take a while and I'm not sure how to support cells that contain hyperlinks and normal text at the same time (though I don't personally need it, that seems allowed in the spec).
For anyone looking for a quick fix, you can use the
HYPERLINK
function like[{:formula, "HYPERLINK(\"#{url}\", \"#{url}\")"}]
.So for now I'll just leave this issue here of how they look like in the XLSX:
In the
sheet$n.xml
row, the hyperlink is referenced viar
, liker=C8
.In the
sheet$n.xml
, in the<workbook/>
tag this section:In
worksheets/_rels/sheet$n.xml.rels
is this content:I'm not entirely sure how the code for a cell should look like, given that hyperlinks can be mixed with other content.
The text was updated successfully, but these errors were encountered: