TdxSpreadSheetAutoSumGallery Class

An action object that implements the AutoSumGallery end-user command in spreadsheet-based applications.

Declaration

TdxSpreadSheetAutoSumGallery = class(
    TdxSpreadSheetCustomGalleryAction
)

Remarks

This class does not introduce any new public members. Its overridden Execute function creates a formula expression based on one of the five predefined autosum patterns (that is, Sum, Average, Count Numbers, Max, and Min) in a nearest empty cell below or to the right of the current cell selection.

UI elements linked to a TdxSpreadSheetAutoSumGallery action object are enabled only if at least one cell is selected. The command is unavailable if a floating container is selected or the protected worksheet’s OptionsProtection.ActualAllowSelectLockedCells and OptionsProtection.ActualAllowSelectUnlockedCells properties return True.