Cell Summaries Technical Reference

Summary

  • Custom Summary Options can be provied in Cell Summary Options
  • Programmatic access to Cell Summaries is via the Cell Summary API
  • Row Summaries are defined as part of a Layout (in Layout Initial Adaptable State)

Cell Summary Options

The Cell Summary Options section of Adaptable Options contains a single collection:

PropertyDescription
customCellSummaryOperationsCustom Numeric Cell Summary Operations to add to set shipped by AdapTable
numericDisplayFormatNumeric format to use for summary value; a Format Column DisplayFormat will take precedence

Cell Summary Operation

A Cell Summary Operation is defined as follows:

PropertyDescription
operationFunctionFunction to run when a summary result is required
operationNameName of the Operation - will be displayed in the Cell Summary components

Cell Summary API

The Cell Summary API section of Adaptable API contains functions to retrieve Cell Summary information programmatically

MethodDescription
getCellSummaryOperationValue(operation)Retrieves the value of the given Cell Summary Operation
getCurrentCellSummaryOperation()Retrieves currently selected Cell Summary Operation
getCurrentCellSummaryOperationValue()Retrieves the value of the current selected Cell Summary Operation
getCustomCellSummaryOperations()Retrieves all Custom Cell Summary Operations
openCellSummaryPopupSettingsPanel()Opens Cell Summary Settings Panel with
setCurrentCellSummaryOperation(operation)Sets the currently selected Cell Summary Operation

Row Summary Definition

Row Summaries are provided as part of Layout Initial Adaptable State.

Each Row Summary is defined as follows:

PropertyDescriptionDefault
ColumnsMapMap of Columns with Summary Expressions
IncludeOnlyFilteredRowsEvaluates only currently filtered rows in the summarytrue
PositionWhere Row Summary appears - 'Top' or 'Bottom'
IsReadOnlySets Entity to ReadOnly (overwriting a Strategy Entitlement of 'Full')
IsSuspendedSuspends (i.e. turns off) an Adaptable Object