Protected worksheet in ASPOSE- don't need input password when unprotect sheet

Aspose.Cells Product Family
1

I have protected worksheet as below,
sheet.Protection.AllowFormattingCell = true;
sheet.Protection.AllowFormattingColumn = true;
sheet.Protection.AllowFormattingRow = true;
sheet.Protection.AllowSelectingLockedCell = true;
sheet.Protection.AllowSelectingUnlockedCell = true;
//lock uneditable cells
sheet.Protect(ProtectionType.All, “abc”, null);

but after run application on our QA site, download the report, don’t need to input password when click unprotect sheet, worksheet become writeable.
but from my local, it is fine, password can work well.

any ideas?

Aspose.Cells version is 7.7.1.0
VS2013 runtime version is v2.0.50727



2

Hi,


Thanks for providing us some details.

Could you check and confirm if you are using same Aspose.Cells version with same code segment on both locations (i.e., QA site and local machine). Well, it looks strange to us as Aspose.Cells may not work differently to generate Excel spreadsheets (one requires to provide worksheet’s protection password while other does not).

We also recommend you to kindly do try our latest version/fix: Aspose.Cells for .NET v8.5.2.1. If you still find the issue, kindly create a simple application, zip it and post us here to reproduce the issue on our end, we will check it soon. Also provide your template Excel file(s) if you have any.

Thank you.

3

It worked now, I missed to set password for our report service. thanks a lot.

4

Hi,


Thanks for your feedback.

Good to know that your issue is sorted out now. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.