Search results

CellDirective API in Angular Spreadsheet API component

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

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

Specifies the hyperlink 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

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