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; } }