John Davidson

xlsx - php XLSXWriter - links only appearing sometimes?

0 comments
Message:


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

3 of 5 based on 6581 votes

Comments




© 2024 Hayatsk.info - Personal Blogs Platform. All Rights Reserved.
Create blog  |  Privacy Policy  |  Terms & Conditions  |  Contact Us