Table of Contents

ExcelMetrics Class

Returns Information to convert between standard units and Excel units.

Syntax

Namespace: FlexCel.Core

public static class ExcelMetrics

Methods

Name Description
GetFont0Width Overloaded
GetFont0Width(IRowColSize)
GetFont0Width(IRowColSize, Boolean)
GetFont0SpaceWidth Returns the width of a space (" ") in the main font of the workbook.
FmlaMult When showing/printing the sheet and "Show formula" check box is on, column widths are double of the normal ones.
This method returns 0.5 when "Show formulas" is turned on, and 1 if it is not.
ColMultDisplay Multiply by this number to convert the width of a column from GraphicsUnit.​Display units (1/100 inch) to Excel internal units. Note that the default column width is different, you need to multiply by DefColWidthAdapt See Excel Internal Units for more information in Excel internal units.
RowMultDisplay Multiply by this number to convert the height of a row from GraphicsUnit.​Display units (1/100 inch) to Excel internal units.
See Excel Internal Units for more information in Excel internal units.
ColMult Multiply by this number to convert the width of a column from resolution-​independent-​pixels (1/96 of an inch) to excel internal units.
Note that the default column width is different, you need to multiply by DefColWidthAdapt See Excel Internal Units for more information in Excel internal units.
DefColWidthAdapt Convert the DEFAULT column width to resolution-​independent-​pixels (1/96 of an inch). This is different from ColMult, that goes in a column by column basis.
See Excel Internal Units for more information in Excel internal units.