Issue 98611 - Insert sheet from file: Considers file suffix rather than content
Summary: Insert sheet from file: Considers file suffix rather than content
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.2.1
Hardware: Mac Mac OS X, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-01-29 15:10 UTC by porg
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description porg 2009-01-29 15:10:50 UTC
It seems that for content recognition of delimiter seperated values the content doesn't matter to the 
import routine. OOo seems to rather only consider the file-suffix.

I have tried the same content packed into different files with different suffixes.

---

Part before suffix = Indicates content and used delimiter.
Suffix = Just copied the same file and added different suffixes.

contacts-semicolon
contacts-semicolon.csv -> SUCCESS
contacts-semicolon.dsv
contacts-semicolon.tsv
contacts-semicolon.txt
contacts-tab
contacts-tab.csv -> SUCCESS
contacts-tab.dsv
contacts-tab.tsv
contacts-tab.txt

---

Only when the file ends in ".csv" the routine works correctly, it asks the user for how to interpret the 
content (which charset, which delimiter, column datatype setting, etc).
The other endings "tsv,dsv,txt" or none seem to get ignored, before content analysis even starts.

I was using NeoOffice 2.2.5 Patch 6, and I am not sure the OOo equivalent, hence filed it under 2.2.1
Comment 1 Mathias_Bauer 2009-05-25 12:50:22 UTC
That is a problem of the type detection - needs some evauation.
Comment 2 Marcus 2017-05-20 11:11:14 UTC
Reset assigne to the default "issues@openoffice.apache.org".