It should be possible to persist the current configuration of RadPivotGrid so that when the settings are loaded, the settings of the RadPivotGrid should appear as when they were saved. This includes the column/row/filter/aggregate descriptors, the width/height of the resized rows/columns and the applied filters.
ADD. RadPivotGrid - add export to excel functionality
ADD. RadPivotGrid - add localization provider
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)
Until the feature gets implemented create a custom PivotFieldListVisualItem and translate each of the items individually: public partial class Form1 : Form { public Form1() { InitializeComponent(); this.radPivotFieldList1.RowLabelsControl.CreatingVisualListItem += ListControl_CreatingVisualListItem; this.radPivotFieldList1.ColumnLabelsControl.CreatingVisualListItem += ListControl_CreatingVisualListItem; this.radPivotFieldList1.ReportFiltersControl.CreatingVisualListItem += ListControl_CreatingVisualListItem; this.radPivotFieldList1.ValuesControl.CreatingVisualListItem += ListControl_CreatingVisualListItem; } private void ListControl_CreatingVisualListItem(object sender, CreatingVisualListItemEventArgs args) { args.VisualItem = new MyPivotFieldListVisualItem(this.radPivotFieldList1.ViewModel); } } public class MyPivotFieldListVisualItem : PivotFieldListVisualItem { public MyPivotFieldListVisualItem(FieldListViewModel viewModel) : base(viewModel) { } protected override void CreateChildElements() { base.CreateChildElements(); CommandBarDropDownButton btn = this.GetType().BaseType .GetField("button", BindingFlags.Instance | BindingFlags.NonPublic) .GetValue(this) as CommandBarDropDownButton; if (btn != null) { btn.DropDownMenu.PopupOpening += DropDownMenu_PopupOpening; } } private void DropDownMenu_PopupOpening(object sender, System.ComponentModel.CancelEventArgs args) { foreach (RadItem item in ((RadDropDownMenu)sender).Items) { // Validate and localize each of the items if (item is RadMenuItem) { item.Text = "MyText"; } } } }
RadPivotGrid Implement logic when the user clicks on a cell to get the underlying data
The group description now has AutoShowSubTotals property determining whether subtotals will be generated for the description: this.radPivotGrid1.RowGroupDescriptions.Add(new DateTimeGroupDescription { PropertyName = "OrderDate", Step = DateTimeStep.Quarter, GroupComparer = new GroupNameComparer(), AutoShowSubTotals = false });
Implement "Calculated Fields" support in RadPivotGrid
Add the ability to export to OpenXML format, specifically ".xlsx".
RadPivot prints only left columns and the columns placed on the right part of the control do not print
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.
Add the ability to export in pdf format.
GroupDescriptions loose the Custom Name after dragging.
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
Currently the words: Row, Column and Value are not localizable in the ScreenTip. Currently they can be localized as follows: void radPivotGrid1_ScreenTipNeeded(object sender, Telerik.WinControls.ScreenTipNeededEventArgs e) { PivotCellElement cell = e.Item as PivotCellElement; if (cell == null || cell.ScreenTip == null) { return; } RadOffice2007ScreenTipElement screenTip = cell.ScreenTip asRadOffice2007ScreenTipElement; screenTip.MainTextLabel.Text = screenTip.MainTextLabel.Text .Replace("Value:", "ChangedValue:") .Replace("Row:", "ChangedRow:") .Replace("Column:", "ReplacedColumn:"); }
Workaround: remove the localization provider before saving the layout and then add it back.
Hour, minute, second, if possible also week
Developers should be able to set the initial state for rows and columns in RadPivotGrid.