Hi,
Would it be possible to allow an override to the .unprotect method of the workbook or worksheets which means we don’t need to use a password where one is set.
There are articles on how to do it, and it does not seem complex, and would be very useful.
NB I do not mean the encryption password on opening the workbook, just the passwords for protecting sheets/workbook structure.
Many thanks.
Thanks for your query.
I have logged your feature request with an id “CELLSNET-45732” for your issue/requirements. The issue is logged as following:
Our concerned developer from product team will look into it soon.
Once we have an update on it, we will let you know here.
We did evaluate your issue furhter. I am afraid, it’s not allowed to unprotect a workbook/worksheet without correct password in MS Excel. Aspose.Cells works and follows as MS Excel, so we will not support this feature.
Sorry for any inconvenience caused!
Disappointing given it is quite trivial to do, but i understand your position.
Regards
Anthony
Thanks for your understanding.
And, yes, we have to follow MS Excel for good reasons in most cases.
Feel free to write us back if you have further comments or other issue, we will be happy to assist you soon.