Re: CSV datasheet import - decimal separators




Ahh perfect, thanks. It is working now. It was so simple really, I have just
been using the wrong English setting in the source format dropdown menu.


Emmanuel Pacaud wrote:

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.

_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list



-- 
View this message in context: 
http://www.nabble.com/CSV-datasheet-import---decimal-separators-tp14879792p15021707.html
Sent from the GnuMeric mailing list archive at Nabble.com.




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]