Issue 103186

Summary: "Always Text" formating option
Product: Calc Reporter: madseh <matthias.schwarz>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CLOSED NOT_AN_OOO_ISSUE QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues, rainerbielefeld_ooo_qa
Version: OOo 3.1Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description madseh 2009-06-29 13:09:22 UTC 
Hello,

On open/import of CSV file I would like to see an formatting option "Always Text",
so that all fields are treated as text and *added columns are also 'Text'*.

(since 'Text' does not modify strings like '0053142' or similar)
Comment 1 Rainer Bielefeld 2009-06-30 06:31:07 UTC 
This option already exists, you only have to set 'Fields - Column type' in
import dialog to "Text" where desired.

So INVALID
Comment 2 Rainer Bielefeld 2009-06-30 06:31:28 UTC 
.
Comment 3 madseh 2009-07-02 14:38:01 UTC 
> This option already exists, you only have to set 'Fields - Column type' in
> import dialog to "Text" where desired.

This only works for existig columns.
New created columns will destroy an input "0054351" because of "standard format"
Comment 4 Edwin Sharp 2013-12-11 19:54:14 UTC 
(In reply to madseh from comment #3)
> This only works for existig columns.
> New created columns will destroy an input "0054351" because of "standard
> format"

Once CSV imported into Calc:
Format - Styles and Formatting - Cell Styles - right click Default - Modify... - Numbers - Category=Text - OK.