Widgets Samples Demos Forum Services
Documentation
StartAPI Referenceui.spreadsheetMethods

clearRange

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

void clearRange( [string rangeStr,object type,string page] );
rangeStr
stringoptional, the range of cells (or multiple ranges) type
objectoptional, defines clearing options (see details) page
stringoptional, 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:

See also
  • API
    • Back to top
    Join Our Forum
    We've retired comments here. Visit our forum for faster technical support, connect with other developers, and share your feedback there.
    If you have not checked yet, be sure to visit site of our main product Webix ui widget library and page of spreadsheet javascript library product.
    © XB Software Ltd
    2013-2026