excel: international formula names in c#

[Frank M. Walter]

Hello,

It is possible to put formula to active cell programaticaly.
But, I have a problem with formula names.

Here a snipped:

activeCell.Value2 = "=Count(A1:A20)";

This does work only with english excel.

Is there any posibility to put formulas in international name ?
I would like to make my AddIn working not depending of OS.

Thanks

Frank

[Knut]

I think you might be wrong, tried this with a Norwegian copy of Excel 2003:

Sub Test1()
ActiveCell.Value2 = "=Count(A1:A20)"
End Sub

B1 was the active cell and the formula in B1 became: =ANTALL(A1:A20) which
is Norwegian equvivalent to =COUNT(A1:A20), and the formula works.

BTW: when you insert a formula with VBA should you not use
ActiveCell.Formula = "=Count(A1:A20)" ?


HTH
knut

"Frank M. Walter" <[email protected]> skrev i melding
news:[email protected]...
> Hello,
>
> It is possible to put formula to active cell programaticaly.
> But, I have a problem with formula names.
>
> Here a snipped:
>
> activeCell.Value2 = "=Count(A1:A20)";
>
> This does work only with english excel.
>
> Is there any posibility to put formulas in international name ?
> I would like to make my AddIn working not depending of OS.
>
> Thanks
>
> Frank
>
>

[Frank M. Walter]

Hello Knut,
yes, as macro it works.

But as AddIn in C# nope.
It gives #NAME
as return

Frank

"Knut" <[email protected]> schrieb im Newsbeitrag
news:[email protected]...
>I think you might be wrong, tried this with a Norwegian copy of Excel 2003:
>
> Sub Test1()
> ActiveCell.Value2 = "=Count(A1:A20)"
> End Sub
>
> B1 was the active cell and the formula in B1 became: =ANTALL(A1:A20) which
> is Norwegian equvivalent to =COUNT(A1:A20), and the formula works.
>
> BTW: when you insert a formula with VBA should you not use
> ActiveCell.Formula = "=Count(A1:A20)" ?
>
>
> HTH
> knut
>
> "Frank M. Walter" <[email protected]> skrev i melding
> news:[email protected]...
>> Hello,
>>
>> It is possible to put formula to active cell programaticaly.
>> But, I have a problem with formula names.
>>
>> Here a snipped:
>>
>> activeCell.Value2 = "=Count(A1:A20)";
>>
>> This does work only with english excel.
>>
>> Is there any posibility to put formulas in international name ?
>> I would like to make my AddIn working not depending of OS.
>>
>> Thanks
>>
>> Frank
>>
>>
>
>

[Knut]

OK, sorry dont know anything bout C#


knut
"Frank M. Walter" <[email protected]> skrev i melding
news:[email protected]...
> Hello Knut,
> yes, as macro it works.
>
> But as AddIn in C# nope.
> It gives #NAME
> as return
>
> Frank
>
> "Knut" <[email protected]> schrieb im Newsbeitrag
> news:[email protected]...
>>I think you might be wrong, tried this with a Norwegian copy of Excel
>>2003:
>>
>> Sub Test1()
>> ActiveCell.Value2 = "=Count(A1:A20)"
>> End Sub
>>
>> B1 was the active cell and the formula in B1 became: =ANTALL(A1:A20)
>> which is Norwegian equvivalent to =COUNT(A1:A20), and the formula works.
>>
>> BTW: when you insert a formula with VBA should you not use
>> ActiveCell.Formula = "=Count(A1:A20)" ?
>>
>>
>> HTH
>> knut
>>
>> "Frank M. Walter" <[email protected]> skrev i melding
>> news:[email protected]...
>>> Hello,
>>>
>>> It is possible to put formula to active cell programaticaly.
>>> But, I have a problem with formula names.
>>>
>>> Here a snipped:
>>>
>>> activeCell.Value2 = "=Count(A1:A20)";
>>>
>>> This does work only with english excel.
>>>
>>> Is there any posibility to put formulas in international name ?
>>> I would like to make my AddIn working not depending of OS.
>>>
>>> Thanks
>>>
>>> Frank
>>>
>>>
>>
>>
>
>