GrapeCity.Documents.Excel.Forms.ISelector.ItemsSourceRange

ItemsSourceRange Property

ItemsSourceRange

Gets or sets the items source of this control.

This property can't be used if items were added to Items. When an items source range is set, the control reads its items from that worksheet range instead of from the items collection.

This property doesn't handle #REF! errors. #REF! will be treated as an empty collection.

Declaration

IRange ItemsSourceRange { get; set; }

Property ItemsSourceRange As IRange

Examples

ISelector selector = worksheet.Controls.AddDropDown(20, 20, 120, 20);
worksheet.Range["A1:A3"].Value = new object[,] {{"Pending"}, {"Approved"}, {"Rejected"}};
selector.ItemsSourceRange = worksheet.Range["A1:A3"];
IRange range = selector.ItemsSourceRange;