public override void Evaluate(SpreadsheetGear.CustomFunctions.IArguments arguments, SpreadsheetGear.CustomFunctions.IValue result) { if (arguments.Count == 6) { double number1 = arguments.GetNumber(0); double number2 = arguments.GetNumber(1); double number3 = arguments.GetNumber(2); double number4 = arguments.GetNumber(3); double number5 = arguments.GetNumber(4); double number6 = arguments.GetNumber(5); result.Text = "EQV " + number1.ToString() + "," + number2.ToString() + "," + number3.ToString() + "," + number4.ToString() + "," + number5.ToString() + "," + number6.ToString(); } else if (arguments.Count == 4) { double number1 = arguments.GetNumber(0); double number2 = arguments.GetNumber(1); double number3 = arguments.GetNumber(2); double number4 = arguments.GetNumber(3); result.Text = string.Format("EQV {0},{1},{2},{3}", number1, number2, number3, number4); } else { result.Error = SpreadsheetGear.ValueError.Value; } }
public override void Evaluate(SpreadsheetGear.CustomFunctions.IArguments arguments, SpreadsheetGear.CustomFunctions.IValue result) { if (arguments.Count == 1) { string location = arguments.GetText(0); string parentname; string sheetname = arguments.CurrentWorksheet.ToString(); if (sheetname.Length > 2 && sheetname.Substring(0, 3) == "[S]") { parentname = "L!"; } else if (sheetname.Length > 2 && sheetname.Substring(0, 3) == "[N]") { parentname = "S!"; } else { parentname = "L!"; } result.Text = parentname + location; } else { result.Error = SpreadsheetGear.ValueError.Value; } }
public override void Evaluate(SpreadsheetGear.CustomFunctions.IArguments arguments, SpreadsheetGear.CustomFunctions.IValue result) { if (arguments.Count == 2) { double degree = arguments.GetNumber(1) * Math.PI / 180 * arguments.GetNumber(0); result.Text = degree.ToString(); } else { result.Error = SpreadsheetGear.ValueError.Value; } }
public override void Evaluate(SpreadsheetGear.CustomFunctions.IArguments arguments, SpreadsheetGear.CustomFunctions.IValue result) { if (arguments.Count == 2) { double number1 = arguments.GetNumber(0); double number2 = arguments.GetNumber(1); result.Text = "EQ2 " + number1.ToString() + "," + number2.ToString(); } else { result.Error = SpreadsheetGear.ValueError.Value; } }
public override void Evaluate(SpreadsheetGear.CustomFunctions.IArguments arguments, SpreadsheetGear.CustomFunctions.IValue result) { if (arguments.Count == 3) { string x = arguments.GetNumber(0).ToString(); string y = arguments.GetNumber(1).ToString(); string z = arguments.GetNumber(2).ToString(); result.Text = x + ";" + y + ";" + z; } else { result.Error = SpreadsheetGear.ValueError.Value; } }
public override void Evaluate(SpreadsheetGear.CustomFunctions.IArguments arguments, SpreadsheetGear.CustomFunctions.IValue result) { bool rs = true; string combinestring = ""; for (int i = 0; i < arguments.Count; i++) { string argu = arguments.GetText(i); char[] chars = argu.ToCharArray(); int number = 0; for (int p = 0; p < chars.Length; p++) { if (chars[p] == ';') { number++; } } if (number == 2) { if (i != arguments.Count - 1) { combinestring = combinestring + arguments.GetText(i) + "|"; } else { combinestring = combinestring + arguments.GetText(i); } } else { rs = false; break; } } if (rs) { result.Text = combinestring; } else { result.Error = SpreadsheetGear.ValueError.Value; } }
public override void Evaluate(SpreadsheetGear.CustomFunctions.IArguments arguments, SpreadsheetGear.CustomFunctions.IValue result) { if (arguments.Count == 2 || arguments.Count == 3) { string pipeline = arguments.GetText(1); string last = ""; int rowCount, columnCount; arguments.GetArrayDimensions(0, out rowCount, out columnCount); last = arguments.GetArrayValue(0, 0, 0).Text; for (int i = 1; i < rowCount; i++) { SpreadsheetGear.CustomFunctions.IValue value = arguments.GetArrayValue(0, i, 0); last = last + pipeline + value.Text; } result.Text = last; } else { result.Error = SpreadsheetGear.ValueError.Value; } }
public override void Evaluate(SpreadsheetGear.CustomFunctions.IArguments arguments, SpreadsheetGear.CustomFunctions.IValue result) { if (arguments.Count == 2) { string partname = arguments.GetText(1); int rowCount, columnCount; arguments.GetArrayDimensions(0, out rowCount, out columnCount); for (int i = 0; i < rowCount; i++) { SpreadsheetGear.CustomFunctions.IValue value = arguments.GetArrayValue(0, i, 0); if (value.Text == partname) { result.Number = arguments.GetArrayValue(0, i, 4).Number; break; } } } else { result.Error = SpreadsheetGear.ValueError.Value; } }
public override void Evaluate(SpreadsheetGear.CustomFunctions.IArguments arguments, SpreadsheetGear.CustomFunctions.IValue result) { if (arguments.Count == 5 || arguments.Count == 4) { string partname = ""; int rowCount, columnCount; arguments.GetArrayDimensions(0, out rowCount, out columnCount); if (arguments.Count == 5) { partname = arguments.GetText(4); } else { for (int i = 0; i < rowCount; i++) { SpreadsheetGear.CustomFunctions.IValue value = arguments.GetArrayValue(0, i, 0); if (arguments.CurrentRow == i) { partname = value.Text; break; } } } string MaterialName = ""; for (int i = 0; i < rowCount; i++) { SpreadsheetGear.CustomFunctions.IValue value = arguments.GetArrayValue(0, i, 0); if (value.Text == partname) { MaterialName = arguments.GetArrayValue(0, i, 5).Text; break; } } if (MaterialName != "") { bool findit = false; if (!findit) { arguments.GetArrayDimensions(1, out rowCount, out columnCount); for (int i = 0; i < rowCount; i++) { SpreadsheetGear.CustomFunctions.IValue value = arguments.GetArrayValue(1, i, 0); if (value.Text == MaterialName) { result.Number = arguments.GetArrayValue(1, i, 1).Number; findit = true; break; } } } if (!findit) { arguments.GetArrayDimensions(2, out rowCount, out columnCount); for (int i = 0; i < rowCount; i++) { SpreadsheetGear.CustomFunctions.IValue value = arguments.GetArrayValue(2, i, 0); if (value.Text == MaterialName) { result.Number = arguments.GetArrayValue(2, i, 1).Number; findit = true; break; } } } if (!findit) { arguments.GetArrayDimensions(3, out rowCount, out columnCount); for (int i = 0; i < rowCount; i++) { SpreadsheetGear.CustomFunctions.IValue value = arguments.GetArrayValue(3, i, 0); if (value.Text == MaterialName) { result.Number = arguments.GetArrayValue(3, i, 1).Number; findit = true; break; } } } if (!findit) { result.Error = SpreadsheetGear.ValueError.Value; } } } else { result.Error = SpreadsheetGear.ValueError.Value; } }
public override void Evaluate(SpreadsheetGear.CustomFunctions.IArguments arguments, SpreadsheetGear.CustomFunctions.IValue result) { result.Text = arguments.CurrentWorksheet.Workbook.Name; }