Click here to Skip to main content
11,435,451 members (58,023 online)
   

C#

 
GeneralRe: Create a button in the context menu for each selected contact. Pin
csharpcomeintome6-Nov-12 1:35
membercsharpcomeintome6-Nov-12 1:35 
GeneralRe: Create a button in the context menu for each selected contact. Pin
csharpcomeintome6-Nov-12 5:57
membercsharpcomeintome6-Nov-12 5:57 
GeneralRe: Create a button in the context menu for each selected contact. Pin
csharpcomeintome6-Nov-12 22:24
membercsharpcomeintome6-Nov-12 22:24 
GeneralRe: Create a button in the context menu for each selected contact. Pin
csharpcomeintome6-Nov-12 3:40
membercsharpcomeintome6-Nov-12 3:40 
GeneralRe: Create a button in the context menu for each selected contact. Pin
Eddy Vluggen6-Nov-12 3:42
memberEddy Vluggen6-Nov-12 3:42 
GeneralRe: Create a button in the context menu for each selected contact. Pin
csharpcomeintome6-Nov-12 3:46
membercsharpcomeintome6-Nov-12 3:46 
GeneralRe: Create a button in the context menu for each selected contact. Pin
Eddy Vluggen6-Nov-12 4:04
memberEddy Vluggen6-Nov-12 4:04 
QuestionProblem with Excel WorksheetFunction.Growth in c# [modified] Pin
Ross R5-Nov-12 0:17
memberRoss R5-Nov-12 0:17 
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);
      idx++;
   }
   return new_Ys;
}
else
{
   // Handle exception.
   return null;
}

The conflict is that c# vectors (one dimensional arrays) are always zero based, so explicit casts won't work.

modified 5-Nov-12 6:46am.

Questionavoid double click Pin
neeraj@max4-Nov-12 21:06
memberneeraj@max4-Nov-12 21:06 
AnswerRe: avoid double click Pin
OriginalGriff4-Nov-12 21:34
mvpOriginalGriff4-Nov-12 21:34 
GeneralRe: avoid double click Pin
neeraj@max4-Nov-12 22:09
memberneeraj@max4-Nov-12 22:09 
GeneralRe: avoid double click Pin
J4amieC4-Nov-12 22:27
memberJ4amieC4-Nov-12 22:27 
GeneralRe: avoid double click Pin
neeraj@max5-Nov-12 0:25
memberneeraj@max5-Nov-12 0:25 
GeneralRe: avoid double click Pin
Pete O'Hanlon5-Nov-12 1:30
protectorPete O'Hanlon5-Nov-12 1:30 
GeneralRe: avoid double click Pin
J4amieC5-Nov-12 2:27
memberJ4amieC5-Nov-12 2:27 
GeneralRe: avoid double click Pin
neeraj@max5-Nov-12 2:43
memberneeraj@max5-Nov-12 2:43 
GeneralRe: avoid double click Pin
J4amieC5-Nov-12 2:52
memberJ4amieC5-Nov-12 2:52 
GeneralRe: avoid double click Pin
neeraj@max5-Nov-12 20:34
memberneeraj@max5-Nov-12 20:34 
GeneralRe: avoid double click Pin
J4amieC5-Nov-12 22:43
memberJ4amieC5-Nov-12 22:43 
GeneralRe: avoid double click Pin
neeraj@max6-Nov-12 1:08
memberneeraj@max6-Nov-12 1:08 
AnswerRe: avoid double click Pin
neeraj@max22-Nov-12 21:02
memberneeraj@max22-Nov-12 21:02 
QuestionHow to call C++ parameterised function from C# using thread Pin
sjs4u4-Nov-12 5:09
membersjs4u4-Nov-12 5:09 
AnswerRe: How to call C++ parameterised function from C# using thread Pin
Richard MacCutchan4-Nov-12 6:14
mvpRichard MacCutchan4-Nov-12 6:14 
AnswerRe: How to call C++ parameterised function from C# using thread Pin
DaveyM694-Nov-12 6:29
mentorDaveyM694-Nov-12 6:29 
QuestionHow to declare events? Pin
Andy_L_J3-Nov-12 21:41
memberAndy_L_J3-Nov-12 21:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.150428.2 | Last Updated 5 May 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid