ExcludeContents Enumeration

Specifies a value that indicates whether a property is ignored when iterating through rows via the next non-empty logic.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum ExcludeContents 
   Inherits System.Enum

'Usage
 
Dim instance As ExcludeContents

public enum ExcludeContents : System.Enum

Members

Member	Description
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());

VB.NET

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

Requirements

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

Reference

FarPoint.Win.Spread.Model Namespace