Importing HTML table into OO Calc as UTF8 without

2019-03-30 04:24发布

站内文章 / 后端开发
60 0 0

问题:

I have a problem when opening a HTML table in OpenOffice or LibreOffice if it contains UTF8 extended characters like ÅÄÖåäö.

When opening the table into M$ Excel it works as intended but I can't make OO do the same thing.

By converting all extended characters to its HTML entity eqivalent Å etc. it works but it would be nice to get the correct characters directly.

Is there anyone who knows what I should do?

The following content I have in a file called excelsample.xls and if I open that with OO Calc it will not look nice.

<!DOCTYPE html>
<html>
<head>
    <title></title>
    <meta http-equiv="content-type" content="application/vnd.ms-excel" charset="UTF-8">
    <meta charset="UTF-8">
</head>
<body>
    <table>
        <tr>
            <td>Prawn sandwich</td><td>Räksmörgås</td>
        </tr>
    </table>
</body>
</html>

回答1:

Your meta tag is malformed and OO doesn't probably recognize the html5 charset tag.

So fix it with:

<meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8">


标签： utf-8 html-entities html-table openoffice-calc libreoffice
举报

收藏的人(0)

Ta的文章 更多文章
登录 后发表评论
0条评论
还没有人评论过~