Issue 117508 - Cannot import CSV file if first column is named ID
Summary: Cannot import CSV file if first column is named ID
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.3
Hardware: All All
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-22 14:27 UTC by torti.tommaso
Modified: 2013-01-29 21:44 UTC (History)
2 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

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