title: How to increase cell character limit PHPExcel TYPE LIST
body: <p>Using PHPExcel to create a dropdown list like so:</p>
  
  <pre><code>$objValidation = $objPHPExcel-&gt;getActiveSheet()-&gt;getCell("A".$i)-&gt;getDataValidation();
  $objValidation-&gt;setType( \PHPExcel_Cell_DataValidation::TYPE_LIST );
  $objValidation-&gt;setErrorStyle( \PHPExcel_Cell_DataValidation::STYLE_INFORMATION );
  $objValidation-&gt;setAllowBlank(false);
  $objValidation-&gt;setShowInputMessage(true);
  $objValidation-&gt;setShowErrorMessage(true);
  $objValidation-&gt;setShowDropDown(true);
  $objValidation-&gt;setErrorTitle('Input error');
  $objValidation-&gt;setError('Value is not in list.');
  $objValidation-&gt;setPromptTitle('Pick from list');
  $objValidation-&gt;setPrompt('Please pick a value from the drop-down list.');
  $formulaString = '"' .  implode(", ", $items_array) . '"';
  $objValidation-&gt;setFormula1($formulaString);
  
  $objWriter = new \PHPExcel_Writer_Excel2007($objPHPExcel);
  $filename = "MyExcel.xlsx";
  header('Content-Type: application/vnd.ms-excel');
  header('Content-Disposition: attachment;filename="'.$filename.'"');
  header('Cache-Control: max-age=0');
  $objWriter-&gt;save('php://output');
  </code></pre>
  
  <p>The problem is it cuts off at <code>1023</code> characters hence breaking the "dropdown" function.</p>
  
  <p>How do I increase the character limit?</p>