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

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