Allow formatting of columns when protecting worksheet

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."

6 Replies

MW Melba Winshia Syncfusion Team November 7, 2006 06:36 AM UTC

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




TB Terrence Benade April 2, 2007 04:57 AM UTC

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


MW Melba Winshia Syncfusion Team April 2, 2007 09:35 AM UTC

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


TB Terrence Benade April 5, 2007 02:00 AM UTC

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

Thanks
Terry


MW Melba Winshia Syncfusion Team April 5, 2007 12:50 PM UTC

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


MW Melba Winshia Syncfusion Team April 24, 2007 01:06 PM UTC

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

Loader.
Up arrow icon