Issue 117508 - Cannot import CSV file if first column is named ID
Summary: Cannot import CSV file if first column is named ID
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:
Depends on:
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: ---


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: 

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.

* 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
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.