Issue 97869

Summary: Calc has problems opening csv files with Null characters
Product: Calc Reporter: camillem <cmoulin>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: aladdin, issues, marc.galmard, rainerbielefeld_ooo_qa
Version: OOo 3.0Keywords: oooqa
Target Milestone: ---   
Hardware: Unknown   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
CSV file with 2 Null characters none

Description camillem 2009-01-08 13:29:32 UTC 
OOo behaves strangely with csv files containing Null characters. 
Steps to reproduce :
1- Download the file "Test_case_with_2_null_chars.csv" attached to this issue
2- In OOo : File>Open
3 - Choose "CSV (*.csv, *.txt, *.xls, *.tsv) as file type
4- Browse your file system to select the aforementioned file and click Open.

Expected result : the dialog for CSV option should open
Actual result : the dialog for text file import in writer opens, then Writer
opens with the file imported as plain text

Oddly enough, if you double click on the file, it opens correctly in Calc.
But, with a larger file, double clicking it will result in it open in Writer,
without showing the dialog box for plain text import.
Comment 1 camillem 2009-01-08 13:34:17 UTC 
Created attachment 59237 [details]
CSV file with 2 Null characters
Comment 2 Rainer Bielefeld 2009-01-09 11:52:02 UTC 
I checked with "Ooo 3.0.0 (DE) Multilingual version German UI WIN XP: [OOO300m9
(Build9358)]" and can confirm the reported effect.
Same with "Ooo 3.1 Multilingual version German UI WIN XP: [DEV300m36 (Build
9369)]", "2.4.1  Multilingual version German UI WIN XP: [680m17(Build9310)]",
"1.1.4 (German) WIN XP: [645m52 (Build 8824)]" 

File will be opened fine from WIN Explorer.

We have several issues concerning this or similar problems:
Issue 49828 (WFM? I don' think so)
Issue 65460 (invalid?)
Issue 80393 (invalid)
Issue 93488 (might be something different with double semicolons and double quotes)

DUP of Issue 65460?
Comment 3 camillem 2009-01-09 14:56:56 UTC 
I've just read Issue 65460, and I think that both issue relate indeed to the
same problem, but please consider that csv files with Null chars might not be
corrupted files: some database exports render null values as null chars.