IRowColSize Interface
Interface for row heights and columns widths. XlsFile implements this interface, so you can pass an XlsFile object anytime you need to pass this interface.
Syntax
Namespace: FlexCel.Core
public interface IRowColSize;
Methods
Name | Description |
---|---|
DefaultRowHeightVisual | The default height for empty rows, in Excel internal units. (1/20th of a point). Different from ExcelFile.DefaultRowHeight this property returns the actual row height as Excel will show it, considering ExcelFile.DefaultRowHidden and ExcelFile.DefaultRowHeightAutomatic. See Excel Internal Units for more information in Excel internal units. |
IsEmptyRow | True if the specified row does not have any cells, nor any format on it. In short, this row has never been used. |
GetRowHeight | Returns the current Row height, in Excel internal units. (1/20th of a point) See Excel Internal Units for more information in Excel internal units. |
GetColWidth | Returns the current Column width, in Excel internal units. (Character width of font 0 / 256) See Excel Internal Units for more information in Excel internal units. |
GetCachedFont0 | This method is used by FlexCel itself, you shouldn't call it directly. |
SetCachedFont0 | This method is used by FlexCel itself, you shouldn't call it directly. |
Properties
Name | Description |
---|---|
DefaultColWidth | The default width for empty columns, in Excel internal units. (Character width of font 0 / 256) See Excel Internal Units for more information in Excel internal units. |
ShowFormulaText | When true, the formula text will be displayed instead of the formula value. You can also set this option with ExcelFile.SheetOptions This property can work in different windows depending on the value of ExcelFile.ActiveWindow |
GetDefaultFont | Returns Excel standard font for an empty cell. |
WidthCorrection | Factor to multiply default column widths. See remarks for a detailed explanation. |
HeightCorrection | Factor to multiply default row heights. See remarks for a detailed explanation. |
ScreenScaling | This property lets you specify the screen scaling that FlexCel will assume for reading xlsx files in percent. (default is 100 which means 100%). The values can be between 100 and 500. Column widths in xlsx files which don't have a fixed column width set will be different in different screen resolutions. So we need to know which resolution to emulate in order to read those files correctly. You will probably want to leave this property to the default value of 100, but you can change it if needed. ...[more] |