TdxSpreadSheetSheetProtectionOptions.AllowFormatCells Property

Specifies if an end-user can format cells in a protected worksheet.

Declaration

property AllowFormatCells: Boolean index 4 read; write; default False;

Property Value

Type	Default
Boolean	False

Remarks

This property corresponds to the Format cells checkbox in the Protect Sheet dialog:

Set the AllowFormatCells property to True to allow an end-user to modify the cell formatting in a protected worksheet via the Format Cells dialog and/or all commands (including the corresponding keystrokes, if present) related to:

• The cell horizontal alignment (AlignHorizontalCenter, AlignHorizontalLeft, and AlignHorizontalRight).

• The cell vertical alignment (AlignVerticalBottom, AlignVerticalCenter, and AlignVerticalTop).

• The cell content adjustment and positioning (AutoFitColumnWidth, AutoFitRowHeight, TextIndentDecrease, TextIndentIncrease, and TextWrap).

• The cell borders (BordersAll, BordersBottom, BordersBottomDouble, BordersBottomThick, BordersLeft, BordersMore, BordersNone, BordersOutside, BordersOutsideThick, BordersRight, BordersTop, BordersTopAndBottom, BordersTopAndBottomDouble, and BordersTopAndBottomThick).

• The cell background color (ChangeFillColor).

• The conditional formatting functionality (ShowConditionalFormattingRulesManager).

• The cell font settings (ChangeFontColor, ChangeFontName, ChangeFontSize, DecreaseFontSize, IncreaseFontSize, ToggleFontBold, ToggleFontItalic, ToggleFontStrikeout, and ToggleFontUnderline).

• Merging and unmerging cells (MergeCells, MergeCellsAcross, MergeCellsAndCenter, and UnmergeCells).

• Restoring the default cell formatting (ClearAll and ClearFormats).

To identify if an end-user is currently able to modify cell formatting, use the ActualAllowFormatCells property.

The default value of the AllowFormatCells property is False.