Version 14 Release Note

Key Changes

These are the key changes in AdapTable Version 14 - listed by topic.

Sparkline Columns

• Sparkline Columns have been added as a new Styled Column type
• They are essentially wrappers around AG Grid Sparklines but can be created at design time or run time
• Typically they will show numeric arrays but they can display objects also

Multiple Predicates

• There is now the option to create conditions with multiple Predicates where previously just one was allowed
• Multiple Predicates are available in Column Formatting, Alerts and Flashing Cells
• This is useful where users require many conditions - but are put off by the complexities of Expressions

Expression Editor

• The Functions Dropdown in the Expression Editor has been considerably improved
• Functions are now grouped by type - making them easier to find
• The dropdown displays help, examples and other information, helping users find the appropriate Function

Chart Locations

• Charting has been enhanced with Chart Locations
• These are provided by developers enabling multiple AG Grid Charts to be displayed simultaneously
• There is no restriction of the number of locations which can be supplied
• Charts can be displayed, hidden, edited and deleted directly form Chart Toolbar and Tool Panel

Switch Logic in Expressions

• Switch statement logic has been added to AdapTableQL
• It uses a familiar CASE syntax found in many languages
• This allows users to write complex Expressions with limitless number of Statements to be evaluated
• It is designed for where the Ternary Operator (?) is insufficiently flexible or excessively verbose

UI Enhancements

• New property to restore an ungrouped column to its previous position in the Grid
• The Visual Data Report exports data faster and can send Dates to Excel as date columns
• Custom Headers and Messages can be provided to Alerts
• Options to hide "Are you sure you want to delete?" warnings
• Transparency (alpha channel) has been added to Adaptable Styles and is available in the Colour Picker
• Right-clicking on any Cell in a Pivot Layout opens a Table showing the contents of that Cell

Other Enhancements

• Cells can be selected using a Standard Expression
• Developers can set which System Predicates are available in Filters, Alerts, Format Columns & Flashing Cells
• Percent Bar Ranges can be percentage based (was previously value only)
• Layouts can sort hidden Columns
• Enable users to provide Holiday Calendars (useful in Previous Workday & Next Workday Predicates)
• New TO_ARRAY AdapTableQL Expression Function which converts arguments to an array

Code Changes

• New Options API section added to Adaptable API providing access to Adaptable Options classes
• Deprecated isPredicate Expression Function property was removed (instead set returnType to 'boolean')
• The externallyEvaluatedModules property was replaced with the evaluateAdaptableQLExternally property (also in Expression Options)
• Previously deprecated properties in Adaptable Options have now been removed:
  • systemFilters in Column Filter Options (now available in Predicate Options)

API Refactoring

• The Adaptable API has been refined, making it more consistent and easier to discover

• Many existing methods have been marked as deprecated for a few reasons:

  • due to inconsistent naming
  • they were designed purely for internal use

  Note

  • All deprecated methods are still available for use but will be removed in the next major Version (15)
  • Accordingly we recommend you to adjust their usage ASAP

• The deprecated methods are marked accordingly in the TSDoc

• Additionally AdapTable logs a console warning when they are used, e.g.:

Change Logs

Version 14.1 Change Log

Version 14.0 Change Log