Version 20.0 Release Note

Summary

Version 20.9 of AdapTable was released in March 2025 and supports AG Grid version 33.0
It contains a number of major enhancements notably to:
- Layouts - these are now mandatory, and Pivot and Table are configured separately
- Export - a great deal of additional flexibility in sending reports is available
- Column Filters - AdapTable now supports multiple Filter conditions for a Column

AdapTable 20 is a major version release which contains a large number of enhancements.

It was released in March 2025 and supports AG Grid v.33.0.

Breaking Changes

There are a significant number of unavoidable Breaking Changes in Version 20.

Breaking Change

AG Grid's new Modules & Packages behaviour necessitated changes to AdapTable installation and initialisation
- For general information on what's changed see the Guide to AG Grid Modules and Packages
- For AdapTable vanilla see AdapTable Installation and AdapTable Integration
- For AdapTable React see AdapTable React Integration and AdapTable React Installation
- For AdapTable Angular see AdapTable Angular Integration and AdapTable Angular Installation
- For AdapTable Vue see AdapTable Vue Integration and AdapTable Vue Installation
AdapTable replaced abColDef types with AG Grid cell data types (see Using Cell Data Types for full details)
Layouts have been signficantly refactored and updated:
- Properties have been renamed, removed and refactored to provide greater flexibility (full details below)
- The Automatic State Migration updates old Layout State to new (though users can opt to do it manually)
Predefined Config has been renamed as Initial State - to better reflect that it is designed only for first time use

Support for AG Grid version 33.0 and AG Charts 11.1
Support for new AG Grid Bundles and Module handling
Full support for new AG Grid Theming API
The abColDef type has been replaced with AG Grid cell data types

Deep Dive

Moving from abColDef Column Types to AG Grid Cell Data Types

These are the AG Grid CellDataType properties now used by AdapTable, and the old type properties that they replace:

Column Data Type	AG Grid `cellDataType` value	Defunct AdapTable `type` value
String	`text`	`abColDefString`
Numeric	`number`	`abColDefNumber`
Date	`date`	`abColDefDate`
Date (as string)	`dateString`	`abColDefDate`
Boolean	`boolean`	`abColDefBoolean`
Object	`object`	`abColDefObject`

Layouts

At least one Layout must be provided in Initial State (i.e. a default Layout is now longer created)
Pivot Layouts and Table Layouts are now separate objects with different sets of properties
Tree Grid Columns and Row Group Columns can be directly referenced in a Layout
Each Layout can have a Row Group Display Type (single or multiple)
Saving and displaying Expanded / Collapsed Row Groups has been significantly enhanced
All Layouts will always save inside Adaptable State whenever they change
The initial Column Order is now always respected in AG Grid's Columns Tool Panel
Developers can set a Column to be always hidden in the UI (but still available in Calculated Columns)
Many Layout properties have been renamed (and significantly enhanced):

Deep Dive

Mapping Properties in the new Layout Objects

The previous Layout object has been replaced by 2 new objects (TableLayout and PivotLayout) and many properties were renamed and updated as follows:

Old Layout	New Layout	Type	Notes
`EnablePivot`	n/a	n/a	Users now create Table or Pivot Layouts
`Name`	`Name`	Both	Unchanged - still mandatory
`Columns`	`TableColumns`	Table	Mandatory
`PivotColumns`	`PivotColumns`	Pivot	Mandatory (provide empty array if none)
`ColumnWidthMap`	`ColumnSizing`	Both	Now `ColumnSizingMap` object
`ColumnSorts`	`ColumnSorts`	Both	Unchanged
`ColumnFilters`	`ColumnFilters`	Both	Unchanged (suppports multiple predicates)
`GridFilter`	`GridFilter`	Both	Unchanged
`RowGroupedColumns`(1)	`RowGroupedColumns`	Table	Unchanged
`RowGroupedColumns`(2)	`PivotGroupedColumns`	Pivot	Unchanged (but with a new name)
`ExpandedRowGroupValues`	`RowGroupValues`	Both	New (more complex) `RowGroupValues` object
`AggregationColumns` (1)	`TableAggregationColumns`	Table	New `TableAggregationColumns` object
`AggregationColumns` (2)	`PivotAggregationColumns`	Pivot	New `PivotAggregationColumns` object
`PinnedColumnsMap`	`ColumnPinning`	Both	New `ColumnDirectionMap` object
`ColumnHeadersMap`	`ColumnHeaders`	Both	Now `ColumnStringMap` object
`SuppressAggFuncInHeader`	`SuppressAggFuncInHeader`	Both	Unchanged
`RowSummaries`	`RowSummaries`	Both	Unchanged
`Tags`	`Tags`	Both	Unchanged
	`ColumnVisibility`	Table	New `ColumnBooleanFalseMap` object
	`AutoSizeColumns`	Both	New boolean property
	`RowGroupDisplayType`	Table	Either 'single' or 'multi'
	`ColumnGroupValues`	Both	New `ColumnGroupValues` object
	`PivotExpandLevel`	Pivot	New numeric property
	`GrandTotalRow`	Both	New property
	`PivotGrandTotal`	Pivot	New property
	`PivotColumnTotal`	Pivot	New property
	`MetaData`	Both	New (Adaptable Object) property

Export

AdapTable Exporting has been significantly refactored and improved, and is now a 3-step process:
- Report - AdapTable ships with updated System Reports
- Report Format - a new step where users select the type of Report to export
- Destination - where the Report is sent (new Destinations have been added)
The Visual Data Report has been replaced with a VisualExcel Report Format
Developers have more report configuration options including
- formatting exported grid data, particularly dates
- setting the CSV Delimiter
- whether to export Column Headers
- configuring if a Column is Exportable
Pivot Layouts and Tree Grids and Master Detail Grids can now all be exported
External Reports have been replaced by an improved, async, processExport function in Export Options
This can be leveraged when using the Server-Side Row Model to evaluate reports externally

Column Filters

Column Filters can support multiple Predicates - joined by AND / OR operators
The Filter UI component has been rewritten
The In Filter has been significantly enhanced so that developers can:
- provide custom lists of column values
- add other (System and Custom) Predicates to the list
- sort the list
- provide a value count
- disable search (useful when filtering on the server)

Other Enhancements

Improvements to Cell Summaries including:
- providing a bespoke Display Format
- extended to work with Pivot Result Columns
- they now update as selected cell data ticks
Custom Sorts have been extended to non-string Columns
Single, highly-configurable, Editing component for when listing column values
Users can provide global Adaptable Context - which is made available in all callbacks and events
Helper methods added to Column Menu and Context Menu APIs
Styled Columns now included when Team Sharing a Layout
Module Icons can be hidden in Settings Panel
Screen Loading properties have been merged into new section in User Interface Options
The current AG Grid version is now listed in Grid Info Module
Support for TypeScript 5.4.x and compileTarget es2020
Support for custom FDC3 App Channels
Actions Rows are renamed as Row Forms

AdapTable State Changes

Predefined Config has been renamed as Initial State (to better reflect what it does and when its used)
The ConfigApi section of Adaptable API has been renamed as StateApi
Meta data added to Adaptable State (e.g. AdapTable Version)

Framework Wrapper Changes

Full support for React 19 (in AdapTable React)
Three React hooks provided: useAdaptableState, useCurrentLayout and useAdaptableApi
Minimum Angular version supported by AdapTable Angular is 17

Change Logs

Column Filtering

Key	Type	Description
AT-2879	Enhancement	✅ Support fast typing in Quick Filter Bar
AT-2878	Task	✅ Enable customisation of column values list in the IN Filter
AT-2854	Enhancement	✅ Add ability to disable auto-search in IN Filter
AT-2723	Task	✅ Update Column Filters to support multiple Predicates
AT-2676	Bug	✅ Filter ToolPanel closes suddenly while filter being configured

Layout Refactoring

Key	Type	Description
AT-2892	Enhancement	✅ Move autosizing from Layout Options to Layout Config
AT-2885	Enhancement	✅ Remove autoOrderGroupedColumns and restoreUngroupedColumns properties from Grouping Options
AT-2872	Task	✅ Support Tree Grid Columns in Layouts
AT-2870	Enhancement	✅ Provide LayoutApi method to easily update a Layout
AT-2866	Enhancement	✅ Log Console Warning if Layout contains missing or duplicate column
AT-2864	Enhancement	✅ Log Console Error, and display Popup, if no Layout provided
AT-2856	Enhancement	✅ Add separate logging for LayoutManager
AT-2847	Enhancement	✅ Allow users to set Row Group Display Type (single or multiple)
AT-2846	Enhancement	✅ All Layouts should auto-save (like other AdapTable objects)
AT-2845	Enhancement	✅ Split Column Visibility and Order into separate props
AT-2834	Study	✅ Treat (Auto) Row Grouped Columns as AdapTable Columns
AT-2819	Task	✅ Remove concept of Default Layout
AT-2758	Bug	✅ SuppressAggFuncInHeader prop is ignored when Layout is created / edited in the Layout Wizard
AT-2542	Enhancement	✅ Show any Row Group columns in Columns step of Layout Wizard
AT-2532	Study	✅ Split Table and Pivot Layouts config and functionality
AT-2482	Study	✅ Respect initial AG Grid column order in Tool Panel
AT-2382	Enhancement	✅ Support "Always Hidden" Columns
AT-1514	Study	✅ Allow users to Sort Row Grouped Columns in a Layout

Export Improvements

Key	Type	Description
AT-2874	Task	✅ Include Tree Grid Columns when Exporting Data
AT-2823	Enhancement	✅ Add option whether to export Column Headers
AT-2809	Enhancement	✅ Enable Details Grids to be exported with Master Grid
AT-2790	Enhancement	✅ Replace Visual Data Report with a Visual Excel report format type
AT-2789	Task	✅ Split up Export into Reports, Report Formats and Report Destinations
AT-2787	Enhancement	✅ Allow Delimiter in CSV System Report to be configurable
AT-2235	Enhancement	✅ Export Date Cells with correct type in Excel Reports
AT-2152	Enhancement	✅ Replace External Reports with improved, async processReport function

General Enhancements

Key	Type	Description
AT-2906	Task	✅ Support new AG Grid theming Api
AT-2901	Task	✅ Support AG Grid Charts v.11
AT-2887	Bug	✅ Framework wrappers throw exceptions during destruction of component
AT-2884	Enhancement	✅ Refine the Display Format for Cell Summary values
AT-2881	Enhancement	✅ Support custom FDC3 App Channels
AT-2880	Enhancement	✅ Add ability to disable auto-search in Edit control
AT-2875	Bug	✅ Cell Summary doesn't update when Selected Cells tick
AT-2868	Task	✅ Upgrade to Angular 17
AT-2867	Task	✅ Support React 19
AT-2858	Enhancement	✅ Add meta data to Adaptable State (e.g. Version)
AT-2849	Task	✅ Use the new AG Grid v33 Bundles
AT-2844	Task	✅ Support AG Grid 33
AT-2839	Enhancement	✅ Disallow typing 'e' in Numeric Cell Editor
AT-2838	Enhancement	✅ Remove Columns with Comparers from list in Custom Sort Wizard
AT-2837	Enhancement	✅ Improve the UI for showing dependencies in Team Sharing Popup
AT-2835	Bug	✅ Styled Columns not included when Team Sharing an Extended Layout
AT-2833	Enhancement	✅ Add helper methods to Column Menu and Context Menu API
AT-2831	Enhancement	✅ Add option to hide Module Icons in Settings Panel
AT-2824	Enhancement	✅ Extend Cell Summaries to work with Pivot Result Columns
AT-2805	Enhancement	✅ Add warning if Plugin and AdapTable versions dont match
AT-2794	Task	✅ Upgrade to Typescript 5.4.x and compileTarget es2020
AT-2775	Enhancement	✅ Improve Close & Configure buttons in Custom Toolbar
AT-2772	Bug	✅ Add option whether FDC3 action buttons render in Group Rows
AT-2771	Bug	✅ Vertical Alignment incorrect for Badges in Row-Grouped Columns in Alpine & Quartz themes
AT-2737	Enhancement	✅ Merge all editing Permitted Values into an async Edit Options prop
AT-2706	Enhancement	✅ Merge Loading Screen Options
AT-2640	Bug	✅ AdapTable wrappers don't correctly handle some essential props
AT-2376	Enhancement	✅ Let users provide global context - available in all AdapTable callbacks
AT-2230	Enhancement	✅ Replace abColDef type with AG Grid cell data types
AT-2124	Enhancement	✅ Extend Custom Sorts to non-string columns
AT-1558	Enhancement	✅ Add Column Menu option to access charting
AT-1380	Enhancement	✅ Show the AG Grid version in Grid Info Module

Version 20.0 Release Note

Summary

Breaking Changes

Breaking Change

AG Grid related Enhancements

Deep Dive

Moving from abColDef Column Types to AG Grid Cell Data Types

Layouts

Deep Dive

Mapping Properties in the new Layout Objects

Export

Column Filters

Other Enhancements

AdapTable State Changes

Framework Wrapper Changes

Change Logs

Column Filtering

Layout Refactoring

Export Improvements

General Enhancements