public void XorShouldReturnCorrectResult()
{
var func = new Xor();
var args = FunctionsHelper.CreateArgs(true, false);
var result = func.Execute(args, ParsingContext.Create());
Assert.IsTrue((bool)result.Result);
args = FunctionsHelper.CreateArgs(false, false);
result = func.Execute(args, ParsingContext.Create());
Assert.IsFalse((bool)result.Result);
args = FunctionsHelper.CreateArgs(true, true);
result = func.Execute(args, ParsingContext.Create());
Assert.IsFalse((bool)result.Result);
using (var package = new ExcelPackage())
{
var sheet = package.Workbook.Worksheets.Add("test");
sheet.Cells["A1"].Value = true;
sheet.Cells["A2"].Value = 0;
sheet.Cells["A3"].Formula = "XOR(A1:A2,DATE(2020,12,10))";
sheet.Calculate();
Assert.IsFalse((bool)sheet.Cells["A3"].Value);
}
}
