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 CellsUsedIncludeStyles3() { IXLWorksheet ws = new XLWorkbook().Worksheets.Add("Sheet1"); var range = ws.RangeUsed(true); Assert.AreEqual(null, range); }