CellDirective

16 Dec 20252 minutes to read

e-cell directive represent a cell of the Angular Spreadsheet.
It must be contained in a e-row directive.

<ejs-spreadsheet>
  <e-sheets>
   <e-sheet>
   <e-rows>
   <e-row>
   <e-cells>
   <e-cell value='A1'></e-cell>
   </e-cells>
   </e-row>
   </e-rows>
   </e-sheet>
  </e-sheets>
</ejs-spreadsheet>

Properties

chart any

Specifies the chart of the cell.

Defaults to []

colSpan any

Specifies the column-wise cell merge count.

Defaults to 1

comment any

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

Defaults to null

format any

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

Defaults to ‘General’

formula any

Defines the formula or expression of the cell.

Defaults to ’’

Specifies the hyperlink of the cell.

Defaults to ’’

image any

Specifies the image of the cell.

Defaults to []

index any

Specifies the index of the cell.

Defaults to 0

isLocked any

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

Defaults to true

isReadOnly any

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.

Defaults to false

notes any

Specifies the note of the cell.

Defaults to ’’

rowSpan any

Specifies the row-wise cell merge count.

Defaults to 1

style any

Specifies the cell style options.

Defaults to {}

validation any

Specifies the validation of the cell.

Defaults to ’’

value any

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

Defaults to ’’

wrap any

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

Defaults to false