Measure Units
- 2 minutes to read
The XtraSpreadsheet allows you to select a unit of measurement for various distance values of a workbook (such as column width, row height and page margins). To set a single unit of measurement, use the SpreadsheetControl.Unit property or the Unit property of the IWorkbook object returned by SpreadsheetControl.Document.
Unit of Measurement | Description | How to Use |
|---|---|---|
Document | Document (1 document unit is equal to 1/300 of an inch). This is a default measure unit of a workbook. | Set the Unit property to DocumentUnit.Document. |
Centimeter | Centimeter (1 inch is equal to 2.54 centimeters) | Set the Unit property to DocumentUnit.Centimeter. |
Millimeter | Millimeter (10 millimeters are equal to 1 centimeter) | Set the Unit property to DocumentUnit.Millimeter. |
Inch | Inch | Set the Unit property to DocumentUnit.Inch. |
Point | Point (1 inch is equal to 72 points) | Set the Unit property to DocumentUnit.Point. |
Pixel | Pixel (1 inch is equal to 96 pixels). You can use this unit to set column width. | Use the following properties to set column width in pixels. |
Character | Character (the width of the zero character in the font specified by the built-in Normal style). You can use this unit to set column width. | Use the following properties to set column width in characters. Worksheet.DefaultColumnWidthInCharacters |
A workbook’s units of measurement specified by the Unit property are used in the following cases.
- When you specify a column width via the Worksheet.DefaultColumnWidth, CellRange.ColumnWidth or Column.Width property.
- When you specify a row height via the Worksheet.DefaultRowHeight, CellRange.RowHeight or Row.Height property.
- When you specify page margins via the properties of the Margins object.