clearRange

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

void clearRange( [string rangeStr,object type,string page] );

rangeStr	string	optional, the range of cells (or multiple ranges)
type	object	optional, defines clearing options (see details)
page	string	optional, the name of the sheet

Example

// clears a single range of cells
$$("ssheet").clearRange("B2:D2", {values:true, styles:true}, "Sheet1");
 
// clears multiple ranges of cells
$$("ssheet").clearRange("C3:E3;C5:E5;C7:E7");

Details

The rangeStr parameter accepts multiple ranges with a semicolon as delimiter: "A1:C3;B4:D5".

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

The type object can have the following 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