Issue 125595 - Default text csv/tsv import options
Summary: Default text csv/tsv import options
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.1.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2014-09-07 05:07 UTC by apache
Modified: 2014-09-07 05:10 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: 4.1.0
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description apache 2014-09-07 05:07:34 UTC
Problem and Affected users:

Calc presents text import wizard while opening text files such as csv/tsv. The feature in itself is very meaningful as well as useful for majority of the users as it allows user to make adjustment on the nature of the data. But for users with pre-known data and use calc frequently, this becomes one extra step. Specially when opening several files at once.

1. Most of the time, once the delimeter is changed from the last import, user just clicks import without any change or observation.
2. Removes one extra step from the workflow
3. Calc remembers the delimiter but does not remember the last encoding used for empty txt files (For example my system vanilla Ubuntu 14.04 LTS always shows UTF-16) . Having a default saved allows to override the default encoding used used as well for txt files used between applications that expects particular encoding.


Solution expected
1. Feature (Save as default and do not ask me again)
2. Hack or pointers / guide from some one who know about the import section of the codebase.

Notes and side effects:
- Two configurable behavior on (Open with from OS) and open from calc. Opening from calc or import could present with the wizard while opening from os could take the defaults.
- For .csv MS Excel uses defaults
- Issue 103185, talks about saving defaults but not the removal of wizard itself.
- Issue 15274, very old request with similar request but it is sidelined with argument "OOo is an integrated Office, that means you can't have single Applications and how should the Office decide what should be opened ?". Given there are not better opensource alternative (Gnumeric exists but is more useless for workflow with csv), the enhancements are more meaninful.
- unformatted data such as csv/tsv are more useful for cross application compatibility than formatted ones like odt and xsl.