Is it possible to get Calling cell information like Cell Object or Row Index and Column Index of Cuntom or User Defined function calling cell in Evaluate Method?
public class Function_Factorial : Infragistics.Silverlight.Excel.CalcEngine.ExcelCalcFunction { public override string Name { get { return "factorial"; } }
protected override ExcelCalcValue Evaluate(ExcelCalcNumberStack numberStack, int argumentCount) { // can we get cell row index and column index here?
return new ExcelCalcValue(this.CalculateFactorial(val)); }
private Int64 CalculateFactorial( Int64 value ) { if ( value == 0 ) return 1;
if ( value < 3 ) return value;
Int64 factorial = 2;
checked { for ( Int64 i = 3; i <= value; i++ ) { factorial *= i; } }
return factorial; } }
Hello Imran,
Following is the duplicate post of the above post http://blogs.infragistics.com/forums/t/37366.aspx.
As per Mike Dour's reply to the above form post and after some research, this issue has been determined to be a new feature request. I have sent your feature request directly to our product management team. Our product team chooses new feature requests for development based on popular feedback from our customer base. Infragistics continues to monitor application development for all of our products, so as trends appear in requested features, we can plan accordingly.
We value your input, and our philosophy is to enhance our toolset based on customer feedback. If your feature is chosen for development, you will be notified at that time. Your reference number for this feature request is FR12564.
If you would like to follow up on your feature request at a later point, you may contact Developer Support management via email. Please include the reference number of your feature request in the subject and body of your email message. You can reach Developer Support management through the following email address: dsmanager@infragistics.com
Thank you for your request.