Change the Decimal symbol/separator  to "," and run Excel export for the RadPivotGrid. Note that all "0,00" cells are displayed as "1" in Excel and all decimal values are displayed without decimal separator.

Another scenario is when you change the Format in the Regional settings to Russia. Then, when exporting data, the decimal separator for the GrandTotal column is not correct ".", instead of ",". However, for the data cells it is OK.

Workaround:

        void exporter_PivotExcelCellFormatting(object sender, ExcelPivotCellExportingEventArgs e)
        {
            double d;
            if (double.TryParse(e.Cell.Text, out d))
            {
                e.DataType = "double";
            }
        }

If you have an object with string property and for all the available objects in the RadPivotgrid you have numeric values for this property with leading zero digits (e.g. "002"), it is exported in Excel as a numeric cell.

To reproduce: use the following code snippet. It is reproducible in target framework less than .NET Framework 4.0.

Sub New()
    InitializeComponent()
    Me.RadPivotGrid1.RowGroupDescriptions.Add(New DoubleGroupDescription() With { _
        .PropertyName = "EmployeeID", _
        .GroupComparer = New GroupNameComparer() _
    })
    UpdatePivotGrid()
End Sub

Private Sub UpdatePivotGrid()
    Dim ds As DataSet = New DataSet
    Dim conn As New SqlConnection("Data Source=.;Initial Catalog=Northwind;Integrated Security=True")
    Dim cmd As New SqlCommand("SELECT * FROM Orders", conn)
    conn.Open()

    Dim da As SqlDataAdapter = New SqlDataAdapter(cmd)
    da.Fill(ds)
    ds.Dispose()

    Me.RadPivotGrid1.DataSource = ds.Tables(0)
    Me.RadPivotGrid1.Refresh()
End Sub

Please refer to the attached gif file.

Workaround : use .NET Framework 4.0.  

To reproduce:

Create a RadPivotGrid with some data and export it by following the article http://www.telerik.com/help/winforms/pivotgrid-export-to-excel.html Set the following settings to the exporter:

exporter.ShowGridLines = true;
exporter.ExportVisualSettings = true;
exporter.HeaderCellsFont = new System.Drawing.Font("Arial", 8);
exporter.DataCellsFont = new System.Drawing.Font("Arial", 8);
exporter.GridLinesColor = Color.Black;
exporter.CellBackColor = Color.White;
exporter.SheetName = this.ClientManager.CubeEngine.Title;
exporter.ExportFlatData = false;


Also subscribe to the PivotExcelCellFormatting event use the following code:

e.Cell.TextAlignment = ContentAlignment.MiddleRight;
e.Cell.DrawBorder = true;
e.Cell.BorderColor = Color.Black;
e.Cell.DrawText = true;
e.Cell.DrawFill = true;


You will see that the exported cells will not have borders, nor their font will be changed. Additionally, if you set a specific ForeColor, BackColor, it is not applied as well.

Workaround:

  private void radButton1_Click(object sender, EventArgs e)
        {
            radPivotGrid1.RowGroupsExpandBehavior = new GroupsExpandBehavior() { Expanded = true };
            radPivotGrid1.ColumnGroupsExpandBehavior = new GroupsExpandBehavior() { Expanded = true };
            radPivotGrid1.DataProvider.Refresh();

            ExportTo.ExportToExcel(this);

            radPivotGrid1.RowGroupsExpandBehavior = new GroupsExpandBehavior() { Expanded = false };
            radPivotGrid1.ColumnGroupsExpandBehavior = new GroupsExpandBehavior() { Expanded = false };
            radPivotGrid1.DataProvider.Refresh();
        }

To reproduce: 

Create a localization provider following the article - http://wwwsit.telerik.com/help/winforms/pivotgrid-localization-localization.html. When you start the app you will see that the PivotAggregateP0ofP1 is not used.

Workaround:

Use the formatting events to format the needed values - http://wwwsit.telerik.com/help/winforms/pivotgrid-formatting-appearance.html

To reproduce:

private void Form1_Load(object sender, EventArgs e)
{
    this.ordersTableAdapter.Fill(this.nwindDataSet.Orders);
    
    LocalDataSourceProvider dataProvider = new LocalDataSourceProvider(); 
    dataProvider.Culture = new System.Globalization.CultureInfo("ru-RU"); 
    dataProvider.ItemsSource = this.ordersBindingSource;

    dataProvider.BeginInit();
    dataProvider.RowGroupDescriptions.Add(new DateTimeGroupDescription() { PropertyName = "OrderDate", Step = DateTimeStep.Year, GroupComparer = new GroupNameComparer() });
    dataProvider.RowGroupDescriptions.Add(new DateTimeGroupDescription() { PropertyName = "OrderDate", Step = DateTimeStep.Quarter, GroupComparer = new GroupNameComparer() });
    dataProvider.RowGroupDescriptions.Add(new DateTimeGroupDescription() { PropertyName = "OrderDate", Step = DateTimeStep.Month, GroupComparer = new GroupNameComparer() });
    dataProvider.ColumnGroupDescriptions.Add(new PropertyGroupDescription() { PropertyName = "EmployeeID", GroupComparer = new GrandTotalComparer() });
    dataProvider.EndInit();

    dataProvider.BeginInit();
    dataProvider.AggregateDescriptions.Add(new PropertyAggregateDescription() { PropertyName = "Freight", AggregateFunction = AggregateFunctions.Sum });
    dataProvider.AggregateDescriptions.Add(new PropertyAggregateDescription() { PropertyName = "Freight", AggregateFunction = AggregateFunctions.Average });
    dataProvider.EndInit();

    this.radPivotGrid1.DataProvider = dataProvider;
}


Workaround:

CultureInfo russianCultureInfo = new System.Globalization.CultureInfo("ru-RU"); 
List<string> monthNames = DateTimeFormatInfo.CurrentInfo.MonthNames.ToList();

public Form1()
{
    InitializeComponent();
    this.radPivotGrid1.GroupDescriptorElementCreating += radPivotGrid1_GroupDescriptorElementCreating;
}

private void radPivotGrid1_GroupDescriptorElementCreating(object sender, GroupDescriptorElementCreatingEventArgs e)
{
    if (e.GroupDescriptorElement.Text == "Month")
    {
        e.GroupDescriptorElement.FilterPopup.PopupOpening -= FilterPopupPopupOpening;
        e.GroupDescriptorElement.FilterPopup.PopupOpening += FilterPopupPopupOpening;
    }
}

private void FilterPopupPopupOpening(object sender, CancelEventArgs args)
{
    PivotGroupFilterPopup popup = sender as PivotGroupFilterPopup;
    if (popup != null)
    {
        popup.TreeViewMenuItem.TreeElement.TreeView.NodeFormatting -= TreeView_NodeFormatting;
        popup.TreeViewMenuItem.TreeElement.TreeView.NodeFormatting += TreeView_NodeFormatting;
    }
}

private void TreeView_NodeFormatting(object sender, TreeNodeFormattingEventArgs e)
{
    DateTime date;
    int monthIndex = monthNames.IndexOf(e.Node.Text);
  
    if (monthIndex > -1)
    {
        e.Node.Text = russianCultureInfo.DateTimeFormat.MonthNames[monthIndex];
    }
}

In the PrintElementFormatting event you need to be allowed to specify the PivotCellPrintElement.Text property in the desired format.

Workaround: use reflection to set the "formattedValue" readonly field for the PivotCellPrintElement.

To reproduce:

Open the demo application and navigate to Pivot -> Printing. Move the Aggregates descriptor next to the Product one and remove the Promotions descriptor. Click PrintPreview and you will see that the Product descriptor will not be visible

PivotGrid get all the rows that 'lie' beneath a visible cell value

RunExport(filename) method generates a System.UnauthorizedAccessException, Access to the path "C:\..." is denied. given that I`m the administrator and I`m able to export crystal report documents (all formats) with no issues at all. what could be the issue.
below is the sample code:
SaveFileDialog svd = new SaveFileDialog();
            svd.FileName = "AnyThing";
            svd.Filter = "Excel files (*.xls)|";            
            if (svd.ShowDialog() == DialogResult.OK)
            {                
                PivotExportToExcelML exportExcel = new PivotExportToExcelML(radPivotGrid1);
                exportExcel.ShowGridLines = true;
                exportExcel.ExportVisualSettings = true;
                exportExcel.HeaderCellsFont = new System.Drawing.Font("Arial", 8);
                exportExcel.DataCellsFont = new System.Drawing.Font("Arial", 8);
                exportExcel.GridLinesColor = Color.Black;
                exportExcel.CellBackColor = Color.White;
                exportExcel.SheetName = "Test";
                exportExcel.ExportFlatData = false;
                exportExcel.RunExport(Path.GetDirectoryName(svd.FileName));
            }

To reproduce:

Bind RadPivotGrid and associate it with RadPivotFieldList. Start the application and start selecting/unselecting fields from the field list. Observe how the memory usage is raising.

To reproduce:
- Open the demo application and navigate to the olap browser demo.
- Click the filter icon in the Product Line (top left corner).

To reproduce: 

1. Drag and drop RadPivotGrid.
2. On FormLoad call BestFitRowHeaders() method 
3. When run the project, an exception is thrown

One cannot copy cells from collapsed row groups.

DECLINED: The cells remain bold because there is no explicit setting for the Font property in the default state of the PivotCellElement. When one sets a style for a given element state, this setting will also remain for other states if they don't have an explicit setting for the same property. This is how our theming mechanism works. To resolve the issue, just set the Font property of the PivotCellElement in its default state in Visual Style Builder.

To reproduce:

Open ControlDefaultTheme in VisualStyleBuilder, go to RadPivotGrid -> RadPivotGridElement -> PivotCellElement and set bold font for the PivotCellElement.GrandTotalRow. Bind RadPivotGrid and set the properties AutoExpandColumnHeaders to false and AutoExpandRowHeaders to false. Start the application and expand the rows. You will see that the cells will be incorrectly formatted.