In LibreOffice Calc, How To Access Raw HTML in a Cell?

Question

I have a LibreOffice Calc spreadsheet that has a column with HTML formatting in it, including links. There is some data in the HTML that I need to preserve and extract. This would be easy to do if I could access the raw HTML, but I cannot figure out how to access the raw HTML within LibreOffice itself, nor can I figure out how to export it.

I would ideally like to find a solution of some sort of formula or function I could place in a new column, which would make that column display the raw HTML so that I can work with it using basic string operations. Alternatively if there is some sort of in-app command like a change of formatting in the menu or a way to use "Paste Special..." to view the HTML, I could do that too.

Failing this, I could settle for a solution that would preserve the raw HTML when exporting the data to CSV format or some other easily-parsable format. I have unfortunately not figured out how to do this either; when I export to CSV the HTML formatting is lost.

As a last resort I would be open to a custom macro using basic but I would rather find a simpler solution.

I have also tagged this as OpenOffice because I suspect this question may only be relevant to aspects of LibreOffice that have not changed from OpenOffice, although if this is not the case I would be interested to know about it!