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. |