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]

Hello Knut,
yes, as macro it works.

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

Frank

 

[Knut]

OK, sorry dont know anything bout C#


knut

Hello Knut,
yes, as macro it works.

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

Frank