Completed
Last Updated: 09 Feb 2015 11:16 by ADMIN
ADMIN
George
Created on: 23 Jun 2014 13:26
Category: PivotGrid
Type: Bug Report
0
FIX. RadPivotGrid - ExportToExcelML does not allow you to set borders to the exported cells
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.
7 comments
ADMIN
Stefan
Posted on: 09 Feb 2015 11:16
There shouldn't be a problem with the upgrade wizard. Here is an article how to upgrade to the latest version: http://www.telerik.com/help/winforms/installation-deployment-and-distribution-vsx-automatic-latest-version-retrieval.html

If you still have issues, please open a new ticket from the link below, with product "Installers and VS extensions for WinForms". Here is the link: http://www.telerik.com/account/support-tickets/new-support-ticket.aspx
Kantor
Posted on: 09 Feb 2015 10:11
Is there a problem with Telerik updater? I go in my (Microsoft Visual Studio 2010) at the Telerik menu. I selected UI for Winforms and Upgrade Wizard. The default version is (Dev)GAC one and click upgrade. After finishing the upgrade successfully the Telerik Winforms UI version is the same with the one before the upgrade operation. I know it is not in the topic ,but couldnt find how to open new ticket.
Kantor
Posted on: 09 Feb 2015 09:52
I will try. and thanks for your time.
ADMIN
Stefan
Posted on: 06 Feb 2015 16:44
Well, this is why you are not seeing the fix - because it does not exist in your version. Please upgrade to 2014.3.1202.
Kantor
Posted on: 06 Feb 2015 15:11
My last updated version for telerik winforms is UI for WinForms, v2014.2.715.40(Dev). With this telerik winforms version I generated my export excel.
ADMIN
Stefan
Posted on: 06 Feb 2015 14:18
Hi Kantor,

this fix was release in version Q3 2014 SP1 (out latest version 2014.3.1202). Can you make sure you are testing it with this version and if you still experience any issues, may I please ask you to open a support ticket (http://www.telerik.com/account/support-tickets/new-support-ticket.aspx) and share the scenario you have mentioning this feedback item as well.

Thank you.
Kantor
Posted on: 06 Feb 2015 09:22
I tried your solution and the excel and it doesnt display the excel gridlines. I attach the excel export file. Please help.
Attached Files: