Issue 32651

Summary: Allow global settings on Import CSV
Product: Calc Reporter: peterkayatwork <peterkayatwork>
Component: codeAssignee: spreadsheet <spreadsheet>
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1.2   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description peterkayatwork 2004-08-05 20:42:58 UTC 
It would be very useful to be able to set some global settings for importing
.csv files - for example, which field should be text, which number, etc.

This has become an issue for me because I open many .csv files, many of which
have strings of the form "1-03" (a price measured in 32nds of a dollar).  These
get converted to dates, which is absolutely not what I want, and I cannot change
them once the .csv has been imported.

What I am forced to do instead, is to every time select the fields and specify
that they are "strings" instead of "general" - a very time-consuming task.
Comment 1 frank 2004-08-06 09:39:36 UTC 
Hi,

this is a double to Issue 3687 even if it doesn't look like the same.

Frank

*** This issue has been marked as a duplicate of 3687 ***
Comment 2 frank 2004-08-06 09:40:02 UTC 
closed double