SpreadJS 13
SpreadJS Documentation / Developer's Guide / Best Practices / suspendPaint and resumePaint
In This Topic
    suspendPaint and resumePaint
    In This Topic

    Each time a change is incorporated in the worksheet, SpreadJS automatically refreshes itself. When a user plans to integrate a lot of changes concurrently, it reduces the performance significantly because SpreadJS is painted repeatedly. Therefore, it is recommended to use the suspendPaint method and the resumePaint method.

    The suspendPaint method allows users to stop the repaint process while the modifications are being done. After integrating all the changes, users can invoke the resumePaint method. Both of these methods enhance the overall performance because Spread will now paint only once after all the changes have been done.

    Refer to the following code snippet in order to use the suspendPaint method and the resumePaint method.

    JavaScript
    Copy Code
    var spread = new GC.Spread.Sheets.Workbook(document.getElementById('ss'), { sheetCount: 1 });
    var sheet = spread.getSheet(0);
    spread.suspendPaint();
    spread.suspendEvent();
    sheet.setRowCount(10000);
    sheet.setColumnCount(100);
    for (var i = 0; i < 10000; i++)
    {
    for (var j = 0; j < 100; j++)
    {
    sheet.setValue(i, j, new Date(), GC.Spread.Sheets.SheetArea.viewport);
    sheet.getCell(i, j).formatter("yyyy/mm/dd");
    sheet.setColumnWidth(j, 80.0, GC.Spread.Sheets.SheetArea.viewport);
    }
    }
    spread.resumeEvent();
    spread.resumePaint();