public void FixedInt()
{
var fa = new FormulaAnalyzer("3");
var nums = fa.Numbers().ToList();
CollectionAssert.Contains(nums, 3.0);
Assert.AreEqual(1, nums.Count());
}
public void FixedNumbers()
{
var fa = new FormulaAnalyzer("SUM(A1,3.1+4)");
var nums = fa.Numbers().ToList();
CollectionAssert.Contains(nums, 3.1);
CollectionAssert.Contains(nums, 4.0);
Assert.AreEqual(2, nums.Count());
}
public void Duplicate()
{
var fa = new FormulaAnalyzer("3+3");
var nums = fa.Numbers().ToList();
Assert.AreEqual(2, nums.Count());
}
public void NoFixedNumbers()
{
var fa = new FormulaAnalyzer("A1+B2");
var nums = fa.Numbers().ToList();
Assert.AreEqual(0, nums.Count());
}
public void NegativeNumber()
{
var fa = new FormulaAnalyzer("=-8+A1");
var nums = fa.Numbers().ToList();
CollectionAssert.AreEqual(new[] { -8.0 }, nums);
}