search

PHPOffice / PHPExcel

ARCHIVED
Other
11.46k stars 4.19k forks source link

PHPExcel - How to select a default value in a dropdown list #1349

Open AlexP5 opened 6 years ago

AlexP5 commented 6 years ago

Hi, I would like to know if you can set a default value in a dropdown list.

My PHP code

$objValidation = $objPHPExcel->getActiveSheet()->getCell($cell_key') ->getDataValidation(); $objValidation->setType( PHPExcel_Cell_DataValidation::TYPE_LIST ); $objValidation->setErrorStyle( PHPExcel_Cell_DataValidation::STYLE_INFORMATION ); $objValidation->setAllowBlank(false); $objValidation->setShowInputMessage(true); $objValidation->setShowErrorMessage(true); $objValidation->setShowDropDown(true); $objValidation->setErrorTitle('Input error'); $objValidation->setError('Value is not in list.'); $objValidation->setPromptTitle('Pick from list'); $objValidation->setPrompt('Please pick a value from the drop-down list.'); $objValidation->setFormula1('System!$A:$A');

Until here everything ok, the code works perfectly, but by default, the selected option is blank while I would like to have a concrete option selected.

It's possible?

syskp commented 6 years ago

Je moet je veld gewoon een waarde geven $objPHPExcel->getActiveSheet()->setCellValue("F" . $teller, "Selecteer kleur");