ComboBox/OptionBox in Excel

Topics: User Forum
Dec 10, 2009 at 7:42 AM
Edited Dec 10, 2009 at 8:49 AM


I would like to create a cell with an optionbox. Is it possible to add a certain array of values into a cell, so you can select them from a combobox in this cell ? <-- like the combobox here?

How do I create this with an Excel5 document. The only thing I found was this:

I copied the code, but it gave no result...


The code:


PHPExcel: PHPExcel 1.7.1 Production

PHP Version 5.2.4-2ubuntu5.3 -> dev

PHP Version 5.1.6 -> production


Kind regards

J Verdeyen

Jan 20, 2010 at 12:41 PM

What you are asking for is a combo box form control element. The thread you linked to was about data validation which is a bit different although the drop-downs may look alike.

It will be difficult to add support for combo boxes and other form control elements in Excel. Because they involve the Office Drawing specification which is a monster.

I think support for combo boxes is unlikely to come in the near future in PHPExcel.