Range.ColumnWidthInCharacters Property
Gets or sets the width of columns that contain the cell range in characters of the default font specified by the built-in Normal style.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v18.2.Core.dll
Declaration
Property Value
| Type | Description |
|---|---|
| Double | A Double value that is the number of characters that can be accommodated into the column width when the column is formatted with the built-in Normal style. |
Remarks
To set or obtain the column width in units of measurement used in the workbook, use the Range.ColumnWidth property.
If columns containing the cell range have different widths, the ColumnWidthInCharacters and Range.ColumnWidth properties return the width of the left column.
Example
This example demonstrates how to control the column width on a worksheet.
Set the Width for Individual Columns
To specify a column width in characters of the default font specified by the built-in Normal style, use the column’s Column.WidthInCharacters property, or the
Range.ColumnWidthInCharactersproperty of the cell or cell range object.To specify a column width in pixels, use the column’s Column.WidthInPixels property.
To set a column width in other measurement units, first set the IWorkbook.Unit property to the DocumentUnit enumeration member that corresponds to the desired units, then use the column’s Column.Width property, or the Range.ColumnWidth property of the cell or cell range object.
Note
If a column width is set to 0, the column is hidden. You can also use the Column.Visible property to hide a column or display the hidden column again (see the How to: Show or Hide a Row or Column document).
AutoFit Column Width
To automatically change the column width to fit the contents, use the columns’s Column.AutoFit method. To quickly autofit several columns on a worksheet, use the ColumnCollection.AutoFit method.
Match the Width of Two Columns
To match one column width to another, you can use the Column.Width property or Range.CopyFrom method of the column object.
Set the Default Column Width
To set the default width for worksheet columns, use the Worksheet.DefaultColumnWidthInCharacters, Worksheet.DefaultColumnWidthInPixels or Worksheet.DefaultColumnWidth property. These properties do not affect columns with an explicitly specified width.
Set the Width for All Columns on a Worksheet
To change the width of all columns on a worksheet, use the
Range.ColumnWidthInCharactersor Range.ColumnWidth property of the Row object corresponding to any row on a worksheet. This sets the width of all columns to the same value, overriding all previously applied column width settings.
Note
A complete sample project is available at https://github.com/DevExpress-Examples/winforms-spreadsheetcontrol-api-e4655
// 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;
Related GitHub Examples
The following code snippets (auto-collected from DevExpress Examples) contain references to the ColumnWidthInCharacters 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.