ClearValueUndoAction Constructor

SpreadJS Documentation

Collapse All

GcSpread.Sheets.UndoRedo Namespace > ClearValueUndoAction type : ClearValueUndoAction Constructor

The sheet on which to clear values.

The clear value cell ranges whose item type is GcSpread.Sheets.Range.

Represents a clear cells value undo action on the sheet.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.UndoRedo.ClearValueUndoAction(sheet, ranges);

function ClearValueUndoAction( 
   sheet : Sheet,
   ranges : Array
) : ClearValueUndoAction;

Parameters

sheet: The sheet on which to clear values.
ranges: The clear value cell ranges whose item type is GcSpread.Sheets.Range.

Example

This example clears a value.

Javascript

//Add data
for (var col = 1; col < 6; col++) {
    for (var row = 2; row < 11; row++) {
        activeSheet.setValue(row, col, row + col);
    }
}

$("#button1").click(function () {
spread.allowUndo(true);
var srange = [new GcSpread.Sheets.Range(10, 5, 1, 1)];
var action = new GcSpread.Sheets.UndoRedo.ClearValueUndoAction(activeSheet, srange);
activeSheet.doCommand(action);
    });

<input type="button" id="button1" value="button1"/>

Reference

ClearValueUndoAction type

Send comments on this topic.