private bool PrepareFunctionArguments(CalcFunctionExpression expr, CalcEvaluatorContext context, out CalcFunction func, out object[] args, out List <int> expandArrayArgIndex, out object error) { if (!this.TryGetFunction(expr, context, out func, out error)) { args = null; expandArrayArgIndex = null; return(false); } expandArrayArgIndex = new List <int>(); int argCount = expr.ArgCount; args = new object[argCount]; error = null; if (func.IsBranch) { int i = func.FindTestArgument(); if ((i >= 0) && (i < argCount)) { object obj2; if (!this.EvaluateFunctionArgument(expr.GetArg(i), context, func.AcceptsArray(i), func.AcceptsReference(i), func.AcceptsError(i), func.AcceptsMissingArgument(i), out obj2)) { error = obj2; expandArrayArgIndex = null; return(false); } if ((context != null) && !context.ArrayFormulaMode) { if (obj2 is CalcReference) { obj2 = this.ExtractValueFromReference(obj2 as CalcReference, context.Row, context.Column); if (!func.AcceptsError(i) && (obj2 is CalcError)) { error = obj2; expandArrayArgIndex = null; return(false); } if (!func.AcceptsMissingArgument(i) && (obj2 is CalcMissingArgument)) { obj2 = null; } } else if ((obj2 is CalcArray) && !func.AcceptsArray(i)) { if (!context.ExpandArrayToMultiCall) { obj2 = CalcHelper.GetArrayValue(obj2 as CalcArray, 0, 0); if (!func.AcceptsError(i) && (obj2 is CalcError)) { error = obj2; expandArrayArgIndex = null; return(false); } if (!func.AcceptsMissingArgument(i) && (obj2 is CalcMissingArgument)) { obj2 = null; } } else { expandArrayArgIndex.Add(i); } } } args[i] = obj2; } List <int> list = new List <int>(); CalcArray array = CalcConvert.ToArray(args[i]); for (int j = 0; j < array.RowCount; j++) { for (int k = 0; k < array.ColumnCount; k++) { int item = -1; try { item = func.FindBranchArgument(array.GetValue(j, k)); } catch (InvalidCastException) { } if (item != -1) { if (!list.Contains(item)) { list.Add(item); } if (list.Count >= (func.MaxArgs - 1)) { break; } } } } if (list.Count == 0) { error = CalcErrors.Value; expandArrayArgIndex = null; return(false); } foreach (int num6 in list) { if ((num6 >= 0) && (num6 < argCount)) { object obj3; if (!this.EvaluateFunctionArgument(expr.GetArg(num6), context, func.AcceptsArray(num6), func.AcceptsReference(num6), func.AcceptsError(num6), func.AcceptsMissingArgument(num6), out obj3)) { error = obj3; expandArrayArgIndex = null; return(false); } if (((context != null) && !context.ArrayFormulaMode) && ((obj3 is CalcArray) && !func.AcceptsArray(num6))) { if (!context.ExpandArrayToMultiCall) { obj3 = CalcHelper.GetArrayValue(obj3 as CalcArray, 0, 0); if (!func.AcceptsError(num6) && (obj3 is CalcError)) { error = obj3; expandArrayArgIndex = null; return(false); } if (!func.AcceptsMissingArgument(num6) && (obj3 is CalcMissingArgument)) { obj3 = null; } } else { expandArrayArgIndex.Add(num6); } } args[num6] = obj3; } } if (expandArrayArgIndex.Count > 0) { expandArrayArgIndex.Sort(); } } else { for (int m = 0; m < argCount; m++) { object obj4; if (!this.EvaluateFunctionArgument(expr.GetArg(m), context, func.AcceptsArray(m), func.AcceptsReference(m), func.AcceptsError(m), func.AcceptsMissingArgument(m), out obj4)) { error = obj4; expandArrayArgIndex = null; return(false); } if (((context != null) && !context.ArrayFormulaMode) && ((obj4 is CalcArray) && !func.AcceptsArray(m))) { if (!context.ExpandArrayToMultiCall) { obj4 = CalcHelper.GetArrayValue(obj4 as CalcArray, 0, 0); if (!func.AcceptsError(m) && (obj4 is CalcError)) { error = obj4; expandArrayArgIndex = null; return(false); } if (!func.AcceptsMissingArgument(m) && (obj4 is CalcMissingArgument)) { obj4 = null; } } else { expandArrayArgIndex.Add(m); } } args[m] = obj4; } } return(true); }