Created attachment 747523 [details] sample files archive for testing. Description of problem: Converting an xls file to csv through calc displays csv file in oocalc in Chinese/Japanese chars when opened in Unicode, which is default, but same displays normal ( i.e in English ) when opened in oocalc in ISO-8859-15/EURO Version-Release number of selected component (if applicable): Libre Officelibref_array.x86_64 0.1.3-12.fc18 @anaconda libreoffice-calc.x86_64 1:3.6.6.2-5.fc18 @updates libreoffice-core.x86_64 1:3.6.6.2-5.fc18 @updates libreoffice-draw.x86_64 1:3.6.6.2-5.fc18 @updates libreoffice-graphicfilter.x86_64 1:3.6.6.2-5.fc18 @updates libreoffice-impress.x86_64 1:3.6.6.2-5.fc18 @updates libreoffice-kde.x86_64 1:3.6.6.2-5.fc18 @updates libreoffice-langpack-en.x86_64 1:3.6.6.2-5.fc18 @updates libreoffice-math.x86_64 1:3.6.6.2-5.fc18 @updates libreoffice-opensymbol-fonts.noarch libreoffice-pdfimport.x86_64 1:3.6.6.2-5.fc18 @updates libreoffice-presenter-screen.x86_64 libreoffice-ure.x86_64 1:3.6.6.2-5.fc18 @updates libreoffice-writer.x86_64 1:3.6.6.2-5.fc18 @updates libreoffice-xsltfilter.x86_64 1:3.6.6.2-5.fc18 @updates libreport.x86_64 2.1.2-2.fc18 @updates libreport-fedora.x86_64 2.1.2-2.fc18 @updates libreport-filesystem.x86_64 2.1.2-2.fc18 @updates libreport-gtk.x86_64 2.1.2-2.fc18 @updates libreport-newt.x86_64 2.1.2-2.fc18 @updates libreport-plugin-bugzilla.x86_64 2.1.2-2.fc18 @updates libreport-plugin-kerneloops.x86_64 2.1.2-2.fc18 @updates libreport-plugin-logger.x86_64 2.1.2-2.fc18 @updates libreport-plugin-reportuploader.x86_64 libreport-plugin-ureport.x86_64 2.1.2-2.fc18 @updates libreport-python.x86_64 2.1.2-2.fc18 @updates libreport-web.x86_64 2.1.2-2.fc18 @updates How reproducible: Steps to Reproduce: 1. 2. 3. Actual results: Expected results: Additional info: attaching files for your testing.
May happen if "Unicode" (without utf-8) was selected as then the bytes are read as UTF-16 pairs. Select "Unicode UTF-8" instead. IIRC the selection is remembered for the dialog so this should be needed only once.