public XLNamedRange(XLNamedRanges namedRanges, String rangeName, IXLRanges ranges, String comment = null) { Name = rangeName; ranges.ForEach(r => _rangeList.Add(r.RangeAddress.ToStringFixed(XLReferenceStyle.A1, true))); Comment = comment; _namedRanges = namedRanges; }
public XLDataValidation(IXLRanges ranges) : this() { ranges.ForEach(range => { Ranges.Add(new XLRange(new XLRangeParameters((XLRangeAddress)range.RangeAddress, range.Worksheet.Style))); }); }
public XLDataValidation(IXLRanges ranges) { Ranges = new XLRanges(); ranges.ForEach(r=> { var newR = new XLRange(new XLRangeParameters(r.RangeAddress as XLRangeAddress, r.Worksheet.Style) {IgnoreEvents = true}); (Ranges as XLRanges).Add(newR); } ); Initialize(); }
public IXLNamedRange SetRefersTo(IXLRanges ranges) { _rangeList.Clear(); ranges.ForEach(r => _rangeList.Add(r.RangeAddress.ToStringFixed(XLReferenceStyle.A1, true))); return this; }
public void Remove(IXLRanges ranges) { ranges.ForEach(r => _rangeList.Remove(r.ToString())); }
public IXLRanges Add(IXLRanges ranges) { ranges.ForEach(r => _rangeList.Add(r.ToString())); return ranges; }
public IXLRanges Add(IXLRanges ranges) { ranges.ForEach(r => _rangeList.Add(r.ToString())); return(ranges); }
public IXLNamedRange SetRefersTo(IXLRanges ranges) { _rangeList.Clear(); ranges.ForEach(r => _rangeList.Add(r.RangeAddress.ToStringFixed(XLReferenceStyle.A1, true))); return(this); }
public XLNamedRange(XLNamedRanges namedRanges, String rangeName, IXLRanges ranges, String comment = null) : this(namedRanges, rangeName, validateName : true, comment) { ranges.ForEach(r => RangeList.Add(r.RangeAddress.ToStringFixed(XLReferenceStyle.A1, true))); }