public void CountAShouldIncludeEnumerableMembers()
{
var func = new CountA();
var args = FunctionsHelper.CreateArgs(1d, FunctionsHelper.CreateArgs(12, 13));
var result = func.Execute(args, _parsingContext);
Assert.AreEqual(3d, result.Result);
}
public void CountAShouldReturnNumberOfNonWhitespaceItems()
{
var func = new CountA();
var args = FunctionsHelper.CreateArgs(1d, 2m, 3, new DateTime(2012, 4, 1), "4", null, string.Empty);
var result = func.Execute(args, _parsingContext);
Assert.AreEqual(5d, result.Result);
}
public void CountAWithEmptyString()
{
var function = new CountA();
var arguments = FunctionsHelper.CreateArgs(string.Empty);
var result = function.Execute(arguments, this.ParsingContext);
Assert.AreEqual(1d, result.Result);
}
public void CountAWithSingleNumber()
{
var function = new CountA();
var arguments = FunctionsHelper.CreateArgs(2);
var result = function.Execute(arguments, this.ParsingContext);
Assert.AreEqual(1d, result.Result);
}
public void CountAWithInvalidArgumentReturnsPoundValue()
{
var func = new CountA();
var parsingContext = ParsingContext.Create();
var args = FunctionsHelper.CreateArgs();
var result = func.Execute(args, parsingContext);
Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)result.Result).Type);
}
public void CountAWithNullParameter()
{
// The COUNTA function in Excel will count a null argument value if it is entered directly
// in the function's input. Null cells entered through cell references are still ignored as expected.
var function = new CountA();
var arguments = FunctionsHelper.CreateArgs(3, null);
var result = function.Execute(arguments, this.ParsingContext);
Assert.AreEqual(2d, result.Result);
}
public void CountAShouldIgnoreHiddenValuesIfIgnoreHiddenValuesIsTrue()
{
var func = new CountA();
func.IgnoreHiddenValues = true;
var args = FunctionsHelper.CreateArgs(1d, FunctionsHelper.CreateArgs(12, 13));
args.ElementAt(0).SetExcelStateFlag(ExcelCellState.HiddenCell);
var result = func.Execute(args, _parsingContext);
Assert.AreEqual(2d, result.Result);
}