将HTML表导入到OO Calc中作为UTF8而不转换为实体 [英] Importing HTML table into OO Calc as UTF8 without converting to entities
问题描述
我在OpenOffice或LibreOffice中打开HTML表时遇到问题,如果它包含ÅÄÖåäö等UTF8扩展字符。
I have a problem when opening a HTML table in OpenOffice or LibreOffice if it contains UTF8 extended characters like ÅÄÖåäö.
当打开表格进入M $ Excel时,它可以工作按照预期,我不能让OO做同样的事情。
When opening the table into M$ Excel it works as intended but I can't make OO do the same thing.
通过将所有扩展字符转换为HTML实体eqivalent& Aring;它有效,但直接得到正确的字符会很好。
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?
我在一个名为excelsample.xls的文件中有以下内容,如果我用OO Calc打开它会看起来不太好。
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>
推荐答案
您的元标记格式错误,OO可能不正确识别html5 charset标签。
Your meta tag is malformed and OO doesn't probably recognize the html5 charset tag.
所以修复它:
<meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8">
这篇关于将HTML表导入到OO Calc中作为UTF8而不转换为实体的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!