Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

ShowFormatCellsDialog(TdxSpreadSheetTableView,Integer) Method

Invokes the “Format Cells“ dialog for the specified worksheet.

#Declaration

Delphi
procedure ShowFormatCellsDialog(ASheet: TdxSpreadSheetTableView; const AActivePage: Integer = -1);

#Parameters

Name Type
ASheet TdxSpreadSheetTableView
AActivePage Integer

#Remarks

Call this procedure and pass a target worksheet as the ASheet parameter to invoke the “Format Cells” dialog for cell selection in the worksheet.

The AActivePage parameter value defines which of the “Format Cells” dialog pages is visible when the dialog appears. The following table lists available parameter values and their effects.

AActivePage Value The Format Cells Dialog Shows
-2 (or less) The Number page.
-1 (default) The Number page if the dialog is invoked for the first time at runtime. Otherwise – the dialog shows the same page that was active when the dialog was invoked for the last time.
0 The Number page.
1 The Alignment page.
2 The Font page.
3 The Border page.
4 The Fill page.
5 (or greater) The Protection page.
See Also