+9I 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?
Best answer by david_r
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
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
