The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

Worksheet.DefaultColumnWidthInPixels Property

Gets or sets the default column width in pixels.

Namespace: DevExpress.Spreadsheet

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

Declaration

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

Property Value

Type Description
Int32

An integer value that is a column width in pixels.

Property Value

Type Description
Int32

An integer value that is a column width in pixels.

Remarks

Use the DefaultColumnWidthInPixels, Worksheet.DefaultColumnWidthInCharacters or Worksheet.DefaultColumnWidth property to set the width of worksheet columns whose width is not specified explicitly. If you need to set the width of all columns on the worksheet to the same value and override all previously applied column width settings, use the Range.ColumnWidth property of the Row object corresponding to any row on a worksheet.

For information on how to change the height of worksheet rows, see the How to: Specify Row Height or Column Width example.

Examples

This example demonstrates how to control the column width on a worksheet.

// Set the "B" column width to 30 characters of the default font that is specified by the Normal style.
worksheet.Columns["B"].WidthInCharacters = 30;

// Set the "C" column width to 15 millimeters.
workbook.Unit = DevExpress.Office.DocumentUnit.Millimeter;
worksheet.Columns["C"].Width = 15;

// Set the width of the column that contains the "E15" cell to 100 points.
workbook.Unit = DevExpress.Office.DocumentUnit.Point;
worksheet.Cells["E15"].ColumnWidth = 100;

// Set the width of all columns that contain the "F4:H7" cell range (the "F", "G" and "H" columns) to 70 points.
worksheet.Range["F4:H7"].ColumnWidth = 70;

// Set the "J" column width to the "B" column width value.
worksheet.Columns["J"].Width = worksheet.Columns["B"].Width;

// Copy the "C" column width value and assign it to the "K" column width.
worksheet.Columns["K"].CopyFrom(worksheet.Columns["C"], PasteSpecial.ColumnWidths);

// Set the default column width to 40 pixels.
worksheet.DefaultColumnWidthInPixels = 40;
See Also