diff --git a/ClosedXML_Tests/Excel/Ranges/UsedAndUnusedCellsTests.cs b/ClosedXML_Tests/Excel/Ranges/UsedAndUnusedCellsTests.cs index fab9b91..abced23 100644 --- a/ClosedXML_Tests/Excel/Ranges/UsedAndUnusedCellsTests.cs +++ b/ClosedXML_Tests/Excel/Ranges/UsedAndUnusedCellsTests.cs @@ -129,5 +129,21 @@ } Assert.AreEqual(15, i); } + + [Test] + public void GetCellsUsedNonRectangular() + { + using (XLWorkbook wb = new XLWorkbook()) + { + var sheet = wb.AddWorksheet("page1"); + + sheet.Range("C1:E1").Value = "row1"; + sheet.Range("A2:E2").Value = "row2"; + + var used = sheet.RangeUsed().RangeAddress.ToString(XLReferenceStyle.A1); + + Assert.AreEqual("A1:E2", used); + } + } } }