I’m importing a cvs full of: date,time,URI,etc… into calc. I’d like the URIs (which point to documents) to be imported as clickable links, but the Fields>>Column-Type drop-down on the import dialogue doesn’t give that option. Otherwise, I’d like to be able to change the full imported column into hyperlinks, rather than being forced to do it one cell at a time, as with Insert >> Hyperlink.
The URI could either look like “file:///document-path” or just the path/filename.
Does anyone know how to do this? (Kind of new at this. Maybe it’s easy?)