PHPSpreadsheet dropdown item limit

Viewed 1306

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?

0 Answers
Related