Hi Eike, Now I got it. I hadn't catched (caught?) that I had to use a column by column choice. Thank you so much for your friendly help.
Now I can open the .csv files nicely. And yet I still wonder why figures like 0.34 are rendered right and 2.42wrong, depending upon the whole part being zero or not, of course this is without having to set the data type previously. I apologize if I used HTM. I thought I was using a gmail formatting feature. I told you I'm no expert. Regarding the list, I thought I was writing to some kind of support desk, that I got with a Google search. Thanks again and regards Jose 2006/10/26, Eike Rathke <[EMAIL PROTECTED]>:
Hi Jose, On Monday, 2006-10-23 15:46:42 -0300, Jose Miyara wrote: > Thank you very much for your reply. The option you suggest "English-US" is > not shown in my OpenOffice.org 2.0.2 If we are talking about CSV file import, the "Text import" dialog popping up after having opened the file lets you select columns. Each column can be set individually to a specific data type using either the context menu on the column header or by selecting from the "Column type" listbox. One of the types offered is "US English". > "No","Fecha/Hora","Localidad","Nro. > > Destino","Duración en minutos ","Monto" > "1","01/09/2006 > > 12:26:53","","1234404841","000:01:00","0.34" > If you look at the last column here "Monto" (=amount) you'll notice that in > spite of the fact that in this country we use a comma as a decimal mark, in > this file a dot is used instead. Which is what I assumed before. > I show the amounts that are rendered wrong in red bold characters. As I don't read the HTML rendered part of your mail (you should refrain from posting mails in HTML anyway) I don't see "bold red", but I think I know what you're referring anyway. > The only > difference is that there is a whole part in the value. That is why I thought > about a possible bug, but I'm not an expert. Please try to assign US-English to the column in the CSV import dialog. If this is not about the dialog, then temporarily setting the locale to English-US under Tools.Options.LanguageSettings.Languages "Language of Locale setting" before importing the data may help. > I didn't know I was writing to a list. Well, somewhere you have obtained the list address, that place should had mentioned it's a mailing list. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun, use the [EMAIL PROTECTED] account instead if really needed. Thanks.
