Hi,
I have written an sql query to export some data from a mysql database. Since it includes a hyperlink I have made mysql output it like =HYPERLINK(“http://example.com/etc”).
Now when I open the file, everything is okay except the links: they appear in the spreadsheet as if it was not a function. If I add a space at the end (or edit the line in some other way) however, the link becomes functional as it is supposed to be.
How can I fix this?
Thanks and regards, G-.
Ask one of the cells containing such a formula =ISTEXT(TheCell), and you will get TRUE answered. Ask =ISFORMULA(TheCell), and the answer will be FALSE. (You can also use ‘Value Highlighting’, Ctrl+F8.) How, and in what format did you create the file later opened with Calc?
Change the format of all the afflicted cells to a ‘Numbers’ format like ‘General’ and use the tool >‘Data’ > ‘Text to Columns…’ , one column at a time, with 'Column Type ‘Standard’ to trigger a recognition (compilation) of the formula.