https://bugs.documentfoundation.org/show_bug.cgi?id=169591
Bug ID: 169591
Summary: FILEOPEN Content import from CSV does not work when
file is encoded UTF-16BE
Product: LibreOffice
Version: 7.0 all versions
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Opening a file of type CSV (comma separated values), encoded in UTF-16BE in
Calc ends up in a one lined table with asian letters. The format is chosen,
because the /huge competitor/'s spreadsheet does get along only with that.
The system gets along with it in the beginning: it offers the conversion with a
"Textimport" dialogue, where it properly identified the "Unicode (UTF-16)"
encoding and is able to resolve the columns and import the content. However,
after OK the only cell populated is A1 and it contains asian characters.
Steps to Reproduce:
1. Set up an arbitrary CSV file
2. Make sure, it is UTF-16BE encoded. I did it by converting a version in UTF-8
with the iconv tool: iconv -t UTF-16BE source.csv > target.csv
3. Open it with Calc
You are offered text import. Columns and content are decoded properly
4. Confirm the text import.
Actual Results:
Only A1 contains anything. It is mostly asian characters.
Expected Results:
Cells are populated as previsted in the text import dialogue.
Reproducible: Always
User Profile Reset: No
Additional Info:
Looks as if the 0x00 bytes of the UTF16 encoding somewhere get lost between
text import import and cell population.
--
You are receiving this mail because:
You are the assignee for the bug.
