Issue 103186 - "Always Text" formating option
Summary: "Always Text" formating option
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2009-06-29 13:09 UTC by madseh
Modified: 2017-05-20 09:54 UTC (History)
3 users (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
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.