public void UngroupFromAll()
{
IXLWorksheet ws = new XLWorkbook().AddWorksheet("Sheet1");
ws.Columns(1, 2).Group();
ws.Columns(1, 2).Ungroup(true);
}
public void SparklinesShiftOnColumnDelete()
{
var ws = new XLWorkbook().AddWorksheet("Sheet 1");
var group1 = ws.SparklineGroups.Add("B2", "G4:I4");
var group2 = ws.SparklineGroups.Add("F3", "G4:G8");
var group3 = ws.SparklineGroups.Add("G4", "A4:H4");
ws.Columns(3, 5).Delete();
Assert.AreEqual("B2", group1.First().Location.Address.ToString());
Assert.AreEqual("D4:F4", group1.First().SourceData.RangeAddress.ToString());
Assert.AreEqual("C3", group2.First().Location.Address.ToString());
Assert.AreEqual("D4:D8", group2.First().SourceData.RangeAddress.ToString());
Assert.AreEqual("D4", group3.First().Location.Address.ToString());
Assert.AreEqual("A4:E4", group3.First().SourceData.RangeAddress.ToString());
}
