[]
ICellLinkControl, ICellLinkControlT<Integer>, IControl, IControlT<IDropDown>, ISelector, ISelectorT<DropDownItem,IDropDownItemList> A drop-down control displays a list of DropDownItem objects and lets users choose a single item from the list. Use IControlCollection.addDropDown(double,double,double,double) to add a drop-down control to a worksheet, then populate it through ISelectorT.getItems() or bind it to a worksheet range through the inherited selector APIs.
IDropDown dropDown = worksheet.getControls().addDropDown(20, 20, 120, 20);
dropDown.getItems().add(new DropDownItem("Pending"));
dropDown.getItems().add(new DropDownItem("Approved"));
dropDown.setDropDownLines(4);
dropDown.setSelectedIndex(0);
intvoidsetDropDownLines(int value) getDisplay3DShading, getLinkedCell, setDisplay3DShading, setLinkedCellgetValue, setValuebringToFront, delete, getBottomRightCell, getEnabled, getFormControlType, getHeight, getLeft, getLocked, getName, getParent, getPlacement, getPrintObject, getShapeRange, getTop, getTopLeftCell, getVisible, getWidth, getZOrder, sendToBack, setEnabled, setHeight, setLeft, setLocked, setName, setPlacement, setPrintObject, setTop, setVisible, setWidthgetItemsSourceRange, getSelectedIndex, setItemsSourceRange, setSelectedIndexgetItems, getSelectedItemUse setDropDownLines(int) to change the value.
IDropDown dropDown = worksheet.getControls().addDropDown(20, 20, 120, 20);
dropDown.getItems().add(new DropDownItem("Pending"));
dropDown.getItems().add(new DropDownItem("Approved"));
dropDown.setDropDownLines(4);
int lines = dropDown.getDropDownLines();
8 if the value has not been set explicitly.
IDropDown dropDown = worksheet.getControls().addDropDown(20, 20, 120, 20);
dropDown.getItems().add(new DropDownItem("Pending"));
dropDown.getItems().add(new DropDownItem("Approved"));
dropDown.setDropDownLines(4);
value - The number of items displayed when the drop-down list is expanded. The default value is 8 if the value has not been set explicitly.