Issue 59069 - Choose number formats on CSV import
Summary: Choose number formats on CSV import
Status: CLOSED DUPLICATE of issue 49978
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2005-12-08 08:04 UTC by jamescrompton
Modified: 2005-12-09 15:32 UTC (History)
1 user (show)

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

Attachments
csv file with European formatted numbers (422 bytes, txt/csv)
2005-12-08 20:33 UTC, jamescrompton 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description jamescrompton 2005-12-08 08:04:10 UTC 
When I open a csv file with OO.o I need to be able to tell the application that
the numbers in the file are formatted with a decimal comma and not a decimal
point (or vice versa). Otherwise numbers with the wrong decimal separator are
imported as strings. Changing the format of the cells doesn't help because OO.o
helpfully puts a ' before the 'string' to stop it turning into a number. The
only way work around this problem at present seems to be to change the default
language before opening the file.
Comment 1 frank 2005-12-08 10:09:12 UTC 
Hi,

your description is not correct !

If you open the csv file you can choose the column type in the csv import dialog
to be US-English.

Frank
Comment 2 frank 2005-12-08 10:09:27 UTC 
closed wfm
Comment 3 jamescrompton 2005-12-08 20:31:16 UTC 
I don't want to choose the column type to be US English. I want it to be a
number. OO.o doesn't recognise it as a number because it has a comma not a point
as the decimal separator.

I'll attach a pruned copy of the file in question. To reproduce the problem:
1. Make sure that your default language uses a decimal point.
2. Open the file. Choose semicolon as the separator.
3. Watch the numbers (in the column headed 'SOLL') turn to strings.
Comment 4 jamescrompton 2005-12-08 20:33:52 UTC 
Created attachment 32225 [details]
csv file with European formatted numbers
Comment 5 frank 2005-12-08 21:48:52 UTC 
US English has a dot as decimal separator. Choosing this setting converts
decimal dots into commas. So this is exactly what you need and what you want.

Frank
Comment 6 frank 2005-12-08 21:49:25 UTC 
closed invalid
Comment 7 jamescrompton 2005-12-09 12:22:42 UTC 
Please read more carefully. Converting decimal dots into commas is precisely the
opposite of what I need.
Comment 8 aziem 2005-12-09 14:44:46 UTC 
Perhaps duplicate of issue 49978?
Comment 9 jamescrompton 2005-12-09 15:03:00 UTC 
Issue 49978 is indeed essentially the same problem. (Not quite sure why I didn't
find it.) Both could be dealt with by replacing the enigmatic 'US English'
option with "Number (decimal comma)" if the current default decimal separator is
a point and "Number (decimal point)" if the default is comma.
Comment 10 frank 2005-12-09 15:31:42 UTC 
Hi,

US-English is for dots imported into comma using locales and Issue 49978 deals
with the other way round.

So closing as double.

Frank

*** This issue has been marked as a duplicate of 49978 ***
Comment 11 frank 2005-12-09 15:32:03 UTC 
closed double