Spread Windows Forms 7.0 Product Documentation
IsRowUsed Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetDataModel Class : IsRowUsed Method


Glossary Item Box

Specifies whether the row uses a formula, tag, or note.

Overload List

OverloadDescription
IsRowUsed(Int32,Boolean,Boolean,Boolean)Specifies whether the row uses a formula, tag, or note.  
IsRowUsed(Int32)Determines whether the specified row is not empty.  

Example

Visual BasicCopy Code
Dim dt As New DataTable("Testing")
Dim b As Boolean
dt.Columns.Add("Number")
dt.Columns.Add("Letter")
dt.Rows.Add(New Object() {"1", "One"})
dt.Rows.Add(New Object() {"2", "Two"})
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(dt)
FpSpread1.ActiveSheet.Models.Data = dataModel
b = dataModel.IsRowUsed(1)
ListBox1.Items.Add(b.ToString())
C#Copy Code
DataTable dt = new DataTable("Testing");
bool b;
dt.Columns.Add("Number");
dt.Columns.Add("Letter");
dt.Rows.Add(new Object[]{"1", "One"});
dt.Rows.Add(new Object[] {"2", "Two"});
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(dt);
fpSpread1.ActiveSheet.Models.Data = dataModel;
b = dataModel.IsRowUsed(1);
listBox1.Items.Add(b.ToString());

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.