setStyle()

Description

Sets style to a cell(s)

info

The method sets the same style for the specified cells. If you want to apply different styles to spreadsheet cells, use the parse() method.

Usage

setStyle(cell: string, styles: array | object): void;

Parameters

• cell - (required) the id(s) of a cell(s) or a range of cells
• styles - (required) the styles to apply to cells. Check the list of properties that you can use to style cells

Example

const spreadsheet = new dhx.Spreadsheet("spreadsheet", {});
spreadsheet.parse(data);

// setting style for one cell
spreadsheet.setStyle("A1", {background: "red"});

// setting the same style for a range of cells
spreadsheet.setStyle("A1:D1", {color: "blue"});

// setting the same style for different cells
spreadsheet.setStyle("B6,A1:D1", {color:"blue"});

// setting styles from an array for cells in a range alternately
spreadsheet.setStyle("A1:D1", [{color: "blue"}, {color: "red"}]);

Related sample: Spreadsheet. Styled Data

info

Starting with v4.1, the reference to a cell or range of cells can be specified in the following format:

spreadsheet.setStyle("sheet1!A2", {background: "red"}); 

where sheet1 is the name of the tab.

If the name of the tab isn't specified, the method applies the style to the cell(s) of the active tab.