Class Row

Inheritance
System.Object
AbstractFormattable
Row
Inherited Members
Namespace: DRIT.Spreadsheet
Assembly: DRIT.Spreadsheet.dll
Syntax
public class Row : AbstractFormattable

Properties

Address

Declaration
public CellAddress Address { get; }
Property Value
Type Description
CellAddress

Count

Declaration
public int Count { get; }
Property Value
Type Description
System.Int32

CustomFormat

Declaration
public bool CustomFormat { get; set; }
Property Value
Type Description
System.Boolean

CustomHeight

Gets the custom height set for the row.

Declaration
public double? CustomHeight { get; }
Property Value
Type Description
System.Nullable<System.Double>

Null is custom height is not set.

FullLabel

Declaration
public string FullLabel { get; }
Property Value
Type Description
System.String

HeightPixels

Gets or sets the height of the row in pixels.

Declaration
public double HeightPixels { get; set; }
Property Value
Type Description
System.Double

HeightPoints

Get or set the declared height of the row. If the value is null, the actual height will be the default row height of the sheet.

Declaration
public double HeightPoints { get; set; }
Property Value
Type Description
System.Double

Index

Declaration
public int Index { get; }
Property Value
Type Description
System.Int32

IsCollapsed

Gets or sets whether the dimension is collapsed.

Declaration
public bool IsCollapsed { get; set; }
Property Value
Type Description
System.Boolean

IsHidden

Declaration
public bool IsHidden { get; set; }
Property Value
Type Description
System.Boolean

IsSelected

Declaration
public bool IsSelected { get; }
Property Value
Type Description
System.Boolean

Label

Declaration
public string Label { get; }
Property Value
Type Description
System.String

OutlineLevel

Gets or sets the outline level of the row/ group.

Declaration
public int OutlineLevel { get; set; }
Property Value
Type Description
System.Int32

ShowPhonetic

Declaration
public bool ShowPhonetic { get; set; }
Property Value
Type Description
System.Boolean

ThickBottom

Declaration
public bool ThickBottom { get; set; }
Property Value
Type Description
System.Boolean

ThickTop

Declaration
public bool ThickTop { get; set; }
Property Value
Type Description
System.Boolean

Methods

Autofit()

Set the height of the row so that it fits its content

Declaration
public void Autofit()

GetNonEmptyCells()

Gets the non empty cells from the cell storage ordered by column or row index.

Declaration
public virtual IEnumerable<Cell> GetNonEmptyCells()
Returns
Type Description
IEnumerable<Cell>
Remarks

In case of merged cells only the first cell is returned.

SetDefaultHeight()

Declaration
public void SetDefaultHeight()

ToString()

Declaration
public override string ToString()
Returns
Type Description
System.String

Operators

Addition(Row, Int32)

Declaration
public static Row operator +(Row This, int offset)
Parameters
Type Name Description
Row This
System.Int32 offset
Returns
Type Description
Row

GreaterThanOrEqual(Row, Row)

Declaration
public static bool operator >=(Row dim1, Row dim2)
Parameters
Type Name Description
Row dim1
Row dim2
Returns
Type Description
System.Boolean

LessThanOrEqual(Row, Row)

Declaration
public static bool operator <=(Row dim1, Row dim2)
Parameters
Type Name Description
Row dim1
Row dim2
Returns
Type Description
System.Boolean