TdxSpreadSheetSheetProtectionOptions.ActualAllowFormatCells Property

Identifies if an end-user can modify the formatting of unlocked cells in a worksheet.

Declaration

property ActualAllowFormatCells: Boolean index 4 read;

Property Value

Type
Boolean

Remarks

This property returns False if both the worksheet is protected (that is, the worksheet’s Options.Protected and/or OptionsProtection.Protected properties are set to True) and the AllowFormatCells property is set to False. Otherwise, the ActualAllowFormatCells property returns True.

The ActualAllowFormatCells property value affects the availability of the Format Cells… item in the cell context menu and all commands (including the corresponding keystrokes, if present) related to:

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

• The cell content 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).