A grid with unrestricted height and weight also doesn’t have scrollbars as they make no sense on a printed paper.įor example, instead of having a grid printed with scrollbars: Grid Printed with Scrollbar When the data shown in a grid needs to printed, it’s often desirable to not constrain grid dimensions on the web page so that when printed it shows full set of data. You can read more about it in the documentation. You can see the first cell spans 2 rows, second and third span 4 rows. On the screenshot below the cells that span multiple rows are highlighted in cyan. This feature is similar to ‘cell merging’ in ‘Excel or ‘row spanning’ in HTML tables. You can now change this behavior to allow cells to span multiple rows. Row Spanningīy default, each cell takes up the height of one row. You can read more it in the documentation. Version 18 | Expand and Collapse Column Group In our example with medals, you can show or hide details for each kind of medals within a year. Column Group Total | Country, all Medals TotalĪnd it also includes a handy sliding mechanism that allows expand or collapse all values within a pivoted group. Once enabled, you will have a new column added showing you totals across all medals within a year. What if you now want to know how many medals of all kinds a country won in each year? This kind of total values is another new feature that we’ve introduced. So you have the following representation of the grid: Column Group Total | Gold, Silver and Bronze When applied, the grid has a new column that shows the grand total for all years: Version 18 | Addition of Grand Total Row Totalsīased on the same set of data, imagine that we also need to add Silver and Bronze medals to the picture. The pivot table shows us that the United States won 130 gold medals in 2000.īut what if you now want to see the total of gold medals won by the United States for all years? In this release we have added the new grand total option for column groups. If you do that here is what you will have in the grid: Column Group Total | Country Gold Medals For that you need to group by a country and pivot on a year. ![]() Now you want to see how many gold medals each country won in each year. Suppose you have the following data in the grid: Column Group Total | Individual Gold Medals This time we’ve added support for grand totals across column and row groups. We continue advancing our ag-Grid’s pivot table functionality to make the analytics process even more efficient. We have now added the grand total for columns across all groups: Version 18 Previous versions of the grid gave you the ability to find out subtotals for each group: Previous Version And we use OR filtering operator to show records that match both conditions. In the example below, we’re filtering out records to only show “Celica” and “Mondeo” models. ![]() Now, Text, Number and Date column filters support two conditions which can be grouped using AND/OR grouping operator. Previously, you could only define one condition for a column filter. ![]() Let me walk you through the new features.įor a complete list of changes see our changelog. Most of the work was focused around the pivot table mode and filtering. This is a major update, so besides fixing a bunch of bugs and improving performance through underlying architectural changes, we’ve added a number of very interesting features. Hey there! Just a few days ago we released a completely new version 18 of ag-Grid.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |