TExcelMetrics Record
Returns Information to convert between standard units and Excel units.
Syntax
Unit: FlexCel.Core
TExcelMetrics = record;
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)
|
| GetRowHeightInPixels |
Returns the Height of an XF format Excel.
|
| 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.
|