Exemple #1
0
 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;
     }
 }
Exemple #2
0
        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;
            }
        }
Exemple #3
0
 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;
     }
 }
Exemple #4
0
        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;
            }
        }