clearRange

clears a range of cells (either selected cells or specified in the parameter)

Example

$$("ssheet").clearRange("B2:D2", {values:true, styles:true}, "Sheet1");

If the rangeStr parameter isn't set, the method will clear the selected range, if there is any.

The type object can have two attributes:

• values - (boolean) true by default, to clear cell values
• styles - (boolean) true by default, to clear cell styles
• conditions - (boolean) true by default, to clear conditional formatting
• editors - (boolean) true by default, to clear editors values
• comments - (boolean) true by default, to clear comments
• filters - (boolean) true by default, to clear filters