Unprotected OLE Objects on a protected sheet become protected after save

Aspose.Cells Product Family
1

PFA workbook OLE.zip (459.2 KB)

The sheet is protected (Password “A”) and has a PDF OLE Object inserted.
The object itself is unprotected and can be double clicked.rDb2wG0Jad.png (6.8 KB)

If I open with Aspose.cells, then save, the ole object is now protected and cannot be clicked on.

Sample Code:

        var workbook = new Workbook("OLE.xlsx");
        workbook.Save("out.xlsx");
        System.Diagnostics.Process.Start("out.xlsx");
2

@Moonglum,

Please notice, I am able to reproduce the issue as you mentioned by using your template file after re-save by Aspose.Cells APIs. I found the unprotected OLE Objects on a protected sheet becomes protected after save. I have logged a ticket with an id “CELLSNET-50240” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

3

@Moonglum,

We are pleased to inform you that we have fixed your issue now. The fix will be included in our next (upcoming) version Aspose.Cells v22.2.

4

The issues you have found earlier (filed as CELLSNET-50240) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi