My users love the UltraGrid exporting.
They are asking for a check mark, or maybe even just "XX" instead of "True" or "False".
Doable?
Excel doesn't support CheckBoxes in cells as far as I know. But you could change the text of the exported cell in the CellExported event of the UltraGridExcelExporter.
Mike - Thanks for your suggestion, it helped as always.
Here is the code that does the trick.
If e.GridColumn.DataType.Name.Equals("Boolean") Then
e.CurrentWorksheet.Rows(e.CurrentRowIndex).Cells(e.CurrentColumnIndex).CellFormat.Font.Name = "Wingdings"
If e.Value Then
e.CurrentWorksheet.Rows(e.CurrentRowIndex).Cells(e.CurrentColumnIndex).Value = Chr(254)
Else
e.CurrentWorksheet.Rows(e.CurrentRowIndex).Cells(e.CurrentColumnIndex).Value = Chr(168)
End If
End Sub
Thanks for the code! That helped me too :)