Re: [libreoffice-users] Encoding issue when converting with LibreOffice headless

On Sat, Mar 5, 2011 at 3:42 PM, vzoukos <vzoukos@otenet.gr> wrote:
> On Ubuntu 10.04 LTS with LibreOffice (3.3 330m19(Build:8)) using the command
> line for conversion:
> $ libreoffice \
> -invisible \
> -headless \
> -norestore \
> -convert-to ods x.csv
> if the file x is a *.csv text file with encoding ISO8858-7 or UTF-8 the text
> in the resulting *.ods file is encoded in ISO8859-1. Any tips?

I tried out several variations of the above command and I see that it
is a general problem
that affects any non-ISO8859-1 script, such as Cyrillic, Latin
Extended, Arabic, Chinese, and so on.

Here is an example so that you can easily test. It's a CSV file with
Unicode text. The second row has the words aero and train with a
variety of accents.

$ cat /tmp/test.csv
"First","Second"
"áéŕó","ṫřåiṅ"
$ _

Let's run it through LibreOffice headless:

$ libreoffice -headless -convert-to ods /tmp/test.csv
convert /tmp/test.csv -> /tmp/GNOME-TM/test.ods using OpenDocument
Spreadsheet Flat XML
Warning: at xsl:stylesheet on line 2 of
file:///usr/lib/libreoffice/basis3.3/share/xslt/odfflatxml/odfflatxmlexport.xsl:
  Running an XSLT 1.0 stylesheet with an XSLT 2.0 processor
$

The resulting test.csv has the text

            <table:table-row table:style-name="ro1">
               <table:table-cell office:value-type="string">
                  <text:p>áéŕó</text:p>
               </table:table-cell>
               <table:table-cell office:value-type="string">
                  <text:p>ṫřåiṅ</text:p>
               </table:table-cell>
            </table:table-row>

What this means is that the XSLT transformation considered that the
input text had the iso-8859-1 encoding instead of being UTF-8.

Can anyone give a hint as to where to look to set the encoding or
perhaps change the default?
This looks to be an easy fix to LibreOffice, if we can find the source
of the problem.

Simos

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***