Problem description: When attempting to open a 667kB CSV file the preview shows only one line with a few Chinese characters at the beginning followed by probably invalid Unicode characters. None of the characters are part of the CSV file and LibreOffice tested is a US English version which is not expected to display any Chinese messages. Steps to reproduce: 1. Download a test CSV file from http://real-chart.finance.yahoo.com/table.csv?s=IBM&d=8&e=25&f=2014&g=d&a=0&b=2&c=1962&ignore=.csv 2. Save test file as "IBM.csv" 3. Open "IBM.csv" with LibreOffice to see effects stated above Current behavior: When actually attempting to import the CSV data the following popup message is produced: "The data could not be loaded because the maximum number of characters per cell was exceeded". Then LibreOffice becomes almost unresponsive. Expected behavior: CSV text data should be converted and displayed as spreadsheet after selecting the appropriate separator. Operating System: openSUSE Version: 4.3.1.2 release
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.