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); }