Approved
Last Updated: 04 Jun 2019 11:03 by ADMIN
n/a
Created on: 04 Jun 2019 10:56
Category: PivotGrid
Type: Bug Report
1
RadPivotGrid: Negative column width when exporting the grid with PivotExportToExcelML

To reproduce: 

- Set the ExportFlatData property to true

- Export the grid using PivotExportToExcelML

1 comment
ADMIN
Dimitar
Posted on: 04 Jun 2019 11:03
Hi,

Workaround:
Private Sub Exporter_TableCreated(ByVal sender As Object, ByVal e As ExcelTableCreatedEventArgs)
    For index = 0 To e.ExcelTableElement.Columns.Count - 1
        Dim att = e.ExcelTableElement.Columns(index).Attributes("ss:Width")
        If att IsNot Nothing And Convert.ToInt32(att) <= 0 Then
            e.ExcelTableElement.Columns(index).Attributes("ss:Width") = 60
        End If
    Next
End Sub


Regards,
Dimitar
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.