{"id":13741,"date":"2025-05-07T08:08:14","date_gmt":"2025-05-07T05:08:14","guid":{"rendered":"https:\/\/dhtmlx.com\/blog\/?p=13741"},"modified":"2025-05-23T14:14:46","modified_gmt":"2025-05-23T11:14:46","slug":"dhtmlx-pivot-2-1","status":"publish","type":"post","link":"https:\/\/dhtmlx.com\/blog\/dhtmlx-pivot-2-1\/","title":{"rendered":"DHTMLX Pivot 2.1 with Custom Field Formatting, HTML Templates, Enhanced Styling, Fixed Right-Side Columns, and More"},"content":{"rendered":"

We hope you had enough time to explore the fully overhauled DHTMLX JavaScript Pivot table 2.0 and apply it efficiently for data analysis in your projects. Now, it is time to move forward and present a new version of this JavaScript component. The DHTMLX Pivot 2.1 expands developers\u2019 capabilities in modifying the table\u2019s appearance via newly added CSS styling options, HTML templates, and custom formatting for numbers and dates. Apart from that, the release includes the ability to freeze columns on the right, expanded export settings to Excel and CSV, and some minor improvements. As a bonus, our team also prepared integration demos that will make it much easier for you to use our JavaScript Pivot table<\/a> with React, Angular, Vue, and Svelte.<\/p>\n\n\t\t

\n\t\t
\n\t\t
\n\t\t
Download DHTMLX Pivot v2.1<\/div>\n\t\t
Estimate the updated functionality for delivering a multifunctional JavaScript Pivot table<\/div>\n <\/div>\n\t\t \n \n
\n Get free trial<\/a>\n <\/div>\n \n <\/div>\n\t\t<\/div>\n\t\n

In this release article, we provide a detailed overview of the Pivot 2.1 novelties.<\/p>\n

Flexible Formatting for Number and Date Fields<\/h5>\n

When incorporating a pivot table into a web app with a strong emphasis on international business, it is important to bear in mind existing differences in number and date formatting in various countries. Overlooking this may lead to misinterpretation of data or a poor user experience for global teams. <\/p>\n

With the newly added support for locale-dependent formatting<\/a> in DHTMLX Pivot, you can be sure that date and number fields will be automatically adjusted according to the app\u2019s current locale. You can test how it works by switching between locales in this example<\/a> and paying attention to formatting changes in the Profit and Date columns.<\/p>\n

Date and number formats can be changed at the locale level, but if needed, you can also apply a custom format<\/a> to specific date and number fields using the format<\/strong> parameter of the fields<\/a><\/strong> property:<\/p>\n