What's new

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

Version 2.1

Released on May 6, 2025

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

Version 2.0.3

Released on November 29, 2024

Fixes

• export to Excel/CSV of tree structure contains only topmost branches
• exported columns with autowidth are too narrow in the resulting Excel file
• incorrect position of a popup with filters
• incorrect behaviour after changing configuration with the setConfig method
• more precise type definitions

Version 2.0.2

Released on October 22, 2024

Fixes

• columnShape type definition
• correct package contents

Version 2.0

Released on August 26, 2024

Please, see the review of the release on the blog page

Breaking change

note

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 analyzed 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.