Xceed Logo
Shop
Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / Note Class
Example


In This Topic
    Note Class
    In This Topic
    Represents a Note, which is made of multiple blocks of FormattedText that are added one after the other.
    Object Model
    Note ClassFormattedText Class
    Syntax
    'Declaration
 

    <DefaultMemberAttribute("Item")>
Public Class Note 
   Inherits Annotation
    'Usage
 

    Dim instance As Note
    [DefaultMember("Item")]
public class Note : Annotation
    Remarks
    Note that line breaks are supported in a Note.
    Example
    using( var workbook = Workbook.Create( "AddNote.xlsx" ) ) 
  { 
    // Gets the first Worksheet; a Workbook always contains at least 1 Worksheet. 
    var worksheet = workbook.Worksheets[ 0 ]; 

    // Gets the annotations collection. 
    var annotations = worksheet.Annotations; 

    // Adds a Note in Cell B1 with the name of the person who wrote it. 
    var note = annotations.AddNote( new FormattedText( "This is the title of the document" ), "B1" ); 
    note.BackgroundColor = Color.Gray; 
    note.IsShown = true; 

    // Saves Workbook to disk; 
    workbook.Save(); 
  }
    Inheritance Hierarchy

    System.Object
       Xceed.Workbooks.NET.WorkbookElement
          Xceed.Workbooks.NET.WorksheetElement
             Xceed.Workbooks.NET.Annotation
                Xceed.Workbooks.NET.Note

    Public Properties
     NameDescription
    Public PropertyAnnotationTypeOverridden. Gets the AnnotationType.  
    Public PropertyAuthorObject that represents the person who wrote the Note or the Comment. (Inherited from Xceed.Workbooks.NET.Annotation)
    Public PropertyBackgroundColorGets or sets the color used for the Note's background.  
    Public PropertyCellReferenceRepresents the Cell in which the Note or the Comment is inserted. (Inherited from Xceed.Workbooks.NET.Annotation)
    Public PropertyHeightGets or sets the Note's height.  
    Public PropertyIsAutoFitGets or sets if the Note uses the AutoFit option.  
    Public PropertyIsShownIndicates if the Annotation is visible or not when the Workbook is opened. (Inherited from Xceed.Workbooks.NET.Annotation)
    Public PropertyItemGets a specific block of FormattedText contained in the Note.  
    Public PropertyLengthRepresents the cumulative length of all the blocks of FormattedText in the current Note.  
    Public PropertyMeasureUnitGets or sets the Unit used to define Width & Height.  
    Public PropertyProtectionGets or sets the NoteProtection.  
    Public PropertyTextAlignmentRepresents the Note's HorizontalAlignement and VerticalAlignment.    
    Public PropertyWidthGets or sets the Note's width.  
    Top
    Public Methods
     NameDescription
    Public MethodAddTextAdds a new FormattedText object at the end of the Note's current FormattedTextList.  
    Public MethodAddTextsAdds multiple FormattedText objects at the end of the Note's current FormattedTextList.  
    Public MethodGetEnumerator  
    Public MethodGetTypeCode  
    Public MethodToBoolean  
    Public MethodToByte  
    Public MethodToChar  
    Public MethodToDateTime  
    Public MethodToDecimal  
    Public MethodToDouble  
    Public MethodToInt16  
    Public MethodToInt32  
    Public MethodToInt64  
    Public MethodToSByte  
    Public MethodToSingle  
    Public MethodToStringOverloaded.   
    Public MethodToType  
    Public MethodToUInt16  
    Public MethodToUInt32  
    Public MethodToUInt64  
    Top
    Protected Methods
     NameDescription
    Protected Internal MethodIsDirtyOverridden.   
    Protected MethodOnPropertyChanged (Inherited from Xceed.Workbooks.NET.Annotation)
    Protected Internal MethodSetIsDirtyOverridden.   
    Top
    Supported Frameworks

    .NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.

    .NET Framework: net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.

    See Also

    Reference

    Note Members
    Xceed.Workbooks.NET Namespace

    Send Feedback