private static void Confirm(ValueEval arg0, ValueEval arg1, double expectedResult)
{
ValueEval[] args =
{
arg0, arg1,
};
double result = NumericFunctionInvoker.Invoke(EvalInstances.Divide, args, 0, 0);
Assert.AreEqual(expectedResult, result, 0);
}
private static void Confirm(ValueEval arg, double expectedResult)
{
ValueEval[] args =
{
arg,
};
double result = NumericFunctionInvoker.Invoke(PercentEval.instance, args, 0, 0);
Assert.AreEqual(expectedResult, result, 0);
}
private void Confirm(ValueEval arg, double expectedResult)
{
ValueEval[] args =
{
arg,
};
NPOI.HSSF.Record.Formula.Functions.Function opEval = PercentEval.instance;
double result = NumericFunctionInvoker.Invoke(opEval, args, -1, (short)-1);
Assert.AreEqual(expectedResult, result, 0);
}
public void TestColumnOperand()
{
short firstRow = (short)8;
short lastRow = (short)12;
short colNum = (short)5;
AreaPtg areaPtg = new AreaPtg(firstRow, lastRow, colNum, colNum, false, false, false, false);
ValueEval[] values =
{
new NumberEval(27),
new NumberEval(29),
new NumberEval(35), // value in row 10
new NumberEval(37),
new NumberEval(38),
};
ValueEval[] args =
{
EvalFactory.CreateAreaEval(areaPtg, values),
};
double result = NumericFunctionInvoker.Invoke(UnaryPlusEval.instance, args, 10, (short)20);
Assert.AreEqual(35, result, 0);
}
