Bug 1303781
| Summary: | libreoffice calc and math appears to translate csv to some other Asian in appearance (to me) language | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Product: | [Fedora] Fedora | Reporter: | morgan read <mstuff> | ||||||||||
| Component: | libreoffice | Assignee: | Caolan McNamara <caolanm> | ||||||||||
| Status: | CLOSED NOTABUG | QA Contact: | Fedora Extras Quality Assurance <extras-qa> | ||||||||||
| Severity: | unspecified | Docs Contact: | |||||||||||
| Priority: | unspecified | ||||||||||||
| Version: | 22 | CC: | caolanm, dtardon, erack, ltinkl, mstahl, sbergman | ||||||||||
| Target Milestone: | --- | ||||||||||||
| Target Release: | --- | ||||||||||||
| Hardware: | Unspecified | ||||||||||||
| OS: | Unspecified | ||||||||||||
| Whiteboard: | |||||||||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||||||||
| Doc Text: | Story Points: | --- | |||||||||||
| Clone Of: | Environment: | ||||||||||||
| Last Closed: | 2016-02-02 08:33:40 UTC | Type: | Bug | ||||||||||
| Regression: | --- | Mount Type: | --- | ||||||||||
| Documentation: | --- | CRM: | |||||||||||
| Verified Versions: | Category: | --- | |||||||||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||||||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||||||||
| Embargoed: | |||||||||||||
| Attachments: |
|
||||||||||||
Created attachment 1120273 [details]
libreoffice Calc/ Math csv import window
Created attachment 1120274 [details]
csv imported into libreoffce Calc
Created attachment 1120275 [details]
ods file created by csv import
attachment 1120273 [details] shows that you chose "Unicode (UTF-16)" as character set, you should switch that to a single-byte ASCII superset that actually matches your input file's encoding, "Unicode (UTF-8)"
Oops - buy why isn't libreoffice adopting the system/ user character coding - is that the bug? Never had to think about that before. (In reply to morgan read from comment #5) > Oops - buy why isn't libreoffice adopting the system/ user character coding > - is that the bug? Never had to think about that before. I very much assume that you accidentally happened to switch that setting in the dialog once to UTF-16 (from UTF-8, presumably), by some unintentional keyboard or mouse interaction. I'm not aware how we would ever preselect UTF-16 here. It might had happened when opening a file with a UTF-16 BOM, or if content starts with 16-bit values where the high byte represents a control character other than CR,LF,TAB, in which case Unicode UTF-16 is assumed and selected. And the settings are remembered and preselected for the next file to be opened. Thanks Eike, sounds plausible :) M |
Created attachment 1120260 [details] csv file imported into libreoffice Calc or Math Description of problem: Import CSV and get Chinese/ Japanese (Asian looking, my apologies for any misplaced assumptions) characters!!! Version-Release number of selected component (if applicable): $ rpm -qa libreoffice libreoffice-4.4.7.2-1.fc22.x86_64 How reproducible: Always since I started using f22 from f20 about the New Year Steps to Reproduce: 1. Have CSV 2. Import into Calc or Math 3. Get really weird stuff Actual results: Really weird stuff - Asian appearing characters all in cell A:1 Expected results: Sensible spreadsheet Additional info: Attached screen shots and original csv