Apache OpenOffice (AOO) Bugzilla – Issue 108678
CSV can't recognise utf-8 format by BOF
Last modified: 2016-04-04 01:44:35 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.
Created attachment 67423 [details] sample UTF-8 csv-file.
Confirmed.
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.