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