What's new

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

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