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
DefaultRowHeight​Visual	The default height for empty rows, in Excel internal units. (1/20th of a point). Different from ExcelFile.​Default​RowHeight this property returns the actual row height as Excel will show it, considering ExcelFile.​Default​RowHidden and ExcelFile.​Default​RowHeight​Automatic. 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.​Sheet​Options This property can work in different windows depending on the value of ExcelFile.​Active​Window
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]