public void CanCreateInvalidSparklineWithoutSourceData()
{
var ws = new XLWorkbook().AddWorksheet("Sheet1");
var group = new XLSparklineGroup(ws);
var sparkline = new XLSparkline(group, ws.FirstCell(), null);
Assert.IsFalse(sparkline.IsValid);
}
public void CannotCreateSparklineWithoutLocation()
{
var ws = new XLWorkbook().AddWorksheet("Sheet1");
var group = new XLSparklineGroup(ws);
TestDelegate action = () => new XLSparkline(group, null, ws.Range("A2:A5"));
Assert.Throws <ArgumentNullException>(action);
}
public void CannotAddSparklineFromDifferentWorksheet()
{
var wb = new XLWorkbook();
var ws1 = wb.AddWorksheet("Sheet 1");
var ws2 = wb.AddWorksheet("Sheet 2");
var group = new XLSparklineGroup(ws1);
TestDelegate action = () => group.Add(ws2.Cell("A3"), ws1.Range("B3:E3"));
var message = Assert.Throws <ArgumentException>(action).Message;
Assert.AreEqual("The specified sparkline belongs to the different worksheet", message);
}
public void CanAddSparklineToExistingGroup()
{
var ws = new XLWorkbook().AddWorksheet("Sheet 1");
var group = new XLSparklineGroup(ws);
group.Add("A2", "B2:E2");
group.Add(ws.Cell("A3"), ws.Range("B3:E3"));
Assert.AreEqual(0, ws.SparklineGroups.Count());
Assert.AreEqual("A2", group.ElementAt(0).Location.Address.ToString());
Assert.AreEqual("A3", group.ElementAt(1).Location.Address.ToString());
Assert.AreEqual("B2:E2", group.ElementAt(0).SourceData.RangeAddress.ToString());
Assert.AreEqual("B3:E3", group.ElementAt(1).SourceData.RangeAddress.ToString());
}
