Hello!

I am trying to export the content in my UltraWinGrid but I have some problem with the cell borders.

At first, all of the excel cells that as exported from the grid ended up without borders. I then found a property

called WorkSheetCellFormat of the excel cell. So in the CellExported event of the UltraGridExcelExporter, i changed the formatting to exclude BorderFormatting.

That helped a lot but I still have some rows left that doesn't have borders.

Does anyone now how to fix these?

Private Sub ugExcelExport_CellExported(sender As Object, e As Infragistics.Win.UltraWinGrid.ExcelExport.CellExportedEventArgs)

Try

                e.CurrentWorksheet.Rows(e.CurrentRowIndex).Cells(e.CurrentColumnIndex).CellFormat.FormatOptions =

WorksheetCellFormatOptions.ApplyAlignmentFormatting + WorksheetCellFormatOptions.ApplyFontFormatting + WorksheetCellFormatOptions.ApplyNumberFormatting

Catch ex As Exception

End Try

End Sub