Spread Windows Forms 6.0 Product Documentation
Tag Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > Cell Class : Tag Property


Glossary Item Box

Gets or sets an application-defined tag value for a cell.

Syntax

Visual Basic (Declaration) 
Public Property Tag As Object
Visual Basic (Usage)Copy Code
Dim instance As Cell
Dim value As Object
 
instance.Tag = value
 
value = instance.Tag
C# 
public object Tag {get; set;}

Property Value

Object containing the application tag

Remarks

The tag is only for the application's use; the spreadsheet does not use this information in working with the data. The information in the tag is stored separately from the information provided in the text or the value or the note.

You can assign user-defined information to any cell, column, row, sheet, or the entire component. The information in the tag is not composited from these different levels.

This property is available at run time only. (The Properties window uses a TypeConverter object to convert property values to and from strings for editing in the grid. The framework provides some converters for types defined in the framework, and there are converters for all of the intrinsic data types, except for Object. Since Object does not have a type converter, the Properties window is unable to edit values for properties of type Object, and these properties are displayed as read-only and are grayed out.)

Example

This example sets the Tag for the cell.
C#Copy Code
using FarPoint.Win.Spread;
using FarPoint.Win;

private void Form1_Load(object sender, System.EventArgs e)
{
     FarPoint.Win.Spread.Cell acell;
     acell = fpSpread1.ActiveSheet.Cells[0, 0];
     acell.Tag = "MyTag";
}
Visual BasicCopy Code
Imports FarPoint.Win.Spread
Imports FarPoint.Win

Private Sub cell_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
     Dim acell As FarPoint.Win.Spread.Cell
     acell = FpSpread1.ActiveSheet.Cells(0, 0)
     acell.Tag = "MyTag"
End Sub

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

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