We have added activeX control, i.e. activeX buttons on worksheet. However, after save/export to a new .xlsx workbook, the control is missing. Here are steps:
1. Please see attached original .xlsx file: activeXButton.xlsx, unzipped and open the openXML packet, you will see it contains \activeXButton\xl\activeX\ folder.
2. I read original.xlsx to aspose workbook object, then save it to a new file by calling
3. Open the attached activeXButtonAfterCopy.xlsx, you will see there is no any activeX control information there.
I understand aspose.cells does not fully support activeX controls, however, by just doing a save/export operation, why the original activeX controls got dropped during that operation?
We have saved your file into another file to check the activex control button. It does not have any effect on the output file. Below is our sample code. If you still find any problem, please provide us your sample project replicating your issue. We will look into it and help you asap.
We have also attached the output file for your reference.
Sorry, I didn't provide more accurate details here, the problem happens after I copy from one aspose workbook to another workbook, then save the newly copied workbook, the activeX controls all dropped. Here is the code:
I have tested with your new template file and it works fine here. The output file does have ActiveX controls as per the original file. Here is my sample runnable code that I am using and I have attached my output files for your reference.
Sample code:
Workbook _asposeOrigWorkbook = new Workbook(“e:\test2\orig.xlsx”);
Workbook _asposeUpdatedWorkbook = new Workbook();
_asposeUpdatedWorkbook.copy(_asposeOrigWorkbook);
_asposeOrigWorkbook.save(“orig1.xlsx”);
_asposeUpdatedWorkbook.save(“copied1.xlsx”);
Please try my sample code and check the output files.
We are pleased to know that the latest version is working fine for you. If you encounter any other problem, please feel free to post, we will be glad to help you further.