How can I enable and disable ReDraw for large updates on WorkSheet or WorkBook

How can I enable and disable ReDraw for large updates on WorkSheet or WorkBook

Posted by: zion.siton on 11 December 2025, 7:42 am EST

• 

  zion.siton

  • Post Options:
  • Link
    Copy

  Posted 11 December 2025, 7:42 am EST

  How can I enable/disable redraw when I need to make large updates?

  I am migrating from the old C++ FarPoint grid that uses SS methods to the Spread.NET WPF version and cannot seem to find anyhting for enabling/disabling redraw. Can this be done using Spread.NET?

• 

  kartik.dua

  

  • Post Options:
  • Link
    Copy

  Posted 12 December 2025, 3:13 am EST

  Hi Zion,

  To suspend drawing of the GcSpreadSheet control (WPF) during large updates, you can use the BeginUpdate and EndUpdate methods of IWorkbookSet, as shown below:

  gcSpreadSheet.Workbook.WorkbookSet.BeginUpdate();
  
  /*do large updates here*/
  
  gcSpreadSheet.Workbook.WorkbookSet.EndUpdate();

  https://developer.mescius.com/spreadnet/api/latest/online-wpf/GrapeCity.Spreadsheet/GrapeCity.Spreadsheet.IWorkbookSet.html#methods

  Best Regards,
  
  Kartik