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. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
