I’m working on editing a script (Like a text script not a programming script) for a game that uses csv files. If I changed it to odt the game wouldn’t recognize the script file.
This is a super long document, and I wanted to organize it a bit so I can work faster, so I decided to add hyperlinks leading to specific rows that are at the start and end of different sections of the script. I used Insert-Hyperlink and targeted the lines I wanted to make a labelled list of clickable rows at the bottom of the document. It worked fine until I saved and reopened it. As soon as I did, all the hyperlinks were removed (The text was still there, but it wasn’t blue and underlined and I couldn’t click on it). I did some research and it seems that this is because csv files are pretty basic and don’t save hyperlinks. I found out about the HYPERLINK() function, but after looking into functions for a while I still have no idea how to actually put one into my document and make it clickable.
Anyone have any advice?
You already found .csv can not really support hyperlinks, but it is possible to use a formula with some precautions. Assume we have the formula =HYPERLINK("http://ask.libreoffice.org";"Ask") in a cell.
.
Now “Save As” .csv and select then check box to edit filter options.
Activate the checkbox at the bottom to save formulas instead of calculated values.
.
Check the .csv, if you like, with a text editor: You should find something like "=HYPERLINK(""http://ask.libreoffice.org"";""Ask"")"
.
As a last step open the .csv in Calc again. When the dialog for import opens search the last checkbox in further options and activate it. It is to evaluate formulas.
(Tried with LibreOffice 7.4.7.2)
.
If you use this a lot it may be worth to record a macro for saving in this .csv-format to avoid forgetting the checkboxes…