I am struggling to save text as a hyperlink in Excel. I tried using this formula:
=HYPERLINK("http://www.1spatial.com/fme","http://www.1spatial.com/fme")
However, the outcome in Excel didn’t work as expected.
Does anyone have any idea why it behaves this way?
Make sure that you’re using the correct nomenclature for writing formulas and not text:
<attributename>.formula
This means if your output attribute is called “my_url”, then you need to write your formula in “my_url.formula”
Expand the “Formulas” section here for more info: https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/xlsx/XLSX_writer.htm