public void OnlyDirectReferences()
{
// Make sure A1:A10 isn't returned as "A1:A10", "A1" and "A10"
var fa = new FormulaAnalyzer("SUM(A1:A10)");
var references = fa.References().ToList();
Assert.AreEqual(1, references.Count());
CollectionAssert.Contains(references.Select(ExcelFormulaParser.Print).ToList(), "A1:A10");
}
public void OnlyDirectReferences()
{
// Make sure A1:A10 isn't returned as "A1:A10", "A1" and "A10"
var fa = new FormulaAnalyzer("SUM(A1:A10)");
var references = fa.References().ToList();
CollectionAssert.AreEqual(references.Select(ExcelFormulaParser.Print).ToList(), new [] { "A1:A10" });
fa = new FormulaAnalyzer("(A1)+2");
references = fa.References().ToList();
CollectionAssert.AreEqual(references.Select(ExcelFormulaParser.Print).ToList(), new [] {"A1" });
}
