Strip html taged elements from libre spreadsheets

Converting a libra spreadsheet into a csv is fine however you then lose the link which is connected with the bit of text in the cells. This is a group of functions which will help strip these out prior to converting to CSV.

To use the Cell_url function which will grab the link from the given cell use..

=CELL_URL(“sheet1”, ROW(),COLUMN()-3)

Sheet1 is the name of the give sheet make sure you use double quotes as singles break it.

Row is the current row that the formula is on

column() -3 is the column that the formula is currently on -3 spaces.