Issue 117508

Summary:	Cannot import CSV file if first column is named ID
Product:	Calc	Reporter:	torti.tommaso
Component:	open-import	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Normal
Priority:	P5 (lowest)	CC:	issues, ooo
Version:	OOo 3.3
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description torti.tommaso 2011-03-22 14:27:05 UTC

1) create a csv file with this content: 
ID;NAME
1;a

2) open it with open office (i tried with version 3.3.0 and 3.1.0 in Mac OS X version 10.5.8): you can see Open Office cannot recognize it as a csv file.

Notes: 
* if the first column is named 'Id' or 'id' all is ok. Only the string 'ID' in upper case is wrong.

Comment 1 ooo 2011-03-22 14:59:39 UTC

Hey, cool ;) Apparently the sequence
ID;N
is taken as a signature for SYLK files and that filter is used instead.
It also helps to use , comma as the field separator instead of ; semicolon.

Comment 2 Oliver-Rainer Wittmann 2012-06-13 12:17:49 UTC

getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.