Cell

Represents the interface of a Spreadsheet cell.

NameTypeDefaultDescription

background?

string

The background CSS color of the cell.

bold?

boolean

If set to true, sets the cell font to bold.

borderBottom?

CellBorder

The style information for the bottom border of the cell.

borderLeft?

CellBorder

The style information for the left border of the cell.

borderRight?

CellBorder

The style information for the right border of the cell.

borderTop?

CellBorder

The style information for the top border of the cell.

color?

string

The text CSS color of the cell.

enable?

boolean

If set to false, disables the cell.

fontFamily?

string

The font family of the cell.

fontSize?

number

The font size of the cell in pixels.

format?

string

The format of the cell text. For more information, refer to the article on creating or deleting a custom number format on MS Office.

formula?

string

The cell formula without the leading equals sign, for example, A1 * 10.

html?

boolean

If set to true, renders the cell value as HTML. It is important to sanitize the value of the cell on the server for passing safe html because there is no client-side sanitizing. When editing a cell the new value can be checked and prevented in the client changing event.

index?

number

The zero-based index of the cell. Required to ensure correct positioning.

italic?

boolean

If set to true, sets the cell font to italic.

string

The hyperlink (URL) of the cell.

textAlign?

string

The text-align setting for the cell content.

The available options are: left, center, right or justify.

underline?

boolean

If set to true, sets the cell font to underline.

value?

string | number | boolean | Date

The cell value.

verticalAlign?

string

The vertical align setting for the cell content.

The available options are: top, center or bottom.

wrap?

boolean

If set to true, sets the cell wrap.