Hello all,

A VO 2.8 SP3 - MS Excel (2003 and 2007) is working very well.

I have seen now in different installations that the languange settings 
are difficult (german or english).

Which settings are used to configure Excel to use ony english commands ? 
(e.g. for formula and formating Cells)

Thanks in advance

Niko

On Tue, 04 May 2010 18:39:26 +0200, Nikolaus Kern
<parzival1969@gmx.at> wrote:

Hello Niko,
>
>A VO 2.8 SP3 - MS Excel (2003 and 2007) is working very well.
>
>I have seen now in different installations that the languange settings 
>are difficult (german or english).
>
>Which settings are used to configure Excel to use ony english commands ? 
>(e.g. for formula and formating Cells)
>
As far as I know: none! That's one of the many shortcomings of Excel
automation. It accepts only the commands in the language of the
version while accepting English at all times, at least with
automation,  or just would understand that when someone enters , say
2.8 it could mean 2,8.....

Anyhow, you asked this question already 4-9-2008 in this NG (look at
Excel functions/formular via OLE) and I replied with a function which
should help you a bit. I think I extended it in the meantime, let me
know if you want me to mail it. There's a list of translated commands
on:

http://dolf.trieschnigg.nl/excel/excel.html

Dick van Kooten

Hello Dick,

Thanks for your response.

When I look at my posting you have mentioned I see that I did not 
express myself in a correct way.

The translation of the functions worked well. Now I discovered that 
sending the english formula (e.g. SUM() ) to a german environment showed 
up well there but with SUMME() it did not. No problem I am sending 
english SUM() now.

On a new installation (win7, office2007) I have recognized that some 
other functions arround formating and diagrams do not work correct any more.

oChart:Legend:position := 1 crashes when I send functions in English and 
works when I send them in German. The same happens with oWS:[Range, 
"A1","A4"]:NumberFormat := "00,00%;[" +ExcelFunction("Rot") + "]-00,00%"

-> ExcelFunction(uValue) translates between English and German.

I am looking for a setting to tell Excel (via OLE) that all commands, 
communication etc. will be done in English. This shall apply to all 
functions (like SUM() ) and also all commands to format cells

Do you have ideas how to overcome this situation?

Thanks

Niko

> On Tue, 04 May 2010 18:39:26 +0200, Nikolaus Kern
> <parzival1969@gmx.at>  wrote:
>
> Hello Niko,
>>
>> A VO 2.8 SP3 - MS Excel (2003 and 2007) is working very well.
>>
>> I have seen now in different installations that the languange settings
>> are difficult (german or english).
>>
>> Which settings are used to configure Excel to use ony english commands ?
>> (e.g. for formula and formating Cells)
>>
> As far as I know: none! That's one of the many shortcomings of Excel
> automation. It accepts only the commands in the language of the
> version while accepting English at all times, at least with
> automation,  or just would understand that when someone enters , say
> 2.8 it could mean 2,8.....
>
> Anyhow, you asked this question already 4-9-2008 in this NG (look at
> Excel functions/formular via OLE) and I replied with a function which
> should help you a bit. I think I extended it in the meantime, let me
> know if you want me to mail it. There's a list of translated commands
> on:
>
> http://dolf.trieschnigg.nl/excel/excel.html
>
> Dick van Kooten