Hello Thangachan,

You cannot check the cell format in the CellExporting event, but you can get the CurrentColumnIndex and the CurrentRowIndex and check the cell based on this as in the sample provided.

Private Sub UltraGridExcelExporter1_CellExporting(sender As Object, e As UltraWinGrid.ExcelExport.CellExportingEventArgs) Handles UltraGridExcelExporter1.CellExporting

        If e.CurrentColumnIndex = 2 And e.CurrentRowIndex = 41 Then
            e.Cancel = True
            If _theCellFormat Is Nothing Then
                _theCellFormat = e.Workbook.CreateNewWorksheetCellFormat()
                _theCellFormat.FormatString = "0.00\% [Red]"
            End If
            Dim Worksheet = TryCast(e.CurrentWorksheet, Worksheet)
            Worksheet.Rows(41).Cells(2).Value = e.GridValue
            Worksheet.Rows(41).Cells(2).CellFormat.SetFormatting(_theCellFormat)
        End If
    End Sub

Also, have in mind that the CellExporting event occurs before the cell is exported in excel. So, you can apply formatting on the currently exported cell. If you have to check the value of another cell of the same row as in the previous example with the "LTIRA" cell, you can handle the RowExporting event.

Hi,

The word LTIRA a keyword to search to set Percentage format but for the format we have set for the column as decimal, below is the code snippet:

Dim EditorSettings As New DefaultEditorOwnerSettings
EditorSettings.DataType = GetType([Decimal])
EditorSettings.Format = "###,###,###,##0.00%"
Dim editor = New EditorWithText(New DefaultEditorOwner(EditorSettings))

e.Row.Cells("fqtd_act_qtd").Editor = editor

The above code is in the Grid Event : InitializeRow and we are getting the format properly while export we have added the below code:

Private Sub MyGridExporter_CellExporting(ByVal sender As Object, ByVal e As Infragistics.Win.UltraWinGrid.ExcelExport.CellExportingEventArgs) 'Handles MyGridExporter.CellExporting
Dim cell As Infragistics.Win.UltraWinGrid.UltraGridCell = e.GridRow.Cells(e.GridColumn)

Dim _theCellFormat As IWorksheetCellFormat = Nothing
Dim theHeaderFormat As IWorksheetCellFormat = e.Workbook.CreateNewWorksheetCellFormat()
theHeaderFormat.FormatString = "0.00%;[Red](0.00%)"

e.CurrentWorksheet.Rows(41).Cells(2).CellFormat.SetFormatting(theHeaderFormat)

End Sub

In the CellExporting event how we need find for each cell what is the format assigned in the grid.

Please let us know and provide sample project in VB.net.

Hi,

Looking in the provided code snippet, I understand that the cell that would be presented in percentage format is of type string and the value is “LTIRA”. Is that correct? There is no way to format text value as percentage format, because it has to be numeric format.

Looking forward to hear from you.

Hi,

Can you please update on this, it is very critical.

Provide a solution.

We have tried the below code provided by you in VB.NET:

Private Sub MyGridExporter_CellExporting(ByVal sender As Object, ByVal e As Infragistics.Win.UltraWinGrid.ExcelExport.CellExportingEventArgs) 'Handles MyGridExporter.CellExporting
Dim cell As Infragistics.Win.UltraWinGrid.UltraGridCell = e.GridRow.Cells(e.GridColumn)
Dim _theCellFormat As IWorksheetCellFormat = Nothing

If cell.Text = "LTIRA" Then
Dim theHeaderFormat As IWorksheetCellFormat = e.Workbook.CreateNewWorksheetCellFormat()
theHeaderFormat.FormatString = "0\%"
e.CurrentWorksheet.Rows(41).Cells(9).CellFormat.SetFormatting(theHeaderFormat)

End If

End Sub

But still we are not getting the percentage format in excel. We are following this to show percentage in a particular row.

Kindly provide sample VB.NET project with more detail code