I am working with XLSXWriter - https://github.com/mk-j/PHP_XLSXWriter
When I am creating links, I am writing it like:
=HYPERLINK("%s", "%s")',$url,$value
When I view the resulting file in google sheets, I get a wee link like this:
A cell containing the letter A, it is underlined and blue.
Explicitly a link, blue underline, I didn't have to do any styling to get it looking like this.
However, in excel and libreoffice, This just looks like text.
I can control click it and it works like a link, the cell value has the hyperlink format in it, but it just looks like a regular letter in the cell.
Regular letter A - no format
Is there a parameter I'm missing? a style I need to apply? This is an issue that others are seeing when they download this xlsx file - it needs to be obvious it is a link to the users. What am I missing to make this link explicit always, not sometimes?
My Answer:
"www.example.com", "Click here")_
However, I have noticed that the links only appear sometimes in the generated Excel file. Is there a specific reason for this behavior?
Rate this post
5 of 5 based on 6998 votesComments