isSuppressDropDownArrow property

bool isSuppressDropDownArrow
getter/setter pair

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;