'Declaration Public Event SummaryCellExported As SummaryCellExportedEventHandler
public event SummaryCellExportedEventHandler SummaryCellExported
The event handler receives an argument of type SummaryCellExportedEventArgs containing data related to this event. The following SummaryCellExportedEventArgs properties provide information specific to this event.
Property | Description |
---|---|
CurrentColumnIndex (Inherited from Infragistics.Win.UltraWinGrid.ExcelExport.ExcelExportEventArgs) | Zero-based index of current exporting column in excel worksheet. |
CurrentOutlineLevel (Inherited from Infragistics.Win.UltraWinGrid.ExcelExport.ExcelExportEventArgs) | Current outline level used for grouping. |
CurrentRowIndex (Inherited from Infragistics.Win.UltraWinGrid.ExcelExport.ExcelExportEventArgs) | Zero-based index of current exporting row in excel worksheet. |
CurrentWorksheet (Inherited from Infragistics.Win.UltraWinGrid.ExcelExport.ExcelExportEventArgs) | Current exporting worksheet. |
Summary | Summary value. |
SummaryLevel | Summary level. |
Workbook (Inherited from Infragistics.Win.UltraWinGrid.ExcelExport.ExcelExportEventArgs) | Exporting workbook. |
The Summary argument returns a reference to a summary value.
The SummaryLevel argument returns current summary level.
Additionaly this event has Workbook, CurrentWorksheet, CurrentRowIndex, CurrentColumnIndex, CurrentOutlineLevel arguments inherited from ExcelExportEventArgs.
This event is fired after excel cell with summary value is processed. Use it to apply any additional formatting to excel cell.
Private Sub MyGridExporter_SummaryCellExporting(ByVal sender As Object, ByVal e As Infragistics.Win.UltraWinGrid.ExcelExport.SummaryCellExportingEventArgs) Handles MyGridExporter.SummaryCellExporting If e.CurrentColumnIndex Mod 2 = 0 And Not e.Summary Is Nothing Then e.Summary.Appearance.BackColor = Color.LightCoral End If End Sub Private Sub MyGridExporter_SummaryCellExported(ByVal sender As Object, ByVal e As Infragistics.Win.UltraWinGrid.ExcelExport.SummaryCellExportedEventArgs) Handles MyGridExporter.SummaryCellExported If e.CurrentColumnIndex Mod 2 = 0 And Not e.Summary Is Nothing Then Dim tmCF As IWorksheetCellFormat = e.CurrentWorksheet.Rows(e.CurrentRowIndex).Cells(e.CurrentColumnIndex).CellFormat tmCF.BottomBorderStyle = CellBorderLineStyle.Double tmCF.TopBorderStyle = CellBorderLineStyle.Double tmCF.LeftBorderStyle = CellBorderLineStyle.Double tmCF.RightBorderStyle = CellBorderLineStyle.Double End If End Sub
private void SummaryCellExportingEH(object sender, Infragistics.Win.UltraWinGrid.ExcelExport.SummaryCellExportingEventArgs e) { if(e.CurrentColumnIndex%2==0 && e.Summary!=null) e.Summary.Appearance.BackColor = Color.LightCoral; } private void SummaryCellExportedEH(object sender, Infragistics.Win.UltraWinGrid.ExcelExport.SummaryCellExportedEventArgs e) { if(e.CurrentColumnIndex%2==0 && e.Summary!=null) { IWorksheetCellFormat tmCF = e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[e.CurrentColumnIndex].CellFormat; tmCF.BottomBorderStyle = tmCF.TopBorderStyle = tmCF.LeftBorderStyle = tmCF.RightBorderStyle = CellBorderLineStyle.Double; } }
Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2