IXlTable.TotalRowFormatting Property
Gets or sets format characteristics for the total row of the table.
Namespace: DevExpress.Export.Xl
Assembly: DevExpress.Printing.v24.1.Core.dll
NuGet Package: DevExpress.Printing.Core
Declaration
Property Value
| Type | Description |
|---|---|
| DevExpress.Export.Xl.XlDifferentialFormatting | An XlDifferentialFormatting instance that specifies format characteristics applied to the table’s total row. |
Remarks
Use the TotalRowFormatting property to apply custom formatting to the total row of the table. In particular, you can color the cell background, adjust font settings, align the cell content, add borders and specify number format options. To do this, use properties of the XlDifferentialFormatting object inherited from the XlFormatting class: XlFormatting.Fill, XlFormatting.Font, XlFormatting.Alignment, XlFormatting.Border and XlFormatting.NumberFormat. Moreover, the XlDifferentialFormatting object implements implicit conversion from the XlFill, XlFont, XlCellAlignment, XlBorder and XlNumberFormat objects, so that you can directly assign an object containing the required format settings to the TotalRowFormatting property without using unnecessary cast operators.
To apply special formatting to the total cell of a particular table column, use the IXlTableColumn.TotalRowFormatting property.
For more information on how to set custom formatting for different table regions and individual table columns, refer to the How to: Apply Custom Formatting to a Table example.