Bug 52542

Summary: csv files containing letter N imported incorrectly
Product: [Applications] calligrasheets Reporter: Caitrin Torres <caitrin>
Component: filtersAssignee: Ariya Hidayat <ariya>
Status: RESOLVED FIXED    
Severity: normal    
Priority: NOR    
Version: 1.2.1   
Target Milestone: ---   
Platform: unspecified   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:
Attachments: test file demonstrates broken "None" textquote import/insert

Description Caitrin Torres 2003-01-03 05:42:56 UTC 
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.
Comment 1 Per Winkvist 2003-04-26 17:46:47 UTC 
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....
Comment 2 bruce.lilly 2008-07-19 18:21:56 UTC 
Created attachment 26264 [details]
test file demonstrates broken "None" textquote import/insert
Comment 3 bruce.lilly 2008-07-19 18:29:53 UTC 
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.