Issue 14675 - Calc, Open CSV File, Textimport does not remember options / wrong defaults
Summary: Calc, Open CSV File, Textimport does not remember options / wrong defaults
Status: CLOSED DUPLICATE of issue 3687
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 1.0.0
Hardware: PC Windows 2000
: P4 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: requirements
QA Contact: issues@sc
Keywords: rfe_eval_ok, third_party_support, usability
: 41004 73547 (view as issue list)
Depends on:
Reported: 2003-05-20 16:10 UTC by erwachsen42
Modified: 2013-08-07 15:12 UTC (History)
3 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description erwachsen42 2003-05-20 16:10:16 UTC
When loading a CSV file to the calc part of open office,
a dialog "textimport" is presented.

This dialog has "unusual" settings and does not remember
the settings from the last time a csv file was loaded.

Useful settings:

- "split options": "Semikolon" and not "comma"
  (i have not seen any files with comma)

- Fields: column type: "text" and not "standard"
  or at least a check box with "for all columns"
  because it is very (annoying) to setthe type to "text"
  for some 40 coulmns. 
  Reason is that a spread sheet application (excel too)
  destroys the contents of numeric and date/time fields
  for example by removing leading zeros (01234 -> 1234)
  or by adding a year to what seems to be a date
  (20.05. -> 20.05.03)  and so on

Thanks for reading this,

What about the 32000 row limit :-), the document was last updated along time ago.
Comment 1 oc 2003-05-20 16:18:04 UTC
Hi Bettina,
Comment 2 daniel.rentz 2003-05-20 17:01:37 UTC
Hi unnamed user,

The "set type to multiple columns" issue is already fixed in OOo 1.1.
There you can select one column, or column ranges, or several single
columns, or all columns, just like in a real Calc sheet.
The name "CSV" means Comma Separated Values, therefore the default
settings... ;-)
Finally I agree, that remembering the dialog settings is a good idea.
Comment 3 frank 2003-10-28 08:33:23 UTC
nothing for ms_interop., so no blocking of 21783
Comment 4 bettina.haberer 2004-01-21 18:17:20 UTC
Summary: The last used settings in the dialog "Textimport" should be remembered.
Hello Niklas, please give approval for this evaluated OO.o 2.0 flagged issue. 
If you confirm with the target OO.o 2.0, then please keep it on your owner (or
the owner of the concerning developer) for implementation. In case you want this
issue for 'OOo Later', then please reset the target milestone. If you decline
the issue finally, please set the resolution to 'Wontfix' (but do not close). In
case of 'OOo Later' or 'Wontfix' please reset it on Bettina's owner. Thank you.
Comment 5 niklas.nebel 2004-01-26 15:49:41 UTC
This should be "enhancement", not "defect".
It's not on the list of features that we're going to do for 2.0. We need to
focus on the enhancements from the PCD document.
Comment 6 erwin.tenhumberg 2004-11-04 13:22:26 UTC
set keywords and reassigned issue according to RFE process
Comment 7 frank 2005-01-24 14:11:35 UTC
*** Issue 41004 has been marked as a duplicate of this issue. ***
Comment 8 grsingleton 2005-01-24 14:58:02 UTC
added myself to cc list
Comment 9 frank 2007-03-12 15:11:38 UTC
*** Issue 73547 has been marked as a duplicate of this issue. ***
Comment 10 ooo 2009-01-28 11:29:42 UTC
Btw, CSV stands for Comma Separated Values, even if the original submitter has
not seen files with comma.
This issue now is nothing different from issue 3687, is it?

*** This issue has been marked as a duplicate of 3687 ***
Comment 11 ooo 2009-01-28 11:30:34 UTC
Closing dupe.