>>Currently I'm filling an Excel sheet with data from VFP. I'm using the VLOOKUP function. Here's a problem I encounter.
>>
>>
>>poExcel.Selection.Formula = "=VLOOKUP(A4,'January 2010'!$A$3:$J$9,10,FALSE)"
>>
>>
>>This gives good results in my Excel, but it screws up on another PC. The crux is the comma. The other machine expects the semicolon as separator. However, if I change the commas to semicolons, it screws up on MY machine.
>>
>>It is controlled by a machine's Regional setting (Regional and Language Options > Regional Options > Customize > Numbers > List Separator).
>>
>>Isn't there any PC-independent character to use? Is there any workaround?
>
>Peter,
>
>If you know that there are only two options, then, probably, the below will be enough:
>
>lconerror=onerror(...)
>ll=.f.
>ON ERROR ll=.t.
>poExcel.Selection.Formula = "=VLOOKUP(A4,'January 2010'!$A$3:$J$9,10,FALSE)"
>on error &lconerror
>if ll
> poExcel.Selection.Formula = "=VLOOKUP(A4;'January 2010'!$A$3:$J$9;10;FALSE)"
>endif
>
I already tried that (using SUBSTR), but it made no difference at all!
Do you know that one of the most important differences between Excel and OpenOffice Calc is that Calc always wants the semicolon and refuses to accept the comma?! It is obvious (to me) that the comma-semicolon issue is one of the most annoying quirck of the Excel 'language'.
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.
