On Nov 19, 2014, at 8:16 PM, Andrew Hood <ajhood@xxxxxxxxx> wrote:
> On 20/11/2014 1:20 PM, Guy Harris wrote:
>> What do various programs do when reading comma-separated value files if:
>>
>> 1) the file contains floating-point values
>
> I don't know about the rest of the question, but OpenOffice tends to
> treat numbers in "e" format as text strings
Let me rephrase that as
1) the file contains non-integer numeric values
The "e" isn't what I'm asking about, as I think that's the same in all locales; it's the "."/"," that I'm asking about here.
> and you have to do a
> text-to-columns conversion on them. When you open a CSV it pops up "the
> how do you want to parse this" dialog box and you can make whatever
> choice of separators suits the file - any combination of comma, tab,
> semicolon, spaces, and some others, or a user-specified string.
Does it also offer you a choice of decimal and thousands separators?