We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Adding a ComboBox to a Worksheet in Java

Hi i'm using Cells 7.5.1. The Method

//Add a new combo box.
ComboBox comboBox = sheet.getShapes().addComboBox(2, 0, 2, 0, 22, 100);
you guys mention in all your documentations doesn't exist. How can i add a combobox?
Cheers, Golo


Please use ShapeCollection.addShape() method to specify your desired controls or drawing objects, e.g
//Add a new combo box.
com.aspose.cells.ComboBox comboBox = (com.aspose.cells.ComboBox)sheet.getShapes().addShape(MsoDrawingType.COMBO_BOX,3, 0, 1, 0, 20, 100);

See the topic for your reference:
Working with Controls
( please see the description text and example codes under “Adding ComboBox Control to the Worksheet” sub-topic)

Thank you.