increases/decreases decimal places
row | number | the row ID |
column | number | the column ID |
change | number | the number of decimal places to be added (if the number is positive) or deleted (if the number is negative) |
page | string | optional, the name of the sheet |
// add 3 decimal places for the value of the cell C3 of Sheet1
$$("ss1").changeDecimals(3, 3, 3, "Sheet1");
The method also works for a range of cells. Use the parameters below:
// delete 2 decimal places for values of cells in the range C3:E5 of Sheet1
$$("ss1").changeDecimals({row:3, column:3}, {row:5, column:5}, -2, "Sheet1");