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:

PropertyTypeDescriptionDefault
customCellSummaryOperationsCustomCellSummaryOperation<TData>[]Custom Numeric Cell Summary Operations to add to set shipped by AdapTable
numericDisplayFormatNumberFormatterOptions| ((columnContext:AdaptableColumnContext) =>NumberFormatterOptions)Numeric format to use for summary value; a Format Column DisplayFormat will take precedenceFractionDigits: 2

Cell Summary Operation

A Cell Summary Operation is defined as follows:

PropertyTypeDescription
operationFunction(operationContext:CustomCellSummaryOperationContext<TData>) => anyFunction to run when a summary result is required
operationNamestringName 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

MethodReturnsDescription
getCellSummaryOperationValue(operation)anyRetrieves the value of the given Cell Summary Operation
getCurrentCellSummaryOperation()CustomCellSummaryOperation | stringRetrieves currently selected Cell Summary Operation
getCurrentCellSummaryOperationValue()numberRetrieves the value of the current selected Cell Summary Operation
getCustomCellSummaryOperations()CustomCellSummaryOperation[]Retrieves all Custom Cell Summary Operations
openCellSummaryPopupSettingsPanel()voidOpens Cell Summary Settings Panel with
setCurrentCellSummaryOperation(operation)voidSets 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:

PropertyTypeDescriptionDefault
ColumnsMapRecord<string, SummarySupportedExpression>Map of Columns with Summary Expressions
IncludeOnlyFilteredRowsbooleanEvaluates only currently filtered rows in the summarytrue
PositionRowSummaryPositionWhere Row Summary appears - 'Top' or 'Bottom'
IsReadOnlybooleanSets Entity to ReadOnly (overwriting a Strategy Entitlement of 'Full')
IsSuspendedbooleanSuspends (i.e. turns off) an Adaptable Object