Annotation Type ExcelDropDown
The Interface ExcelDropDown.
Excel Drop Down is used to create a drop down list that references another table within the Excel file.
It is composed by:
Excel Drop Down is used to create a drop down list that references another table within the Excel file.
It is composed by:
- AreaRange - to set the list by formula function
- SuppressDropDownArrow - to show/hide the values into a drop down list
-
Required Element Summary
Required Elements -
Optional Element Summary
Optional ElementsModifier and TypeOptional ElementDescriptionAlias.Error box.booleanSuppress drop down arrow.
-
Element Details
-
areaRange
String areaRangeArea range.- Returns:
- the string
-
suppressDropDownArrow
boolean suppressDropDownArrowSuppress drop down arrow.- Returns:
- true, if successful
- Default:
true
-
alias
ExcelFormulaAlias[] aliasAlias.- Returns:
- the excel formula alias[]
- Default:
{}
-
errorBox
ExcelBoxMessage errorBoxError box.- Returns:
- the excel box message
- Default:
@bld.generator.report.excel.annotation.ExcelBoxMessage(boxStyle=STOP, message="The value is not valid", title="Error")
-