Remove ActiveXControl from Picture shape

Aspose.Cells Product Family
1

Hi,

I was wondering if in Aspose.Cells Java there’s a way to remove ActiveXControl from a Picture shape?
I would like the picture to remain in the worksheet, only without the ActiveX.
I’ve noticed there’s only the getter getActiveXControl() and no setter.
Is there any other way?

2

@Shiran1,
Thank you for your query.
Could you please share your sample code for our testing? Also perform same task using MS Excel only and share the two files before and after removing the active control from picture shape. We will analyze the information and provide assistance accordingly.

3

I have a Shape object in my worksheet.getShapes().
This Shape is a picture: shape.getMsoDrawingType() == MsoDrawingType.PICTURE is true.
This Shape contains ActiveXControl: shape.getActiveXControl() == null is false.
I would like to remove the ActiveXControl from the Shape so that the shape will remain only as a picture without the active content.
Is it possible? If yes, how?

4

@Shiran1,
We need requested files and runnable code. We will analyze the information and provide assistance accordingly.

5 
   Workbook book = new Workbook("C:\\ActiveX.xlsx");
   for (Object sheet : book.getWorksheets()) {
       for (Object obj : ((Worksheet)sheet).getShapes()) {
           Shape shape = (Shape)obj;
           if (shape.getMsoDrawingType() == MsoDrawingType.PICTURE) {
               Picture picture = (Picture)shape;
               ActiveXControl activeX = picture.getActiveXControl();
               // How do I remove the ActiveXControl from picture?
           }
       }
   }
   book.save("C:\\ActiveX2.xlsx", SaveFormat.XLSX);

activex.zip (7.0 MB)

6

@Shiran1,
Thank you for the sample code.
We have understood the requirement but we need to look into it more. We have logged the issue in our database for investigation and for implementation if possible. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as
CELLSJAVA-43135 – Remove ActiveXControl from Picture shape

7

@Shiran1,
This is to inform you that we have fixed your issue (logged earlier as “CELLSJAVA-43135”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

8

@Shiran1,
Please try our latest version/fix: Aspose.Cells for Java v20.2.4:
aspose-cells-20.2.4-java.zip (7.0 MB)

Your issue should be fixed in it.

Let us know your feedback.

9

Thanks for the fix.
It worked for xlsx files but unfortunately didn’t work for xls.

10

@Shiran1,
We have observed the issue and have logged it with the ticket. We will write back here once any feedback is ready to share.

11

@Shiran1,
Please try our latest version/fix: Aspose.Cells for Java v20.2.6:
aspose-cells-20.2.6-java.zip (7.0 MB)

Your issue should be fixed in it.

Let us know your feedback.

12

Working.
Thanks for the fix.

13

@Shiran1,

You are welcome.

14

The issues you have found earlier (filed as CELLSJAVA-43135) have been fixed in Aspose.Cells for Java v20.3. This message was posted using Bugs notification tool by ahsaniqbalsidiqui