I want to make my workbook and worksheet protected (read-only), yet allow the user to resize the columns. How can this be accomplished?
Hello Terence,
The WorksheetProtection class exposes several settings inwhich you can enable or disable when a worksheet is protected. The on in particular is called AllowFormattingColumns.
eg. Please set the following parameters when protecting a worksheet.
xamSpreadsheet1.ActiveWorksheet.Protect(allowFormattingColumns: true);
For more details please visit our online documentation:http://www.infragistics.com/help/wpf/infragisticswpf4.documents.excel.v16.2~infragistics.documents.excel.workbook~protect(string,boolean,boolean)
Let me know if you have any questions regarding this matter.