Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I have nothing written about changing the extension. First select the file, so that it is in the file name field. Then click on Button "All files". That opens the filter drop down list. Select "Web Page Query (Calc)" or "Html Document (Calc)". One of them will likely work. If not, please provide an example file.

I have nothing written about changing the extension. Start LibreOffice, then use File > Open. First select the file, so that it is in the file name field. Then click on Button "All files". That opens the filter drop down list. Select "Web Page Query (Calc)" or "Html Document (Calc)". One of them will likely work. If not, please provide an example file.

I have nothing written about changing the extension. Start LibreOffice, then use File > Open. First select the file, so that it is in the file name field. Then click on Button "All files". That opens the filter drop down list. Select "Web Page Query (Calc)" or "Html Document (Calc)". One of them will likely work. If not, please provide an example file.

I have examined the files now. They are neither correct HTML nor XML. But they contain only a fragment from an Html body. You cannot use the "Html Document (Calc)"-filter, because it is not a complete Html file. You would need to embed the content

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
        "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8">
<title>Dummy Title</title>
</head>
<body>
             Here your file content
</body>
</html>

It is a missing feature of Calc, that it cannot handle Html-fragments. I suggest you write a feature request, that files containing Html-tables are imported to Calc, when the appropriate filter is chosen, even in case they do not have a complete Html source.

Writer gets the encoding correct in both cases, when you use the HTML filter for Writer or for Writer/Web. So in Writer there is no need to change any encoding.