Allow formatting of columns when protecting worksheet

[Elsa C. Wood]

Is there a way to allow a user to format a column (i.e. expand it) when protecting a worksheet? In Excel, this can be accomplished by Tools, Protection, Protect Sheet and selecting "Format columns."

[Melba Winshia]

Hi Elsa,

Currently it is not possible to format a column within a protected worksheet. But this feature has been added internally and it will be available in the next release. Could you please create a Direct-Trac incident regarding this so that I can provide you with a preview version.

Please let me know if you have any other questions.

Thanks,
Melba

[Terrence Benade]

Was this issue addressed as I cannot find it in Direct-Trac.

Not having this feature is a show stopper so any ideas on it possible relase would be much appreciated.

Regards
Terry

[Melba Winshia]

Hi Terry,

You can use the following code snippets to allow formatting of columns when the sheet is protected.

[C#]

//Protect sheet.
sheet.Protect("syncfusion", ExcelSheetProtection.FormattingColumns);

Here is the sample for your reference:

http://websamples.syncfusion.com/samples/XlsIO.Windows/F51455/main.htm

This feature has been added only in version 4.4.0.51.

Kindly let me know if you have any other questions.

Thanks,
Melba

[Terrence Benade]

Yip what happens if I need both row and column formatting?

Thanks
Terry

[Melba Winshia]

Hi Terry,

Thanks for the update.

I have logged a feature request regarding this issue.

Kindly let me know if you have any other questions.

Regards,
Melba

[Melba Winshia]

Hi Terry,

On further investigation, I found a way to allow both formatting of columns and rows when the sheet is protected. Please refer the following code snippet to achieve this:

//Protect sheet.
sheet.Protect("syncfusion", ExcelSheetProtection.FormattingColumns|ExcelSheetProtection.FormattingRows);

Here is the sample for your reference:

http://websamples.syncfusion.com/samples/XlsIO.Windows/F51455_1/main.htm

Kindly let me know if you have any other questions.

Thanks,
Melba