Re: CSV datasheet import - decimal separators

[Emmanuel Pacaud <emmanuel pacaud univ-poitiers fr>]

On mer, 2008-01-16 at 04:50 -0800, Izildur wrote:
> Hi there
>
> Im having some trouble importing data from csv sheets to gnumeric (version
> 1.7.12 latet windows version).
> the problem are the decimal separators: the program that generates the csv
> sheets uses . (e.g. 0.1234) while gnumeric uses , (0,1234) to be able to
> calculate with it. if i select the respective columns in the import wizard
> and select "format: numbers" gnumeric either does not recognize them as
> numbers or it will use only the digits following the decimal separator
> (1234). if i format these cells as text they are imported as they are:
> 0.1234. then i thought ok, i could just search all "." and replace them with
> "," and it should work. well gnumeric is changing all . to , but if i then
> format the cells as numbers it will not work because gnumeric marks all the
> cells with ' (this is only displayed when a single cell is seleceted) and
> the cells are consequently not recognized as numbers. 
> do you have any ideas what i am doing wrong? this HAS to work (excel and
> calc can do it, but is annoying to copy all the data beween several
> programs).

In the text import dialog, third page, there's a Source locale combo
that let you select a locale different than the user locale for the
import. Select North America->United states/English, which has dot as
decimal separator.

        Emmanuel.