Class Cell

Inheritance
System.Object
Syncfusion.EJ2.EJTagHelper
Cell
Namespace: Syncfusion.EJ2.Spreadsheet
Assembly: Syncfusion.AspNetCore.Spreadsheet.dll
Syntax
public class Cell : EJTagHelper

Constructors

Cell()

Declaration
public Cell()

Properties

Chart

Specifies the chart of the cell.

Declaration
public List<Chart> Chart { get; set; }
Property Value
Type Description
System.Collections.Generic.List<Chart>

The default value is null

ColSpan

Specifies the column-wise cell merge count.

Declaration
public int ColSpan { get; set; }
Property Value
Type Description
System.Int32

The default value is 1

Comment

Represents the threaded comment associated with the cell. A threaded comment allows users to add a main comment and maintain a discussion through replies. Each cell supports a single comment thread, which includes:

  • author: The name of the person who created the comment.
  • text: The main content of the comment.
  • createdTime: The time-stamp indicating when the comment was added.
  • isResolved: Indicates whether the thread is marked as resolved.
  • replies: A collection of reply comments, each with its own author, text, and createdTime.
Declaration
public SpreadsheetThreadedComment Comment { get; set; }
Property Value
Type Description
SpreadsheetThreadedComment

The default value is null

Format

Specifies the number format code to display value in specified number format.

Declaration
public string Format { get; set; }
Property Value
Type Description
System.String

The default value is "General"

Formula

Defines the formula or expression of the cell.

Declaration
public string Formula { get; set; }
Property Value
Type Description
System.String

The default value is ""

Specifies the hyperlink of the cell.

Declaration
public object Hyperlink { get; set; }
Property Value
Type Description
System.Object

The default value is null

Image

Specifies the image of the cell.

Declaration
public List<Image> Image { get; set; }
Property Value
Type Description
System.Collections.Generic.List<Image>

The default value is null

Index

Specifies the index of the cell.

Declaration
public int Index { get; set; }
Property Value
Type Description
System.Int32

The default value is 0

IsLocked

Specifies the cell is locked or not, for allow edit range in spreadsheet protect option.

Declaration
public bool IsLocked { get; set; }
Property Value
Type Description
System.Boolean

The default value is true

IsReadOnly

Represents whether a cell in the sheet is read-only or not. If set to true, it prevents editing the specified cell in the sheet.

Declaration
public bool IsReadOnly { get; set; }
Property Value
Type Description
System.Boolean

The default value is false

Notes

Specifies the note of the cell.

Declaration
public object Notes { get; set; }
Property Value
Type Description
System.Object

The default value is null

RichText

Specifies the rich text segments for the cell text, allowing superscript and subscript formatting within the content. Uses the RichText model to apply formatting to specific text segments. The options are:

  • text: Specifies the text content for each segment.
  • style: Specifies the style for each segment; it supports superscript and subscript formatting. Set verticalAlign as super for superscript formatting and sub for subscript formatting.
Declaration
public List<RichText> RichText { get; set; }
Property Value
Type Description
System.Collections.Generic.List<RichText>

The default value is null

RowSpan

Specifies the row-wise cell merge count.

Declaration
public int RowSpan { get; set; }
Property Value
Type Description
System.Int32

The default value is 1

Style

Specifies the cell style options.

Declaration
public SpreadsheetCellStyle Style { get; set; }
Property Value
Type Description
SpreadsheetCellStyle

The default value is null

Validation

Specifies the validation of the cell.

Declaration
public SpreadsheetValidation Validation { get; set; }
Property Value
Type Description
SpreadsheetValidation

The default value is null

Value

Defines the value of the cell which can be text or number.

Declaration
public string Value { get; set; }
Property Value
Type Description
System.String

The default value is ""

Wrap

Wraps the cell text to the next line, if the text width exceeds the column width.

Declaration
public bool Wrap { get; set; }
Property Value
Type Description
System.Boolean

The default value is false