CellDirective

12 Sep 20251 minute 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

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 ’’

hyperlink any

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