SpreadsheetControl.BeginUpdate() Method

Locks the SpreadsheetControl to prevent its visual updates until the SpreadsheetControl.EndUpdate method is called.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v18.2.dll

Declaration

C#

public void BeginUpdate()

VB.NET

Public Sub BeginUpdate

Remarks

Enclose your code in the BeginUpdate - SpreadsheetControl.EndUpdate method calls to suppress the SpreadsheetControl’s visual updates and improve its performance when you perform multiple changes to a spreadsheet document.

Each call to BeginUpdate must be paired with the SpreadsheetControl.EndUpdate call. The BeginUpdate method locks the SpreadsheetControl, so that it is not rendered after each modification. The SpreadsheetControl.EndUpdate method unlocks the control to enable all the changes to take effect. You can use the try…finally statement to ensure that SpreadsheetControl.EndUpdate is always called even if an exception occurs.

The following example shows how to use the BeginUpdate - SpreadsheetControl.EndUpdate methods.

C#

spreadsheetControl1.BeginUpdate();
try
{
    Worksheet worksheet = spreadsheetControl1.Document.Worksheets[0];
    spreadsheetControl1.Unit = DevExpress.Office.DocumentUnit.Point;

    // Create a multiplication table.
    worksheet.Cells["A1"].Value = "*";
    for(int i = 1; i < 11; i++)
    {
        // Create a header column.
        worksheet.Columns["A"][i].Value = i;
        // Create a header row.
        worksheet.Rows["1"][i].Value = i;
    }

    // Multiply values of header cells.
    worksheet.Range["B2:K11"].Formula = "=B$1*$A2";

    // Obtain the data range.
    Range tableRange = worksheet.GetDataRange();

    // Specify the row height and column width.
    tableRange.RowHeight = 40;
    tableRange.ColumnWidth = 40;

    // Align the table content.
    tableRange.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;
    tableRange.Alignment.Vertical = SpreadsheetVerticalAlignment.Center;

    // Fill the header cells.
    Range headerCells = worksheet.Range.Union(worksheet.Range["A1:K1"], worksheet.Range["A2:A11"]);
    headerCells.FillColor = Color.FromArgb(0xf7, 0x9b, 0x77);
    headerCells.Font.Bold = true;

    // Fill cells that contain multiplication results.
    worksheet.Range["B2:K11"].FillColor = Color.FromArgb(0xfe, 0xf2, 0xe4);
}
finally
{
    spreadsheetControl1.EndUpdate();
}

VB.NET

spreadsheetControl1.BeginUpdate()
Try
  Dim worksheet As Worksheet = spreadsheetControl1.Document.Worksheets(0)
  spreadsheetControl1.Unit = DevExpress.Office.DocumentUnit.Point

    ' Create a multiplication table.
    worksheet.Cells("A1").Value = "*"
    For i As Integer = 1 To 10
        ' Create a header column.
        worksheet.Columns("A")(i).Value = i
        ' Create a header row.
        worksheet.Rows("1")(i).Value = i
    Next i

    ' Multiply values of header cells.
    worksheet.Range("B2:K11").Formula = "=B$1*$A2"

    ' Obtain the data range.
    Dim tableRange As Range = worksheet.GetDataRange()

    ' Specify the row height and column width.
    tableRange.RowHeight = 40
    tableRange.ColumnWidth = 40

    ' Align the table content.
    tableRange.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center
    tableRange.Alignment.Vertical = SpreadsheetVerticalAlignment.Center

    ' Fill the header cells.
    Dim headerCells As Range = worksheet.Range.Union(worksheet.Range("A1:K1"), worksheet.Range("A2:A11"))
    headerCells.FillColor = Color.FromArgb(&Hf7, &H9b, &H77)
    headerCells.Font.Bold = True

    ' Fill cells that contain multiplication results.
    worksheet.Range("B2:K11").FillColor = Color.FromArgb(&Hfe, &Hf2, &He4)
Finally
    spreadsheetControl1.EndUpdate()
End Try

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the BeginUpdate() method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-format-tables-e4909/CS/TableBuiltInStyleExample/Form1.cs#L103

DataTable sourceTable = CreateDataTable();
spreadsheetControl1.BeginUpdate();
for (int j = 0; j < sourceTable.Columns.Count; j++) {

how-to-implement-a-service-to-manage-the-process-of-worksheet-cell-calculation-t270403/CS/CustomCalculationServiceExample/Form1.cs#L23

InitializeComponent();
spreadsheetControl1.BeginUpdate();
spreadsheetControl1.Document.DocumentSettings.Calculation.Iterative = true;

how-to-import-data-from-a-datatable-instance-into-a-spreadsheetcontrol-e4776/CS/Form1.cs#L26

spreadsheetControl1.BeginUpdate();
activeWorksheet.Import(ManualDataSet.CreateData().Tables[0], true, selection.TopRowIndex, selection.LeftColumnIndex);

winforms-spreadsheet-pivot-table-api-t298650/CS/SpreadsheetPivotTableExamples/Form1.cs#L110

{
    spreadsheet.BeginUpdate();
    codeEditor.BeforeCompile();

how-to-use-custom-cell-editors-to-create-a-data-entry-form-t419595/CS/DevAVInvoicing/Form1.cs#L180

void AddRecord(Worksheet sheet) {
    spreadsheetControl1.BeginUpdate();
    try {

VB.NET

how-to-format-tables-e4909/VB/TableBuiltInStyleExample/Form1.vb#L102

Dim sourceTable As DataTable = CreateDataTable()
spreadsheetControl1.BeginUpdate()
For j As Integer = 0 To sourceTable.Columns.Count - 1

how-to-implement-a-service-to-manage-the-process-of-worksheet-cell-calculation-t270403/VB/CustomCalculationServiceExample/Form1.vb#L22

InitializeComponent()
spreadsheetControl1.BeginUpdate()
spreadsheetControl1.Document.DocumentSettings.Calculation.Iterative = True

how-to-import-data-from-a-datatable-instance-into-a-spreadsheetcontrol-e4776/VB/Form1.vb#L29

spreadsheetControl1.BeginUpdate()
activeWorksheet.Import(ManualDataSet.CreateData().Tables(0), True, selection.TopRowIndex, selection.LeftColumnIndex)

winforms-spreadsheet-pivot-table-api-t298650/VB/SpreadsheetPivotTableExamples/Form1.vb#L105

Private Sub evaluator_OnBeforeCompile(ByVal sender As Object, ByVal e As EventArgs)
    spreadsheet.BeginUpdate()
    codeEditor.BeforeCompile()

how-to-use-custom-cell-editors-to-create-a-data-entry-form-t419595/VB/DevAVInvoicing/Form1.vb#L186

Private Sub AddRecord(ByVal sheet As Worksheet)
    spreadsheetControl1.BeginUpdate()
    Try