public static void AreNamedRangesEquals(IXLNamedRanges expected, IXLNamedRanges actual)
{
Assert.AreEqual(expected.Count(), actual.Count(), "Worksheet named ranges count failed");
foreach (IXLNamedRange expectedNamedRange in expected)
{
IXLNamedRange actualNamedRange = actual.NamedRange(expectedNamedRange.Name);
Assert.AreEqual(expectedNamedRange.Comment, actualNamedRange.Comment, $"Named range {expectedNamedRange.Name} comment failed");
Assert.AreEqual(expectedNamedRange.Ranges.Count, actualNamedRange.Ranges.Count, $"Named range {expectedNamedRange.Name} ranges count failed");
for (int i = 0; i < expectedNamedRange.Ranges.Count; i++)
{
IXLRange expectedRange = expectedNamedRange.Ranges.ElementAt(i);
IXLRange actualRange = actualNamedRange.Ranges.ElementAt(i);
Assert.AreEqual(expectedRange.FirstCell().Address, actualRange.FirstCell().Address, $"Named range {expectedNamedRange.Name} range {i + 1} first cell address failed");
Assert.AreEqual(expectedRange.LastCell().Address, actualRange.LastCell().Address, $"Named range {expectedNamedRange.Name} range {i + 1} last cell address failed");
}
}
}
private IList <IXLNamedRange> GetPanelsNamedRanges(IXLNamedRanges namedRanges)
{
return(namedRanges.Where(r => Regex.IsMatch(r.Name, PanelsRegexPattern, RegexOptions.IgnoreCase)).ToList());
}
private void MoveNamedRangesColumns(XLRange range, int columnsShifted, IXLNamedRanges namedRanges)
{
foreach (XLNamedRange nr in namedRanges)
{
var newRangeList =
nr.RangeList.Select(r => XLCell.ShiftFormulaColumns(r, this, range, columnsShifted)).Where(
newReference => newReference.Length > 0).ToList();
nr.RangeList = newRangeList;
}
}
