conditions

a module for working with conditions

object conditions;

Example

$$("ss").conditions.parse([
  [3, 3, "greater", 5000, "webix_ssheet_condition_good"],
  [3, 3, "lessOrEqual", 5000, "webix_ssheet_condition_bad"],
  [4, 4, "less", 100, "webix_ssheet_condition_bad"]
]);

Related samples

Details

The module has several methods to work with conditions:

  • handlers() - returns all the conditions
  • add() - adds conditional formatting for a specified cell. Accepts the following parameters:
    • row (number) - row ID
    • col (number) - col ID
    • rule (string) - conditional rule
    • value (value) - value to compare with
    • css (string) - CSS class name to apply
    • page (string) - optional, the name of the sheet. If not specified, the method is applied to the current sheet
  • clear() - clears all the conditional formatting from the current sheet. Accepts the following parameter:
    • page (string) - optional, the name of the sheet. If not specified, the method is applied to the current sheet
  • get() - returns an array of all the conditional formattings of a specified cell. Accepts the following parameters:
    • row (number) - row ID
    • col (number) - col ID
    • page (string) - optional, the name of the sheet. If not specified, the method is applied to the current sheet
  • parse() - parses conditional formattings in the current sheet. Accepts the following parameters:
    • data (array) - conditional formatting data where each element is an array like this [rowID, colID, rule, value, css]
    • page (string) - optional, the name of the sheet. If not specified, the method is applied to the current sheet
  • remove() - removes conditional formatting from a specified cell. Accepts the following parameters:
    • row (number) - row ID
    • col (number) - col ID
    • page (string) - optional, the name of the sheet. If not specified, the method is applied to the current sheet
  • serialize() - returns a 2D array analogous to the one described in the parse() method. Accepts the following parameter:
    • page (string) - optional, the name of the sheet. If not specified, the method is applied to the current sheet
  • update() - updates conditional formatting of a specified cell. Accepts the following parameters:
    • row (number) - row ID
    • col (number) - col ID
    • newData (array) - 2D array like this [rule, value, css]
    • page (string) - optional, the name of the sheet. If not specified, the method is applied to the current sheet
See also
Back to top