Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.Model Namespace / ExcludeContents Enumeration
Example Example


In This Topic
    ExcludeContents Enumeration
    In This Topic
    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
    ErrorText Ignores error text
    Formula Ignores formulas
    None No object is ignored
    Note Ignores notes
    Tag Ignores 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