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
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.
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.
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.
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.
GetFont0SpaceWidth Returns the width of a space (" ") in the main font of the workbook.
GetFont0Width Overloaded
GetFont0Width(IRowColSize)
GetFont0Width(IRowColSize, Boolean)
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.