Accessing WorksheetFunction.XX from regular C# Forms application

[Jes Ramsing]

I have been trying all day to use the WorksheetFunction.Trend and other
functions from a regular Windows.Forms application.
I have O2003 with .net support installed and VS2003
in references I have Microsoft.Office.Interop.Excel and its included
references.
I can create An Excel.Application obejct ( apparently ) but as soon as I try
to access a WorksheetFunction.XX on it I get an Exception :

The following exception occurred:
System.Runtime.InteropServices.COMException (0x80028018): Old format or
invalid type library.
at System.RuntimeType.ForwardCallToInvokeMember(String memberName,
BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData&
msgData)
at Microsoft.Office.Interop.Excel.WorksheetFunction.Atanh(Double Arg1)

I would like to utilize the power of Excel in my application - so please
give me a pointer to a solution...

Regards
/Jes - gone matchracing for the evening

 

[Jens Thiel]

That's a known bug with a matching KB article. Your thread locale must match
Excel's language.

Best regards,
Jens.