Issue 97869 - Calc has problems opening csv files with Null characters
Summary: Calc has problems opening csv files with Null characters
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.0
Hardware: Unknown Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2009-01-08 13:29 UTC by camillem
Modified: 2013-01-29 21:49 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

CSV file with 2 Null characters (200 bytes, text/csv)
2009-01-08 13:34 UTC, camillem
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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.