DHTMLX Pivot 2.1

Released on May 6, 2025

If you are updating Pivot from an older version, check Migration to newer versions for details.

Review of the release on the blog page

New functionality

• Ability to freeze columns on the right
• Default aligning and locale-based formatting for numeric values
• Ability to define custom number formats (for date and numeric fields) via format added to the fields property
• Ability to style header and table cells via the cellStyle parameter of the tableShape and headerShape properties
• Ability to insert HTML content to header and table cells via the pivot.template helper by defining a template as a cell property of the header and column objects (table customization by intercepting the render-table event)
• Excel and CSV export settings enhanced:
  • for the "xlsx" format, date and number fields are exported as raw values with default format or the format defined via the fields property
  • ability to define file and sheet names and exclude header/footer from an exported file
  • ability to add styles and templates for exported cells
• Ability to filter data via an external input
• Visual frame for cell navigation
• Integration with frameworks

New API

• right setting within the split object of the tableShape
• cellStyle setting within tableShape and headerShape properties
• format setting within the fields array
• filter-rows event of the internal Table
• pivot.template to define HTML content for table cells

Fixes

• Total columns are not sorted
• String values with the leading 0 are converted to numbers during export
• Predicate template is not applied to rows/columns
• Resize observer error in corner cases

Breaking changes

• colWidth parameter of the sizes object in the tableShape property renamed to columnWidth

DHTMLX Pivot 2.0

Released on August 26, 2024

If you are updating Pivot from an older version, check Migration to newer versions for details.

Review of the release on the blog page

Breaking change

API of version 1.5 is not compatible with API v.2.0.

For tips about migration to the new version, check the Migration page.

New functionality

• Pivot 2.0 is quick at rendering and generating large datasets (sample)
• Next new features for configuring the look and behavior of columns are available via the columnShape property:
  • setting autowidth with the ability to set maxRows to be processed for the autoWidth calculation (sample)
  • the firstOnly feature when each field of the same data is analysed only once to calculate the column width (by default)
• Now you can configure the look and behavior of headers using the headerShape property that allows:
  • applying a template to the text in headers (sample)
  • changing text orientation (sample)
  • making columns collapsible (sample)
• The shape and sizes of the table can be configured via the tableShape property that makes possible:
  • configuring the height of rows, headers, footer: rowHeight, headerHeight, footerHeight (Resizing the table)
  • generating total values not only for columns but also for rows, which is made possible via the totalColumn parameter of the tableShape property (sample)
  • hiding the duplicate values in the table view (the cleanRows parameter of the tableShape property)
  • fixing columns from the left making them static while scrolling (sample)
  • making all rows expand or collapse (sample)
• More features are added to aggregate data:
  • limiting loaded data
  • more operations with data are available
  • processing data with predicates - applying custom pre-processing functions for data
  • setting date format via locale
• New methods are added: getTable(), setConfig(), setLocale(), showConfigPanel()
• New events are added: add-field, delete-field, open-filter, render-table, move-field, show-config-panel, show-config-panel, update-config, update-value.