XlHeaderFooter.OddFooter Property

Gets or sets the text to be displayed in the footer of odd-numbered pages.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public string OddFooter { get; set; }

VB.NET

Public Property OddFooter As String

Property Value

Type	Description
String	A String object that specifies the footer for odd-numbered pages.

Remarks

If the XlHeaderFooter.DifferentOddEven property is set to true, the OddFooter property allows you to set the footer content for odd-numbered pages. Otherwise, these settings are used for all pages in a worksheet (both for even-numbered and odd-numbered pages).

If the XlHeaderFooter.DifferentFirst property is set to false (default value), the first page has the same footer as other odd-numbered pages.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the OddFooter property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-use-the-excel-export-api-to-generate-a-list-of-employees/CS/XLExportExample/Form1.cs#L283

sheet.HeaderFooter.OddHeader = XlHeaderFooter.FromLCR("NorthWind Inc.", null, XlHeaderFooter.Date);
sheet.HeaderFooter.OddFooter = XlHeaderFooter.FromLCR("List of employees", null, XlHeaderFooter.PageNumber + " of " + XlHeaderFooter.PageTotal);

excel-export-library-generate-sales-report/CS/XLExportExampleSalesReport/Form1.cs#L390

sheet.HeaderFooter.OddHeader = XlHeaderFooter.FromLCR(XlHeaderFooter.Bold + "DevAV", null, XlHeaderFooter.Date);
sheet.HeaderFooter.OddFooter = XlHeaderFooter.FromLCR("Sales report", null, XlHeaderFooter.PageNumber + " of " + XlHeaderFooter.PageTotal);

VB.NET

how-to-use-the-excel-export-api-to-generate-a-list-of-employees/VB/XLExportExample/Form1.vb#L267

sheet.HeaderFooter.OddHeader = XlHeaderFooter.FromLCR("NorthWind Inc.", Nothing, XlHeaderFooter.Date)
sheet.HeaderFooter.OddFooter = XlHeaderFooter.FromLCR("List of employees", Nothing, XlHeaderFooter.PageNumber & " of " & XlHeaderFooter.PageTotal)
' Specify page margins.

excel-export-library-generate-sales-report/VB/XLExportExampleSalesReport/Form1.vb#L403

sheet.HeaderFooter.OddHeader = XlHeaderFooter.FromLCR(XlHeaderFooter.Bold & "DevAV", Nothing, XlHeaderFooter.Date)
sheet.HeaderFooter.OddFooter = XlHeaderFooter.FromLCR("Sales report", Nothing, XlHeaderFooter.PageNumber & " of " & XlHeaderFooter.PageTotal)