Skip to main content

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

XlDifferentialFormatting TotalRowFormatting { get; set; }

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.

See Also