Hi,
Because microsoft decided translate the names of excel functions, 
international programming is a dificult task because i can´t know the 
language in wich my app will run.

For example in my country language to totalize a cell range:
"=soma(C6:C15)"
and works fine with localized excel.

If i put the english formula
"=sum(C6:C15)"
the generated excel file will set an error in that cell.

May be there are a way to configure oExcel to use a standard formula and 
formating at xBase++ level. I searched but no success.
oExcel := CreateObject( "Excel.Application" )

Anybody can help?
Thanks,
Carlos

Hi Carlos

I don't know if what you ask is possible.  But if it is not, then look
at this page:
http://dolf.trieschnigg.nl/excel/excel.html

Hi,
It helps if i can programaticaly know what is the installed excel language. 
I only need 2 functions.
Translate functions was a bad idea in a global world unless there was an 
option to force usage of the english as standard language.
May be Alaska help us discover that excel option / propertie.
Thanks



"Pascal Boivin" <pascal.boivin@nbautomation.com> escreveu na mensagem 
news:xn0ger720b0msq000@xpd300...
> Hi Carlos
>
> I don't know if what you ask is possible.  But if it is not, then look
> at this page:
> http://dolf.trieschnigg.nl/excel/excel.html

Hi,
To who is interested, is possible get the country code to workaround with 
creation of a dictionary of function names proposed by Pascal:
nCountry := oExcel:Application:International( xlCountryCode )
and to format numbers can be used:
cDecimal := oExcel:Application:International( xlDecimalSeparator )
cThousands := oExcel:Application:International( xlThousandsSeparator )
Regards,
Carlos



"Carlos" <paulino@lusiadas.net> escreveu na mensagem 
news:5af31fe2$7957a318$5f5ea@news.alaska-software.com...
> Hi,
> It helps if i can programaticaly know what is the installed excel 
> language. I only need 2 functions.
> Translate functions was a bad idea in a global world unless there was an 
> option to force usage of the english as standard language.
> May be Alaska help us discover that excel option / propertie.
> Thanks
>
>
>
> "Pascal Boivin" <pascal.boivin@nbautomation.com> escreveu na mensagem 
> news:xn0ger720b0msq000@xpd300...
>> Hi Carlos
>>
>> I don't know if what you ask is possible.  But if it is not, then look
>> at this page:
>> http://dolf.trieschnigg.nl/excel/excel.html
>