TdxSpreadSheetCustomView.Active Property

Specifies if the worksheet is currently displayed by the Spreadsheet control.

Declaration

property Active: Boolean read; write;

Property Value

Type
Boolean

Remarks

You can use this property to:

• Identify whether the worksheet is currently active;

• Activate an inactive worksheet.

The Spreadsheet control always shows one worksheet within the View area. If the Active property returns True, the current worksheet is displayed. Otherwise, another worksheet is displayed. If there is only one sheet within a workbook, the Active property has no effect.

Also, assigning False to the Active property of the displayed worksheet has no effect. Since the Spreadsheet control always has one active worksheet, you need to activate another sheet in order to deactivate the current one.

Note

The newly created (either by invoking the Spreadsheet control’s AddSheet function or by clicking the new sheet button) worksheet instantly becomes active.