Protect cell content but allow cell formatting and resize

Aspose.Cells Product Family
1

Hello,


we use the protect method to protect our excel workbook but we woud like to let people resize or modify cell style if they want to. Using interop it is possible but it seems it’s not working with aspose right now.
Does someone have more information about this?

We are using aspose cells 7.1.2.1

Best regards

Laurent
2

Hi,


Well, I think you may try some advanced Protection options/settings for your needs. For example, you should allow Formatting cells, rows and cols etc. or any other on and the rest options should be set to false accordingly.

See the document for your complete reference
http://docs.aspose.com/display/cellsnet/Advanced+Protection+Settings+since+Excel+XP

Thank you.

3

Hi,


thank you for the quick answer, everything works now.

Best regards

Laurent
4

Hi,


Good to know that you got everything working fine accordingly for your needs now.

If you have any further query or issue, let us know any time.

Have a good day!