public void Sum() { IXLCell cell = new XLWorkbook().AddWorksheet("Sheet1").FirstCell(); IXLCell fCell = cell.SetValue(1).CellBelow().SetValue(2).CellBelow(); fCell.FormulaA1 = "sum(A1:A2)"; Assert.AreEqual(3.0, fCell.Value); }
public void Sum() { IXLCell cell = new XLWorkbook().AddWorksheet("Sheet1").FirstCell(); IXLCell fCell = cell.SetValue(1).CellBelow().SetValue(2).CellBelow(); fCell.FormulaA1 = "sum(A1:A2)"; Assert.AreEqual(3.0, fCell.Value); }