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). -- View this message in context: http://www.nabble.com/CSV-datasheet-import---decimal-separators-tp14879792p14879792.html Sent from the GnuMeric mailing list archive at Nabble.com.
_______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
