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)
{
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 IXLNamedRange Add(String rangeName, IXLRanges ranges, String comment)
{
var namedRange = new XLNamedRange(this, rangeName, ranges, comment);
_namedRanges.Add(rangeName, namedRange);
return namedRange;
}
public IXLNamedRange Add(String rangeName, IXLRanges ranges)
{
return Add(rangeName, ranges, null);
}
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 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)));
}
public IXLRanges Add(IXLRanges ranges)
{
ranges.ForEach(r => RangeList.Add(r.ToString()));
return(ranges);
}
public IXLNamedRange Add(String rangeName, IXLRanges ranges)
{
return(Add(rangeName, ranges, null));
}
