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