Apache OpenOffice (AOO) Bugzilla – Issue 97869
Calc has problems opening csv files with Null characters
Last modified: 2013-01-29 21:49:23 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.
Created attachment 59237 [details] CSV file with 2 Null characters
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?
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.