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
Keywords: oooqa
Depends on:
Reported: 2005-12-08 08:04 UTC by jamescrompton
Modified: 2005-12-09 15:32 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

csv file with European formatted numbers (422 bytes, txt/csv)
2005-12-08 20:33 UTC, jamescrompton
no flags Details

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

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.

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.

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

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

So closing as double.


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