I am having a similar issue to what was reported here where the ActiveX control becomes a shape when doing a sheet copy.
A fix was issued for JAVA and I was just wondering whether the same fix was done for .NET. We upgrade every 6 months and are currently running version 17.12.
Here is a sample of code to replicate and the results in a From and To workbook.
Dim loFromWB As Aspose.Cells.Workbook
Dim loFromStr As System.IO.FileStream
loFromStr = New System.IO.FileStream(“C:\Temp\FromWB.xlsx”, IO.FileMode.Open, IO.FileAccess.Read, IO.FileShare.ReadWrite)
loFromWB = New Aspose.Cells.Workbook(loFromStr)
loFromStr.Close()
Dim loToWB As New Aspose.Cells.Workbook(Aspose.Cells.FileFormatType.Xlsx)
loToWB.Worksheets.Item(0).Copy(loFromWB.Worksheets.Item(0))
loToWB.Save(fileName:=“C:\Temp\ToWB.xlsx”, saveFormat:=Aspose.Cells.FileFormatType.Xlsx)
loFromWB = Nothing
loToWB = Nothing
The most recent version works fine with this feature. Normally, whenever we implement new feature, we first implement it in .NET version and then port it to Java. So the fix is included in both versions.
Thanks for your prompt reply. However in this example you are copying a sheet within a workbook and this does work even in the version of aspose.cells I am using.
I am copying a sheet from one workbook into another workbook. This was also the issue in the post I connected to. Copying within a workbook worked while copying across workbooks did not. Can you please confirm that copying from one work book into another works in the latest .NET version of Aspose.Cells? I just tried with my combobox and it did not work?
We were able to observe this issue and logged it in our database for investigation and for implementation. Once, we will have some fix or other news for you, we will let you know asap.
This issue has been logged as
CELLSNET-45941 - ActiveX control becomes picture when copy sheet from one workbook to another workbook
This is to inform you that we have fixed your issue “CELLSNET-45941” now. We will soon provide the fix after performing QA and including other enhancements and fixes.
The issues you have found earlier (filed as CELLSNET-45941) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi
Thanks Amjad. Just letting you know that I have confirmed that this issue is resolved and the new workbook correctly has the activeX control rather than an image.
However I am having issues with the underlying ranges that the control references not being updated so have raised a separate issue here: ListFillRange in ActiveX combo not updating
It is good to know that your previous issue is resolved now. Thanks for creating a separate topic for your newer issue. We were able to observe the issue and updated you in your newer topic. Thank you and have a good day.
The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan