> I'm trying to import a file that is comma seperated. The problem is that > gnumeric splits the data over columns from the spaces without asking me. > I therefore cannot use the Tekst to Coloumn to seperate on commas. > > Example: > > Gnumeric,Excel > Open Source,Closed > > will put in A1: Gnumeric,Excel > and in A2: Open > and in B2: Source,Close
When run in locale nb_NO.UTF-8, gnumeric behaves in this way. When run in locale en_US.UTF-8, gnumeric behaves in the way reporter expects. This is because in Norwegian, 'comma' is a decimal separator. The following example gives the desired result in Norwegian locale. Gnumeric;Excel Open Source;Closed Gnumeric also has text import (configurable), where all parameters regarding text file import can be controlled from a dialog. Jon Kåre
