Spread Windows Forms 11.0 Product Documentation
ExcludeContents Enumeration
Example Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace : ExcludeContents Enumeration
Specifies a value that indicates whether a property is ignored when iterating through rows via the next non-empty logic.
Syntax
'Declaration
 
Public Enum ExcludeContents 
   Inherits System.Enum
'Usage
 
Dim instance As ExcludeContents
public enum ExcludeContents : System.Enum 
Members
MemberDescription
ErrorTextIgnores error text
FormulaIgnores formulas
NoneNo object is ignored
NoteIgnores notes
TagIgnores tags
Example
This example uses the ExcludeContentsDuringNextNonEmpty enumeration.
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(8, 8);
fpSpread1.ActiveSheet.Models.Data = dataModel;   
fpSpread1.Sheets[0].Cells[5, 3].Text = "test";        
listBox1.Items.Add(dataModel.PreviousEmptyColumnInRow(5, 5, FarPoint.Win.Spread.Model.ExcludeContents.Tag).ToString());
listBox1.Items.Add(dataModel.PreviousEmptyColumnInRow(5, 5).ToString());
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(8, 8)
FpSpread1.ActiveSheet.Models.Data = dataModel
FpSpread1.Sheets(0).Cells(5, 3).Text = "test"
ListBox1.Items.Add(dataModel.PreviousEmptyColumnInRow(5, 5, FarPoint.Win.Spread.Model.ExcludeContents.Tag).ToString())
ListBox1.Items.Add(dataModel.PreviousEmptyColumnInRow(5, 5).ToString())
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Win.Spread.Model.ExcludeContents

See Also

Reference

FarPoint.Win.Spread.Model Namespace