Ask Your Question
0

import .csv[help]submit the bug [closed]

asked 2013-03-10 15:51:41 +0200

jiero gravatar image

when import .csv in calc, any numerical value start with "0" will lose it, for example, like phone number.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-26 19:13:08.162833

1 Answer

Sort by » oldest newest most voted
1

answered 2013-03-10 16:32:37 +0200

w_whalley gravatar image

If your CSV has quoted fields, then in the Text Import dialog, Other Options section check the box for Quoted field as text.

If your CSV fields are unquoted, then in the Text Import dialog, Fields section, right-click on the column type heading and change Standard to Text.

edit flag offensive delete link more

Comments

Good to know it, shift key failed horizontal scrolling, so I thought that was just a preview. Btw, it only works for column, not row.

jiero gravatar imagejiero ( 2013-03-23 00:11:49 +0200 )edit

Good to know it, shift key failed horizontal scrolling, so I thought that was just a preview.

jiero gravatar imagejiero ( 2013-03-23 00:11:55 +0200 )edit

i would still consider this a dirty trick... no setting to avoid this issue?

jiero gravatar imagejiero ( 2013-03-31 16:24:41 +0200 )edit

Question Tools

Stats

Asked: 2013-03-10 15:51:41 +0200

Seen: 63 times

Last updated: Mar 10 '13