XlVerticalAlignment Enum

Lists values used to specify the vertical alignment of the cell content.

Namespace: DevExpress.Export.Xl

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

Declaration

C#

public enum XlVerticalAlignment

VB.NET

Public Enum XlVerticalAlignment

Members

Name	Description
Top	The cell content is vertically aligned at the top.
Center	The cell content is centered vertically.
Bottom	The cell content is vertically aligned at the bottom.
Justify	The cell content is vertically justified.
Distributed	The text is vertically distributed across the cell height.

Related API Members

The following properties accept/return XlVerticalAlignment values:

• XlCellAlignment.VerticalAlignment

Remarks

The values listed by this enumeration are used by the XlCellAlignment.VerticalAlignment property.

For details on how to align data in a cell, see the How to: Align Cell Content topic.

Related GitHub Examples

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

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#

excel-export-api-examples-t253492/CS/XLExportExamples/SpreadsheetActions/MiscellaneousActions.cs#L125

using(IXlColumn column = sheet.CreateColumn()) {
    column.Formatting = XlCellAlignment.FromHV(XlHorizontalAlignment.Center, XlVerticalAlignment.Bottom);
}

how-to-use-the-excel-export-api-to-generate-an-invoice-t252983/CS/XLExportExample/Form1.cs#L75

leftPanelFormatting.Fill = XlFill.SolidFill(Color.FromArgb(89, 89, 89));
leftPanelFormatting.Alignment = XlCellAlignment.FromHV(XlHorizontalAlignment.Left, XlVerticalAlignment.Bottom);
leftPanelFormatting.NumberFormat = XlNumberFormat.General;

how-to-copy-cell-data-in-an-excel-format-biff8-to-the-clipboard-using-xl-export-library-t266171/CS/gridCopyToClipboardExample/CopyToClipboardHelper.cs#L115

XlVerticalAlignment ConvertAlignment(VertAlignment verticalAlignment) {
    switch (verticalAlignment) {

how-to-use-the-excel-export-api-to-generate-a-sales-report-t251810/CS/XLExportExampleSalesReport/Form1.cs#L32

headerRowFormatting.Fill = XlFill.SolidFill(XlColor.FromTheme(XlThemeColor.Accent1, 0.0));
headerRowFormatting.Alignment = XlCellAlignment.FromHV(XlHorizontalAlignment.Right, XlVerticalAlignment.Bottom);

how-to-customize-the-gridcontrols-data-aware-export-output-t247610/CS/GridDataAwareExportCustomization/Form1.cs#L72

    HorizontalAlignment = XlHorizontalAlignment.Center,
    VerticalAlignment = XlVerticalAlignment.Center
};

VB.NET

excel-export-api-examples-t253492/VB/XLExportExamples/SpreadsheetActions/MiscellaneousActions.vb#L128

Using column As IXlColumn = sheet.CreateColumn()
    column.Formatting = XlCellAlignment.FromHV(XlHorizontalAlignment.Center, XlVerticalAlignment.Bottom)
End Using

how-to-use-the-excel-export-api-to-generate-an-invoice-t252983/VB/XLExportExample/Form1.vb#L77

leftPanelFormatting.Fill = XlFill.SolidFill(Color.FromArgb(89, 89, 89))
leftPanelFormatting.Alignment = XlCellAlignment.FromHV(XlHorizontalAlignment.Left, XlVerticalAlignment.Bottom)
leftPanelFormatting.NumberFormat = XlNumberFormat.General

how-to-copy-cell-data-in-an-excel-format-biff8-to-the-clipboard-using-xl-export-library-t266171/VB/gridCopyToClipboardExample/CopyToClipboardHelper.vb#L118

Private Function ConvertAlignment(ByVal verticalAlignment As VertAlignment) As XlVerticalAlignment
    Select Case verticalAlignment

how-to-use-the-excel-export-api-to-generate-a-sales-report-t251810/VB/XLExportExampleSalesReport/Form1.vb#L34

headerRowFormatting.Fill = XlFill.SolidFill(XlColor.FromTheme(XlThemeColor.Accent1, 0.0))
headerRowFormatting.Alignment = XlCellAlignment.FromHV(XlHorizontalAlignment.Right, XlVerticalAlignment.Bottom)

how-to-customize-the-gridcontrols-data-aware-export-output-t247610/VB/GridDataAwareExportCustomization/Form1.vb#L73

' Specify the value alignment for Discontinued field.
Private aligmentForDiscontinuedColumn As New XlCellAlignment() With {.HorizontalAlignment = XlHorizontalAlignment.Center, .VerticalAlignment = XlVerticalAlignment.Center}