ShowFormatCellsDialog(TdxSpreadSheetTableView,Integer) Method

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

Declaration

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.