isSuppressDropDownArrow property
Gets or sets the isSuppressDropDownArrow.
//Creating one worksheet and accessing the first sheet
final Workbook workbook = Workbook(1);
final Worksheet sheet = workbook.worksheets[0];
//Accessing the first cell in excel-sheet and applying the User properties
final DataValidation listValidation =
sheet.getRangeByName('A1').dataValidation;
// sets the allowtype with User type
listValidation.allowType = ExcelDataValidationType.user;
// sets the list of values
listValidation.listOfValues = <String>['List1', 'List2', 'List3'];
// sets the errorBoxText
listValidation.errorBoxText = 'The value given in list should be given';
//sets the errorBoxTitle
listValidation.errorBoxTitle = 'ERROR';
//sets the promptBoxText
listValidation.promptBoxText = 'Data validation for list';
//sets the showPromptBox
listValidation.showPromptBox = true;
//sets the isSuppressDropDownArrow
listValidation.isSuppressDropDownArrow = true;
//Save and dispose Workbook
final List<int> bytes = workbook.saveAsStream();
saveAsExcel(bytes, 'ExcelUserValidation.xlsx');
workbook.dispose();
Implementation
late bool isSuppressDropDownArrow;