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: 184.108.40.206 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.
opens fine for me with
Win7x64 - LibreOffice 220.127.116.11
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 18.104.22.168
> Attached screenshot of import window that works for me.
> Please could you attach a screenshot of import window, to try with the same
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.
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).
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: 22.214.171.124.alpha2+
Build ID: 5bff4b016c4b44f4123e0e6a4fd4c0c4dc0cfa2d
TinderBox: Linux-rpm_deb-x86_64@46-TDF-dbg, Branch:master, Time: 2014-11-13_00:14:29
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.
Dear Bug Submitter,
This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to regular bug
tracker maintenance, if the bug is still in NEEDINFO status with
no change in 30 days the QA team will close the bug as INVALID
due to lack of needed information.
For more information about our NEEDINFO policy please read the
wiki located here:
If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.
Thank you for helping us make LibreOffice even better for everyone!
This NEEDINFO Message was generated on: 2015-06-08
I hit this problem the first time I tried to open a CSV file using 126.96.36.199 .
It seems that when the product is shipped the character set defaults to UTF-16. Once you change it to UTF-8 it becomes the default and everything works.
The question is what should the product be shipped with? I noticed that there is an option of 'System' which also works but I do not know what it really means. Would it be a better default to ship with?
Changing back to unconfirmed due to comment 11 so this doesn't fly under the radar.
Duplicate of bug 88909 ?
*** This bug has been marked as a duplicate of bug 82418 ***