public void AsRangeTests()
{
XLRangeAddress rangeAddress;
rangeAddress = new XLRangeAddress
(
new XLAddress(1, 1, false, false),
new XLAddress(5, 5, false, false)
);
Assert.IsTrue(rangeAddress.IsValid);
Assert.IsTrue(rangeAddress.IsNormalized);
Assert.Throws <InvalidOperationException>(() => rangeAddress.AsRange());
var ws = new XLWorkbook().AddWorksheet() as XLWorksheet;
rangeAddress = new XLRangeAddress
(
new XLAddress(ws, 1, 1, false, false),
new XLAddress(ws, 5, 5, false, false)
);
Assert.IsTrue(rangeAddress.IsValid);
Assert.IsTrue(rangeAddress.IsNormalized);
Assert.DoesNotThrow(() => rangeAddress.AsRange());
}
public void RangeAddressNormalizeTest(string inputAddress, string expectedAddress)
{
XLWorksheet ws = new XLWorkbook().Worksheets.Add("Sheet 1") as XLWorksheet;
var rangeAddress = new XLRangeAddress(ws, inputAddress);
var normalizedAddress = rangeAddress.Normalize();
Assert.AreSame(ws, rangeAddress.Worksheet);
Assert.AreEqual(expectedAddress, normalizedAddress.ToString());
}
public void FindIntersectionsAfterRowShifting()
{
using (var wb = new XLWorkbook())
{
var ws = wb.Worksheets.Add("Sheet1") as XLWorksheet;
var index = FillIndexWithTestData(ws);
ws.Row(10).InsertRowsBelow(3);
var rangeAddress = new XLRangeAddress(ws, "C103:E103");
Assert.True(index.Intersects(in rangeAddress));
}
}
public void FindIntersectionsAfterColumnShifting()
{
using (var wb = new XLWorkbook())
{
var ws = wb.Worksheets.Add("Sheet1") as XLWorksheet;
var index = FillIndexWithTestData(ws);
ws.Column(3).InsertColumnsBefore(2);
var rangeAddress = new XLRangeAddress(ws, "F102:E103");
Assert.True(index.Intersects(in rangeAddress));
}
}
public void CanGetAllDataValidationsForRange(string searchAddress, int expectedCount)
{
using (var wb = new XLWorkbook())
{
var ws = wb.AddWorksheet();
var dv1 = ws.Range("A1:A3").SetDataValidation();
dv1.MinValue = "100";
dv1.AddRange(ws.Range("C1:C3"));
var dv2 = ws.Range("E4:G6").SetDataValidation();
dv2.MinValue = "200";
var address = new XLRangeAddress(ws as XLWorksheet, searchAddress);
var actualResult = ws.DataValidations.GetAllInRange(address);
Assert.AreEqual(expectedCount, actualResult.Count());
}
}
public void FindNonExistingIntersections()
{
using (var wb = new XLWorkbook())
{
var ws = wb.Worksheets.Add("Sheet1") as XLWorksheet;
var index = FillIndexWithTestData(ws);
for (int i = 1; i <= TEST_COUNT; i++)
{
var rangeAddress = new XLRangeAddress(
new XLAddress(ws, i * 2 + 1, 1 + i % 4, false, false),
new XLAddress(ws, i * 2 + 1, 8 - i % 3, false, false));
Assert.False(index.Intersects(in rangeAddress));
}
var columnAddress = XLRangeAddress.EntireColumn(ws, 1);
Assert.False(index.Intersects(in columnAddress));
columnAddress = XLRangeAddress.EntireColumn(ws, 5);
Assert.False(index.Intersects(in columnAddress));
}
}
public void CanFindDataValidationForRange(string searchAddress, bool expectedResult)
{
using (var wb = new XLWorkbook())
{
var ws = wb.AddWorksheet();
var dv = ws.Range("A1:A3").SetDataValidation();
dv.MinValue = "100";
dv.AddRange(ws.Range("C1:C3"));
var address = new XLRangeAddress(ws as XLWorksheet, searchAddress);
var actualResult = ws.DataValidations.TryGet(address, out var foundDv);
Assert.AreEqual(expectedResult, actualResult);
if (expectedResult)
{
Assert.AreSame(dv, foundDv);
}
else
{
Assert.IsNull(foundDv);
}
}
}
public new IEnumerable <T> GetIntersectedRanges(XLRangeAddress rangeAddress)
{
return(base.GetIntersectedRanges(rangeAddress).Cast <T>());
}
public XLRangeParameters(XLRangeAddress rangeAddress, IXLStyle defaultStyle)
{
RangeAddress = rangeAddress;
DefaultStyle = defaultStyle;
}
public XLRangeParameters(XLRangeAddress rangeAddress, IXLStyle defaultStyle)
{
RangeAddress = rangeAddress;
_ignoreEvents = !rangeAddress.Worksheet.EventTrackingEnabled;
DefaultStyle = defaultStyle;
}
public XLRangeParameters(XLRangeAddress rangeAddress, IXLStyle defaultStyle)
{
RangeAddress = rangeAddress;
_ignoreEvents = !rangeAddress.Worksheet.EventTrackingEnabled;
DefaultStyle = defaultStyle;
}
