Importing HTML table into OO Calc as UTF8 without converting to entities

Question

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>

The meta tag should be <meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8">. Try fixing that — Esailija
– Esailija, Commented Jan 7, 2013 at 16:06

Esailija · Accepted Answer · 2013-01-07 16:18:23Z

12

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">

answered Jan 7, 2013 at 16:18

Esailija

140k24 gold badges280 silver badges328 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

tony gil Over a year ago

bullseye! UPVOTED! :)

Robert Muil Over a year ago

Thank you so much! This applies to websites downloaded from Wikipedia, so very relevant.

Collectives™ on Stack Overflow

Importing HTML table into OO Calc as UTF8 without converting to entities

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related