ComboBox/OptionBox in Excel

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

Hi,

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 ?

http://www.techonthenet.com/excel/macros/images/combo_update002.png <-- like the combobox here?

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

http://phpexcel.codeplex.com/Thread/View.aspx?ThreadId=57447

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

 

The code:

http://pastebin.com/m17ea6fa4

 

PHPExcel: PHPExcel 1.7.1 Production

PHP Version 5.2.4-2ubuntu5.3 -> dev

PHP Version 5.1.6 -> production

 

Kind regards

J Verdeyen

Developer
Jan 20, 2010 at 11:41 AM

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.