Currently we are using licensed version of aspose-cells02.5.04,but as per requirement , i have to add combobox dynamically in x-cell report and value also need to be set while generationg report and should be editable after opening the xls report.
I got following code to add combobox in xls report but unable to set a value using setText method(i mean i am able to set but after opening the generated report if i will select any other value,then both values are becoming overlap due to this i am not able to see selected value with 100%clarity).
Please let me know how to set a value with out any issues.
Workbook wb = new Workbook();
// Get the first worksheet.
Worksheet sheet1 = wb.
Cells cells1 = sheet1.getCells();
com.aspose.cells.ComboBox comboBox = sheet1.getShapes().addComboBox(3, 5, 20, 0, 525, 15);
// Saves the file.