Spread ASP.NET 14
Spread for ASP.NET 14 Product Documentation / Developer's Guide / Managing Formulas / Recalculating and Updating Formulas Automatically
In This Topic
    Recalculating and Updating Formulas Automatically
    In This Topic

    By default, the spreadsheet recalculates formulas in the spreadsheet when the contents of dependent cells change. You can turn this recalculation off.

    Also by default, the spreadsheet updates formulas when you insert or delete columns or rows or when you move or swap blocks of cells. You can turn off these automatic formula updates. However, generally, you probably want the spreadsheet to update formulas when you insert or delete columns or rows or when you move or swap blocks of cells. Keep in mind how turning off automatic formula updating might impact the spreadsheet if the user moves data, adds rows or columns, or performs other actions that affect the location of data.

    When automatic formula updating is on, the spreadsheet updates absolute and relative cell references, as follows:

    Use the AutoCalculation property to turn on or off the automatic recalculation of formulas. Use the Recalculate and RecalculateAll methods for recalculating formulas.

    The ClientAutoCalculation property is used for automatic calculation of client-side data. The formula updates when the cell goes out of edit mode instead of waiting until the user clicks on the save changes icon. ClientAutoCalculation will have no effect on a hierarchy. You can set either AutoCalculation or ClientAutoCalculation or both properties at the same time.

    For more information about formulas, refer to the Formula Reference.

    Using a Shortcut

    Set the AutoCalculation property and the ClientAutoCalculation property.

    Example

    This example sets the AutoCalculation and ClientAutoCalculation properties.

    C#
    Copy Code
    FpSpread1.Sheets[0].AutoCalculation = true;
    FpSpread1.ClientAutoCalculation = true;
    
    VB
    Copy Code
    FpSpread1.Sheets(0).AutoCalculation = True
    FpSpread1.ClientAutoCalculation = True
    

    Using the Spread Designer

    1. Select the Settings menu.
    2. Select the Calculation icon under the Sheet Settings section.
    3. Check the Automatic Calculation check box.
    4. Select the Edit icon under Spread Settings to set Client Auto Calculation.
    5. Select OK to close the dialog.
    6. Click Apply and Exit to close the Spread Designer.