I have a Writer table that has adjacent columns containing a sequence number and a URL hyperlink. I need to combine the two so that the sequence number becomes the visible text for the hyperlink, and the column containing the original hyperlink is removed. Is it possible to automate this, or do it in one go, as there are too many rows to do this “by hand”. Or should/could this be done after converting the table to a spreadsheet?
@Mycroft1 It is easiest to do this in a spreadsheet but you would have to keep it as a spreadsheet.
To automate it in Writer I think that you would need to use macros but I could not help you with that
Copy the Writer table into Calc.
Assuming that Cell A1 contains your first sequence number and cell B1 contains the first hyperlink, then in cell C3 enter =HYPERLINK(B1;A1). Drag the formula down or copy and paste it into the remaining cells. Ctrl+click to follow the link. If you export it to pdf the links will be clickable.