I'm trying to display bunch of items in dropdown list of phpspreadsheet. It's working if the dropdown has only 1-5 items but when I try to add list with 35 items, it's not working
Here's my code
$validation = $sheet->getCell('I2')->getDataValidation();
$validation->setType( \PhpOffice\PhpSpreadsheet\Cell\DataValidation::TYPE_LIST );
$validation->setErrorStyle( \PhpOffice\PhpSpreadsheet\Cell\DataValidation::STYLE_INFORMATION );
$validation->setAllowBlank(false);
$validation->setShowInputMessage(true);
$validation->setShowErrorMessage(true);
$validation->setShowDropDown(true);
$validation->setErrorTitle('Input error');
$validation->setError('Value is not in list.');
$validation->setPromptTitle('Pick from list');
$validation->setPrompt('Please pick a value from the drop-down list.');
$sheet->setCellValue('I2', 'Choose GL Accounts');
$validation->setFormula1('"'.$glaccounts.'"');
$glaccounts has 35 items.
How can I increase the limit of the dropdown?