public void DeleteRowOnWorksheetWithComment() { var ws = new XLWorkbook().AddWorksheet(); ws.Cell(4, 1).Comment.AddText("test"); ws.Column(1).Width = 100; Assert.DoesNotThrow(() => ws.Row(1).Delete()); }
public void SparklineRemovedWhenShiftedTooFarRight() { var ws = new XLWorkbook().AddWorksheet("Sheet 1"); var group = ws.SparklineGroups.Add("XFD1", "A1:Z1"); ws.Column(1).InsertColumnsBefore(1); Assert.AreEqual(0, group.Count()); }
public void CellsUsedIncludeStyles2() { IXLWorksheet ws = new XLWorkbook().Worksheets.Add("Sheet1"); ws.Row(2).Style.Fill.BackgroundColor = XLColor.Red; ws.Column(2).Style.Fill.BackgroundColor = XLColor.Red; ws.Cell(3, 3).Value = "ASDF"; var range = ws.RangeUsed(true).RangeAddress.ToString(); Assert.AreEqual("B2:C3", range); }
public void SparklineRemovedWhenColumnDeleted() { var ws = new XLWorkbook().AddWorksheet("Sheet 1"); var group = ws.SparklineGroups.Add("A1:B1", "C2:D6"); ws.Column(2).Delete(); Assert.AreEqual(1, group.Count()); Assert.AreEqual("A1", group.Single().Location.Address.ToString()); Assert.AreEqual("B2:B6", group.Single().SourceData.RangeAddress.ToString()); }
public void SparklineRangeInvalidatedWhenDeleted() { var ws = new XLWorkbook().AddWorksheet("Sheet 1"); var group = ws.SparklineGroups.Add("A1:B1", "C2:D6"); ws.Column(4).Delete(); Assert.AreEqual(2, group.Count()); Assert.AreEqual("A1", group.First().Location.Address.ToString()); Assert.AreEqual("C2:C6", group.First().SourceData.RangeAddress.ToString()); Assert.AreEqual("B1", group.Last().Location.Address.ToString()); Assert.IsFalse(group.Last().SourceData.RangeAddress.IsValid); }
public void SparklinesShiftOnColumnInsert() { var ws = new XLWorkbook().AddWorksheet("Sheet 1"); var group1 = ws.SparklineGroups.Add("B2", "D4:F4"); var group2 = ws.SparklineGroups.Add("C3", "D4:D8"); var group3 = ws.SparklineGroups.Add("D4", "A4:E4"); ws.Column(2).InsertColumnsAfter(3); Assert.AreEqual("B2", group1.First().Location.Address.ToString()); Assert.AreEqual("G4:I4", group1.First().SourceData.RangeAddress.ToString()); Assert.AreEqual("F3", group2.First().Location.Address.ToString()); Assert.AreEqual("G4:G8", group2.First().SourceData.RangeAddress.ToString()); Assert.AreEqual("G4", group3.First().Location.Address.ToString()); Assert.AreEqual("A4:H4", group3.First().SourceData.RangeAddress.ToString()); }