Copying a Workbook does not preserve the state of ComboBoxes

Hi there

I just noticed that copying a worksheet does not preserve the state of the combo boxes within. Please have a look at the attached excel sheet and code.

I open a workbook containing a combobox whose selected index is 4.

The values from the combo box and the linked cell are are:
Original Values ->
SelectedIndex: 4
SelectedValue: Choice 5
SelectedCell.StringValue: Choice 5
linkedCell.StringValue: 5

If I copy the worksheet, the values I get are:
Copied Values ->
SelectedIndex: -1
SelectedValue: 'empty'
SelectedCell.StringValue: 'null'
linkedCell.StringValue: 5

You'll notice that the state of the linked cell gets copied correctly but the state of the combo box is not.


Hi Lukas,

Thanks for providing us simulation code with template excel file.

After an initial test, we found the issue as you have described.

Your issue has been logged into our internal issue tracking system with an issue id: CELLSNET-11715. We will figure it out and let you know about it soon.

Thank you.

Hi Lukas,

Thank you for considering Aspose.

Please try the attached latest version of Aspose.Cells. We have fixed your mentioned issue.

Thank You & Best Regards,

Hi Nausherwan

Works nicely.



The issues you have found earlier (filed as 11715) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.