Bug 117146 - Saving as .csv corrupts unicode characters
Summary: Saving as .csv corrupts unicode characters
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.3.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-04-21 16:27 UTC by 2niekai
Modified: 2018-04-22 10:29 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description 2niekai 2018-04-21 16:27:19 UTC 
Description:
Saving file as .csv automatically encodes it in ANSI, and does not show unicode characters, like Č or Ė.

Steps to Reproduce:
1. Create a calc document with characters 
2. Save file as .csv
3. Open .csv in text editor

Actual Results:  
Č, Ė, and probably more unicode characters appear as "?". 

Expected Results:
obvious :)


Reproducible: Always


User Profile Reset: No



Additional Info:
Marking all hardware with Windows, however, I suspect this is standard behaviour which would reproduce also in other operating systems.


User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0
Comment 1 V Stuart Foote 2018-04-21 17:53:15 UTC 
The save-as export allows selection of the Character set when the "edit filter settings" box is checked. Otherwise the CSV will be saved with the character set  in use. Select Unicode (UTF-8) or (UTF-16).

Likewise, on import the character set encoding can be selected, and then a font selection made in Calc for correct/prefered rendering of the Unicode glyphs.
Comment 2 2niekai 2018-04-22 10:29:23 UTC 
Thanks V Stuart Foote, I have not looked at "filter settings", as it didn't seem related to encoding..