.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

Alignment.Indent Property

Gets or sets the cell content indention from the cell edge, dependent on the applied horizontal alignment.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.2.Core.dll

Declaration

int Indent { get; set; }
Property Indent As Integer
int Indent { get; set; }
Property Indent As Integer
int Indent { get; set; }
Property Indent As Integer

Property Value

Type Description
Int32

An integer value that specifies a space between the cell content and cell edge. An indent increment is equal to three spaces of the Normal style font.

Property Value

Type Description
Int32

An integer value that specifies a space between the cell content and cell edge. An indent increment is equal to three spaces of the Normal style font.

Property Value

Type Description
Int32

An integer value that specifies a space between the cell content and cell edge. An indent increment is equal to three spaces of the Normal style font.

Remarks

The Indent property value is applied as described below.

  • If the used horizontal alignment is SpreadsheetHorizontalAlignment.Left, the Indent property specifies the space between the cell content and left edge of the cell.
  • If the used horizontal alignment is SpreadsheetHorizontalAlignment.Right, the Indent property specifies the space between the cell content and right edge of the cell.
  • If the used horizontal alignment is SpreadsheetHorizontalAlignment.Distributed, the Indent property specifies indents of the cell content from both right and left edges of the cell.
  • If the used horizontal alignment is other than Left, Right or Distributed, setting the Indent property value will automatically reset the horizontal alignment to SpreadsheetHorizontalAlignment.Left. Setting the horizontal alignment type to a value other than Left, Right or Distributed after the Indent has been specified, resets the Indent to 0.

To set other alignment characteristics for a cell or range of cells (e.g., horizontal and vertical alignment, text rotation, a value indicating whether the text should be wrapped and shrunk in a cell), use the corresponding properties of the Alignment object. Access this object via the Formatting.Alignment property.

For examples on how to specify formatting for an individual cell and cell range or modify a style, refer to the How to: Format a Cell or Range of Cells or How to: Create or Modify a Style documents, respectively.

Examples

This example demonstrates how to specify the alignment of cell content by modifying the Alignment object accessed via the Formatting.Alignment property of the Cell object.

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;
See Also