Provides access to the cell content alignment settings.
The Alignment object provides a set of properties that you can use to align data contained within a cell (Alignment.Horizontal, Alignment.Vertical, Alignment.Indent, Alignment.WrapText, Alignment.ShrinkToFit and Alignment.RotationAngle).
To access the Alignment object, use the Formatting.Alignment property.
A complete sample project is available at https://github.com/DevExpress-Examples/spreadsheet-document-server-api-e4339
Cell cellA1 = worksheet.Cells["A1"]; cellA1.Value = "Right and top"; cellA1.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Right; cellA1.Alignment.Vertical = SpreadsheetVerticalAlignment.Top; Cell cellA2 = worksheet.Cells["A2"]; cellA2.Value = "Center"; cellA2.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center; cellA2.Alignment.Vertical = SpreadsheetVerticalAlignment.Center; Cell cellA3 = worksheet.Cells["A3"]; cellA3.Value = "Left and bottom, indent"; cellA3.Alignment.Indent = 1; Cell cellB1 = worksheet.Cells["B1"]; cellB1.Value = "The Alignment.ShrinkToFit property is applied"; cellB1.Alignment.ShrinkToFit = true; Cell cellB2 = worksheet.Cells["B2"]; cellB2.Value = "Rotated Cell Contents"; cellB2.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center; cellB2.Alignment.Vertical = SpreadsheetVerticalAlignment.Center; cellB2.Alignment.RotationAngle = 15; Cell cellB3 = worksheet.Cells["B3"]; cellB3.Value = "The Alignment.WrapText property is applied to wrap the text within a cell"; cellB3.Alignment.WrapText = true;
Dim cellA1 As Cell = worksheet.Cells("A1") cellA1.Value = "Right and top" cellA1.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Right cellA1.Alignment.Vertical = SpreadsheetVerticalAlignment.Top Dim cellA2 As Cell = worksheet.Cells("A2") cellA2.Value = "Center" cellA2.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center cellA2.Alignment.Vertical = SpreadsheetVerticalAlignment.Center Dim cellA3 As Cell = worksheet.Cells("A3") cellA3.Value = "Left and bottom, indent" cellA3.Alignment.Indent = 1 Dim cellB1 As Cell = worksheet.Cells("B1") cellB1.Value = "The Alignment.ShrinkToFit property is applied" cellB1.Alignment.ShrinkToFit = True Dim cellB2 As Cell = worksheet.Cells("B2") cellB2.Value = "Rotated Cell Contents" cellB2.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center cellB2.Alignment.Vertical = SpreadsheetVerticalAlignment.Center cellB2.Alignment.RotationAngle = 15 Dim cellB3 As Cell = worksheet.Cells("B3") cellB3.Value = "The Alignment.WrapText property is applied to wrap the text within a cell" cellB3.Alignment.WrapText = True