Version: 1.2.1 (using KDE 3.1.0 (RC5)) Installed from: (3.0) Compiler: gcc version 2.95.4 20011002 (Debian prerelease) OS: Linux (i686) release 2.4.18-bf2.4 I have a plain ascii, pipe-separated file.Here are two sample lines: 175|j/jeanine|Jeanine||| 176|n/nsmith|Smith, Nick||| When I try to open it with KSpread, using the settings Delimiter: | and Textquote: None, lines such as the first that do not contain a capital N are imported just fine. Lines such as the second that do contain a capital N are not imported correctly. I get a 176 in the first column, n/nsmith in the second column, but then the third column says ick||| where I would expect it to say Smith, Nick. In other words, everything in that field up to and including the N is deleted, and the rest of the fields on that line aren't processed. The file is full of names so there's lots of capital letters. The only lines that have problems are the ones that include capital N's. I've tried using a semicolon as the separator adn I've tried putting text after the three pipes at the end of each line. There is no difference.
Subject: Re: csv files containing letter N imported incorrectly Thank you for your bug report. The bug that you reported has been identified and has been fixed in the latest development (CVS) version of KDE. The bug report will be closed. This took *way* to long....
Created attachment 26264 [details] test file demonstrates broken "None" textquote import/insert
This is *NOT* fixed; it remains as a bug as of Kspread 1.6.5 using KDE 3.5.9 release 65.1 on openSuSE. To replicate: 1. launch Kspread, select blank worksheet 2. place cursor in upper left cell 3. on the "Insert" menu, select "External Data" and "From Text File..." 4. open test.csv text file 5. on "Inserting Text File" dialog, select the archaic name "Tabulator" for tab character delimiter, Format "Text", 'Textquote:' "None", and Start at line 1 6. observe data corruption, evident in dialog window even before selecting "OK" or "Cancel" 'Textquote' "None" appears to attempt to use the letter 'N' (first letter of "None") as a delimiter.