changeDecimals

increases/decreases decimal places

void changeDecimals(number row,number column,number change);
rownumberthe row ID
columnnumberthe column ID
changenumberthe number of decimal places to be added (if the number is positive) or deleted (if the number is negative)

Example

// add 3 decimal places for the value of the cell C3
$$("ss1").changeDecimals(3,3,3);

Details

The method also works for a range of cells. Use the parameters below:

  • first - (object) the row and column numbers of the first cell in a range
  • last - (object) the row and column numbers of the last cell in a range
  • change - (number) the number of decimal places to be added (if the number is positive) or deleted (if the number is negative)
// delete 2 decimal places for values of cells in the range C3:E5
$$("ss1").changeDecimals({row:3, column:3}, {row:5, column:5}, -2);
See also
Back to top