Tag Property (Cell)

Visual Basic
C#

'Declaration
 
Public Property Tag As Object

'Usage
 
Dim instance As Cell
Dim value As Object
 
instance.Tag = value
 
value = instance.Tag

public object Tag {get; set;}

Property Value

Object containing the application tag

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.)

This example sets the Tag for the cell.

C#

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 Basic

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

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

Cell Class
Cell Members
GetTag Method
SetTag Method

User-Task Documentation

Adding a Tag to a Cell