I have CSV that contains http://pastebin.com/EH8vuBe1 that text. First column is hyperlink. Not recognized as hyperlinks.
When i click on A2 cell and edit ( add space at end ) clickable blue hyperlink appears. I have lots of rows in CSV, i dont do that manually. Any help, advice or is it bug ?
Why CSV? Calc and other spreadsheet applications are designed for a LOT of things a simple data-exchange format as CSV isn’t capable of.
If I create a Calc document, save it “as CSV” and continue using it under Calc, it WILL still recognise URL. Saving it again as CSV the linkage will be lost as expected. File reloaded I see the result.
After entering an URL the process recognising it is triggered by typing a delimiter (mostly space) or by ENTER. If you ‘Paste Special’ an URL with option ‘Text only’. No link will be created. (Editing: Couldn’t reproduce this. Consider the statement in Italic deleted.)
For creating clickable links AFTER import there is the function HYPERLINK().
Please attach a (minimised) functional example file instead of an image in such a case. Much easier so to avoid misunderstanding.
1, CSV file IS source file for import https://i.nyx.cz/files/00/00/12/07/1207978_344db80855d47f7999b4.csv?name=data.csv
2, when opened csv dialog appears. i select “|” as delimiter and import into table. Save as ODS.
3, first column not recognized as hyperlinks, just as text. Expect conversion to clickable blue hyperlinks
ad 3. … Why do you expect the conversion? I won’t. By the way: How do you edit (rectify) URL once recognised and in consequence shown as a text-field like ONE character?
You may use the HYPERLINK() function like “=HYPERTEXT(A1;A1)” in, say Z1, and you will get a clickable link though not emphasised as you want.
Sorry! How to trigger the URL recognition without entering the cells and performing any editing I don’t know. Hope you find a way or get a hint by someone else.
If you are interested in a work-around:
Define a cell style faking the hyperlink outfit (Backgroung Grey30%, Font colour Blue6) and name it, say ‘ColouredHyperlink’. Apply the HYPERLINK() function then together with the STYLE() function like “=HYPERLINK(A1)&T(STYLE(“ColouredHyperlink”))” T() does return the (empty) text value of STYLE() result and thus the style gets applied without appending anything.
Subsequently you may hide the original import.
Autohotkey saves
Loop, 1720
{
Send {F2}
Send {Space}
Send {Enter}
Sleep 10
}