Exception when adding a array formula

T

Torben Laursen

I have a COM for Excel writting in C# where I have run into a problem

The COM comes with a wizard that helps the user create a array formula.
But when my code tryes to add the string that makes the array formula to a
range a exception is thrown.
Stack trace:
at System.RuntimeType.ForwardCallToInvokeMember(String memberName,
BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData&
msgData)
at Microsoft.Office.Interop.Excel.Range.set_FormulaArray(Object )

The code looks like this:
Microsoft.Office.Interop.Excel.Range RangeFunc = Sheet.get_Range(....
RangeFunc.FormulaArray = FunctionName + OutRangeString + ")"; //This line
throws

My problem is that this only happens on one German PC and no other custormer
has this problem + I cannot reproduce it on my PC.

Does anyone know what can be the root of this problem?

Torben
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COM Exception when read Font.FontStyle property of Style object 0
Help setting formula and values of a cell 0
Getting out of memory error writing cell contents 2
Danish & German Goto SpecialCells Error 1
FileSave() throwing COMException 0
FileSave() throwin COMException 0
Problem Copying DataTable into Worksheet 1
Problems reading Cell data using worksheet.get_range method 1

Top