I have a document level application for Excel 2010 using VSTO and c#. The following code is used to call the Excel Growth function.
double known_Ys, new_Ys, known_Xs, new_Xs;
// Both of the known arrays have a length of 7
// The new arrays have a length of 5
// All arrays were loaded with valid double values
// except new_Ys which will contain the result
Excel.WorksheetFunction wsf = Application.WorksheetFunction;
object results = wsf.Growth(known_Ys, known_Xs, new_Xs, System.Type.Missing);
While debugging, "results" show a type of 'System.Object[*]' which is a System.Object with an undefined lower boundary.
Looking at the variable, there is an array of double values that appear to be correct. The lower boundary is 1, and the upper boundary is 5.
When attempting to cast the results to either object or double, I get an exception, "Unable to cast object of type 'System.Object[*]' to type 'System.Object' or 'double'.
I've also unsuccessfully tried to use the static methods of the Array class to copy the contents out.
Any thoughts on a resolution would be appreciated.
I don't want to use VBA code to resolve the problem if it can be avoided.
I've also considered a work-around, using a hidden worksheet to perform the calculations and copying the results into the c# application, but feel I should be able to handle it in the c# code.
I found the following work-around, unless someone has a better solution.
"results" inherits from System.Array.
System.Array resultsArray = results as System.Array;
if (resultsArray != null)
int idx = resultsArray.GetLowerBound(0);
for (int i = 0; i < new_Ys.Length; i++)
new_Ys[i] = (double)resultsArray.GetValue(idx);
// Handle exception.
The conflict is that c# vectors (one dimensional arrays) are always zero based, so explicit casts won't work.
The problem is that the button click event is happening almost immediately - so the second "click" is going to the correct place - the control at that position on the "new" panel. And that will generate a click event for the new button because that is exactly what should happen.
If you want to stop it, then
1) Create a class level variable:
private DateTime lastSwap = DateTime.Now;
2) In the Button1 click handler, set it:
lastSwap = DateTime.Now;
And then swap panels.
3) In the Button2 click handler, check it and ignore if too soon:
if (DateTime.Now < lastSwap.AddMilliseconds(500)) return;
You can change the 500 to any value you think reasonable - 500 provides half a second.
If you get an email telling you that you can catch Swine Flu from tinned pork then just delete it. It's Spam.
thanks for your quick response... code is working properly... but it is impossible to implement on big application where there are more then 20,25 panels and every control takes different time to execute.
You're missing the point. As a programmer, when you find a solution to the problem, but you have 25 problems - you dont implement the solution 25 times. You implement it once and re-use it 25 times.
Think of it this way - if you have 25 customers, you dont write 25 different classes to represent each customer, you implement once class called "Customer" and reuse it 25 times. The same thing applies here, you need a solution which stops a button being clicked within 500ms of another button (personally I think this is an awful solution to your original problem, but hey if it works for you go with it). Write a class which exhibits this behaviour and attach it to every button which requires it.
The 500ms had nothing to do with whatever task the button does, it had to do with stopping a quick double click operating a button which appears after the first click. It should not matter what the second button does!
Anyway your original question asked about 2 panels, and you got a solution to the question as stated. Ask the right question, and you'll get the right answer.
Last Visit: 31-Dec-99 18:00 Last Update: 10-Mar-14 13:27