Issue 93488

Summary: OO doesn't recognize CSV files having both semicolons and double quotes
Product: Calc Reporter: zakmck <zakmck>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: damjan, issues, rainerbielefeld_ooo_qa
Version: OOo 2.2Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
CSV files which is not recognized by OO
none
SORRY, REFER TO THIS AND NOT TO THE PREVIOUS ONE none

Description zakmck 2008-09-04 14:41:54 UTC 
A file with this line is not recognized when I try to open it with right click,
or with Open + selection of CSV format:

"Protocol Parameter"	""	""	""	""	"
Comment 1 zakmck 2008-09-04 14:55:15 UTC 
Sorry. Let's do it again... 

The attached file is a CSV with TAB as separator and double quotes as cell value
delimiter. Some values have semicolons characters inside. OO doesn't recognize
it correctly when I try to open it, either via right-click, or via Open File ->
Text/CSV format. 

Instead, if I create an empty spreadsheet and then I do "Insert spreadsheet from
file", I am being asked about the CSV options (separator and alike) and
eventually the file is correctly loaded. Therefore I guess it depends on
auto-guessing of format options, which is a feature I really would like it was
optional, with CSV options dialog in case I want to specify format variants.
Comment 2 zakmck 2008-09-04 14:56:37 UTC 
Created attachment 56239 [details]
CSV files which is not recognized by OO
Comment 3 zakmck 2008-09-04 14:59:04 UTC 
Created attachment 56240 [details]
SORRY, REFER TO THIS AND NOT TO THE PREVIOUS ONE
Comment 4 zakmck 2008-09-04 15:01:44 UTC 
Sorry for the mess. Correct version of the attachment is the second one. I am
using OO 2.4.1 for OS/X.
Comment 5 Rainer Bielefeld 2009-01-09 11:47:15 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)]" 

Will be opened with OOo after double click 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)

@zakmck,
great idea to use the same name for all sample files with different behaviour,
that really makes it easy for us to fins out what happens ;-)
Comment 6 Rainer Bielefeld 2009-01-09 11:53:13 UTC 
And NEW
Comment 7 damjan 2016-05-30 16:42:54 UTC 
With the first 129 characters in the sample file or less, the CSV import dialog is brought up. With 130 or more characters, we get the ASCII filter dialog instead.

Character 130 is a null (0), but not the first nor the only in the file.

Interestingly, a file made of 2 nulls (head -c 2 /dev/zero > /tmp/file.csv) is also opened in the ASCII filter dialog.