RadPivotGrid Implement logic when the user clicks on a cell to get the underlying data
PivotGrid get all the rows that 'lie' beneath a visible cell value
Currently the only way to recognize something changed as accurate as possible is to use StatusChanged on the DataProvider, but that does not tell apart from a structure change or just a click on the Update button… it would be nice to have such events available (onUpdate, onFieldListModified etc)
This is mainly focus on DateTime fields. They automatically create children name Day, Week and etc.They should be named “<parentName>.Day” Only for local field description Add in LocalDataSourceFieldDescriptionsProvider property named FormatDisplayNameAsName which turn on/off this functionality ((LocalDataSourceFieldDescriptionsProvider)((LocalDataSourceProvider)this.radPivotGrid1.DataProvider).FieldDescriptionsProvider).FormatDisplayNameAsFieldName= true
Steps to reproduce: 1. Add a RadPivotGrid to a form and populate it with data or use the one in the Demo application 2. Press Ctrl+A to select all cells 3, Press Ctrl+C to copy all cells to the clipboard You will get an exception.
For example: If you grouping using of DateTimeGroupDescription you should be able to format date as dd.MM.yyyy instead of Apr-22 Resolution: You can use the GroupElementFormatting event to format the text in the GroupDescription elements. Please, note that the developer should add an own logic for formatting a date (for example you should take the year and month from another fields)
Add support for custom calculated items. For example: Users should be able to calculate the subtotal for the given column based on other columns subtotals.
GroupDescriptions loose the Custom Name after dragging.
IMPROVE. RadPivotGrid - expose a method for accessing cell values
ADD. RadPivotGrid - add export to excel functionality
Drag the field contains date from field choicer control to Column data area. Then remove one of the sum field. The exception will thrown. Workaround: Use the DLLs for NET2.0
User is not able to open the Filter Popup Dialog when filter items contains DBNULL Workaround: Replace the DBNULL values with empty strings in your datatable.
ADD. RadPivotGrid - add ability to filter by more than one condition - composite filters
To workaround, also add a handler to the AggregatesPositionElementCreating event.
Currently, you can only copy the contents of the data cells to the clipboard and it is not possible to include the column/row header names.
ADD. RadPivotGrid - add single selection mode and expose the selected cell in property
Developers should be able to set the initial state for rows and columns in RadPivotGrid.