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

TdxSpreadSheetAutoSumGallery Class

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

#Declaration

Delphi
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.

See Also