isPaintSuspended Method

Gets or sets a property that indicates whether to refresh manually or automatically after changing Spread settings.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Sheet(name);
var returnValue; // Type: Object
returnValue = instance.isPaintSuspended(value);

function isPaintSuspended( 
   value : boolean
) : Object;

Parameters

value: Whether to refresh automatically.

Return Value

If you call this function without a parameter, it returns a boolean indicating whether to refresh automatically; otherwise, it returns the current Spread object.

Example

This example repaints a sheet.

Javascript

activeSheet.isPaintSuspended(true);
for(var i=0;i<100;i++){
activeSheet.setValue(i,0,"Row"+i);
}
activeSheet.isPaintSuspended(false);

Remarks

The default value is false.

If the sheet's parent (a Spread or Canvas) exists, the sheet inherits this setting from the parent.

Reference

Sheet type