| Summary: | When opening a CSV file, some cryptic characters appears in the filter dialog | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | collette <ycollette.nospam> |
| Component: | filters and storage | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | bobgus, cno |
| Priority: | medium | ||
| Version: | 4.1.0.4 release | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
The problematic file
the import dialog with the cryptic text |
||
Hi Colette, thanks for your report. However, I cannot reproduce the problem on my Ubuntu computer. I do File > Open, select the file, and select type text filter. And it simply shows the numbers in the import dialog. Do you follow those same steps (probaly yes.) So, seems to be a windows only problem. I use Libreoffice 4.1 on Windows 7 64 bits. YC Please attach a screenshot. Do you choose 'CSV text' format manually in the Open dialog? No, I didn't select 'CSV text' when I opened the file. Created attachment 83888 [details]
the import dialog with the cryptic text
If I select 'CSV Text' and open the problematic file, the result is the same. YC Just choose a proper encoding. *** Bug 68951 has been marked as a duplicate of this bug. *** (In reply to comment #8) > *** Bug 68951 has been marked as a duplicate of this bug. *** Ahh yes. The critical information is in Comment #7 - "choose proper encoding". This selection is available at the top of the Text Import dialog. File->Open->Select your CSC file on the Open dialog->Click Open Now the Text Import dialog opens. You can set the Separator Options; Tab, Comma, Semicolon. More importantly, at the top of the Text Import dialog, you can select the Character set. Fortunately for me, Unicode (UTF-8) is one of the choices. With UTF-8 selected, voile - I can see my umlauts. Why are you sending this to me? On Nov 21, 2013, at 14:29, bugzilla-daemon@freedesktop.org wrote: > Michael Stahl changed bug 67936 > What Removed Added > Attachment #83875 [details] mime type text/plain text/csv > > You are receiving this mail because: > • You are on the CC list for the bug. |
Created attachment 83875 [details] The problematic file When I tried to open a simple CSV file, some cryptic characters appears in the import dialog. This file is totally readable in a text editor. To import it, I must open the file in a text editor and then paste it in libreoffice calc. This way, the filter dialog representes correctly the data and imports these data without problems.