public static object MOD(object _x, object _y)
{
var x = OPs.xl2dbl(_x);
var y = OPs.xl2dbl(_y);
var d = Math.Truncate(x / y);
return(x - d * y);
}
public static object DAY(object date)
{
if (W.Common.Utils.IsEmpty(date))
{
return(DBNull.Value);
}
return(OPs.FromExcelDate(OPs.xl2dbl(date)).Day);
}
public static object Divide(object arg)
{
return(Utils.Calc(arg, 2, 1, data =>
{
var r = OPs.xl2dbl(data[0]) / OPs.xl2dbl(data[1]);
if (double.IsNaN(r))
{
return null;
}
else
{
return OPs.WithTime(data[0], data[1], r);
}
}));
}
public static object LOG(object x, object y)
{
return(Math.Log(OPs.xl2dbl(x), OPs.xl2dbl(y)));
}
public static object ROUND(object x, object nDigits)
{
return(Math.Round(OPs.xl2dbl(x), Convert.ToInt32(nDigits)));
}
public static object POWER(object x, object y)
{
return(Math.Pow(OPs.xl2dbl(x), OPs.xl2dbl(y)));
}
public static object SQRT(object x)
{
return(Math.Sqrt(OPs.xl2dbl(x)));
}
public static object LN(object x)
{
return(Math.Log(OPs.xl2dbl(x)));
}
public static object EXP(object x)
{
return(Math.Exp(OPs.xl2dbl(x)));
}
public static object ATAN2(object x, object y)
{
return(Math.Atan2(OPs.xl2dbl(x), OPs.xl2dbl(y)));
}
public static object ATAN(object x)
{
return(Math.Atan(OPs.xl2dbl(x)));
}
public static object COS(object x)
{
return(Math.Cos(OPs.xl2dbl(x)));
}
public static object SIN(object x)
{
return(Math.Sin(OPs.xl2dbl(x)));
}
public static object INT(object x)
{
return(Math.Floor(OPs.xl2dbl(x)));
}
public static object ABS(object x)
{
return(Math.Abs(OPs.xl2dbl(x)));
}
