Issue 108678 - CSV can't recognise utf-8 format by BOF
Summary: CSV can't recognise utf-8 format by BOF
Status: RESOLVED FIXED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.1.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: ooo
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-01-26 14:13 UTC by sailormax
Modified: 2016-04-04 01:44 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
sample UTF-8 csv-file. (113 bytes, text/csv)
2010-01-26 14:21 UTC, sailormax
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description sailormax 2010-01-26 14:13:49 UTC
Open Office are ignored UTF-8 signature (BOF), when a user tries to open a CSV-
file, and asks him to select encoding. The default value is the system settings.

In addition, Open Office does not write UTF-8/Unicode (BOF) signature, when a 
user saves a multilingual document in CSV-file.
Comment 1 sailormax 2010-01-26 14:21:17 UTC
Created attachment 67423 [details]
sample UTF-8 csv-file.
Comment 2 ooo 2010-01-27 17:08:00 UTC
Confirmed.
Comment 3 damjan 2016-04-04 01:44:35 UTC
While I can confirm this bug in AOO 3.2, it must have been fixed some time after. On 4.2.0-dev AOO does do autodetection of UTF-8 vs UTF-16 vs ASCII, in sc/source/ui/dbgui/scuiasciiopt.cxx method ScImportAsciiDlg::ScImportAsciiDlg() using the mpDatStream->StartReadingUnicodeText() method, and I verified that the attached file's encoding is successfully autodetected as UTF-8 on both Windows and FreeBSD: the default "Character set" value is now "Unicode (UTF-8)", not "System".

Resolving fixed.