Summary: | FILEOPEN: CSV File creates garbled preview and almost freezes LibreOffice | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | bugmenot <bugmenot> |
Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEEDINFO --- | QA Contact: | |
Severity: | normal | ||
Priority: | medium | CC: | guilleron29, qubit, todventtu |
Version: | 4.3.1.2 release | ||
Hardware: | x86-64 (AMD64) | ||
OS: | Linux (All) | ||
Whiteboard: | BSA | ||
i915 platform: | i915 features: | ||
Attachments: |
Screenshot of import window.
Better have a look at this one (Linux 64bit) |
Description
bugmenot
2014-09-25 22:01:27 UTC
Opening the CSV file with a text editor to copy and paste the text into an empty LibreOffice spreadsheet seems to be a suitable workaround. Created attachment 106878 [details]
Screenshot of import window.
Hi bugmenot,
opens fine for me with
Win7x64 - LibreOffice 4.3.2.1
Attached screenshot of import window that works for me.
Please could you attach a screenshot of import window, to try with the same options.
(In reply to comment #2) > Created attachment 106878 [details] > Screenshot of import window. > > Hi bugmenot, > > opens fine for me with > Win7x64 - LibreOffice 4.3.2.1 > > Attached screenshot of import window that works for me. > > Please could you attach a screenshot of import window, to try with the same > options. Configurations are not comparable: You are running 32-bit software on 64 bit Windows, while my version of LibreOffice is 64 bit (on OpenSuse Linux). Created attachment 107130 [details]
Better have a look at this one (Linux 64bit)
LibreOffice for Windows apparently seems to work, while The 64 bit variant for Linux does not.
Hi bugmenot, Did you try to change Character set in your Import wndows, something like Western Europe, to see what happens to this table and not to have Chinese characters. Next, check also Detect special numbers to have dates formated as date format, and numbers formated a Numbers formated as general numbers (not as text). Jacques Thanks to the comments of Jacques Guilleron I have recognized that LibreOffice had defaulted to UTF-16 for text import from a CSV file. Changing this to UTF-8 or ISO-8859-1 is initially necessary to import contents properly. There is no problem, however, if the UTF-16 character set is selected while pasting the same contents from the clipboard. This is albeit the text import window looks identical to the one during CSV file import. For me on 64-bit Ubuntu, it offers UTF-8 right away. Dare I suggest we close this as WORKSFORME? What do you think, bugmenot? Ubuntu 14.10 64-bit Version: 4.4.0.0.alpha2+ Build ID: 5bff4b016c4b44f4123e0e6a4fd4c0c4dc0cfa2d TinderBox: Linux-rpm_deb-x86_64@46-TDF-dbg, Branch:master, Time: 2014-11-13_00:14:29 Version: 4.3.3.2 Build ID: 430m0(Build:2) (In reply to Beluga from comment #8) > For me on 64-bit Ubuntu, it offers UTF-8 right away. Dare I suggest we close > this as WORKSFORME? What do you think, bugmenot? Status -> NEEDINFO bugmenot: Is it still suggesting UTF-16 to you? If so, please leave a comment and change status to UNCONFIRMED. If not, let's change status to RESOLVED WORKSFORME. |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.