Objects of this class cannot be instantiated directly. To create and associate an annotation with a cell, call the SetAnnotation method of the cell. Then, you can access the corresponding CellAnnotation object through the CellAnnotation property of the cell's Annotation.

The CellAnnotation class overrides the default values of some of the properties derived from InteractiveObject, as follows:

• Anchor = ToCell
• AnchorPosition = TopRight
• VerticalOffset = "-15pt"
• HorizontalOffset = "12pt"

In addition the CellAnnotation objects draw a black outline when LineColor is not set.

The following example illustrates how to set and customize a cell annotation.

C#  Copy Code
// Create the annotation var cell = worksheet.Cells["A1"]; cell.SetAnnotation("Test annotation"); // Customize the annotation's appearance cell.Annotation.CellAnnotation.BackColor = Color.LightSteelBlue;

Visual Basic  Copy Code
' Create the annotation Dim cell = worksheet.Cells("A1") cell.SetAnnotation("Test annotation") ' Customize the annotation's appearance cell.Annotation.CellAnnotation.BackColor = Color.LightSteelBlue

System.Object
    MindFusion.Spreadsheet.InteractiveObject
        MindFusion.Spreadsheet.CellAnnotation

CellAnnotation Members
MindFusion.Spreadsheet Namespace