Apache OpenOffice (AOO) Bugzilla – Issue 103186
"Always Text" formating option
Last modified: 2017-05-20 09:54:49 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)
This option already exists, you only have to set 'Fields - Column type' in import dialog to "Text" where desired. So INVALID
.
> 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"
(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.