DropDown Control Missing after Save

When saving an XLSX file  the DropDown controls are mssing from the workbook

FlexCel.XlsAdapter.XlsFile flex_workbook = new FlexCel.XlsAdapter.XlsFile(long_file_name, true);
flex_workbook.AllowOverwritingFiles = true;
flex_workbook.Save(new_long_file_name);




Hi,

Do you have more information about what is failing? I've just tried a project like yours here, and the combobox is correctly preserved:

http://www.tmssoftware.biz/flexcel/samples/drowdown.zip

FlexCel fully supports them, and will even convert them from xls to xlsx to xls. You can even change the selected item from FlexCel.

What we don't preserve is ActiveX controls (those are below the "forms" objects in the Developer tab of the ribbon. But ActiveX controls have been deprecated for a long time already, they look and behave like win3.1 controls, and there is no really a valid reason to use them instead of the form controls.

But from what I see in your screen shot, it looks like a "Forms" dropdown, not an activex one. If this is the case, I am not sure on why it wouldn't be preserved. If you want you can send me the file to adrian@tmssoftware.com and I can take a look.

Sorry about that, it would seem my test environment was running different code than I thought.


Works perfectly for combo boxes :)

Thanks