# Enabling AJAX Support

Learn how you can enable the AJAX support to allow the component to refresh without refreshing the entire page.

## Content

AJAX allows the component to refresh without refreshing the entire page. You can add AJAX support to the FpSpread component by setting the [EnableAjaxCall](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.FpSpread.EnableAjaxCall.html) property. Setting this property to True prevents Spread from doing a full page postback when implementing the following features - expanding and collapsing child sheets in a hierarchical display, column sorting, inserting rows, or paging.
If the [ClientAutoCalculation](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.FpSpread.ClientAutoCalculation.html) property is true, then after a cell value is changed, an AJAX call is made to the FpSpread component. Then the component calculates the formulas and sends the values to the client side. The component then updates the values at the client side.
Use the [EnableAjaxCall](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.FpSpread.EnableAjaxCall.html) property to enable AJAX support or use EnableAjaxCall and the [ClientAutoCalculation](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.FpSpread.ClientAutoCalculation.html) properties to enable AJAX support of formulas.

## Using Code

You can set the [EnableAjaxCall](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.FpSpread.EnableAjaxCall.html) property and the [ClientAutoCalculation](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.FpSpread.ClientAutoCalculation.html) property in code.

## Example

The following code allows AJAX support and AJAX support of formulas.

```csharp
FpSpread1.EnableAjaxCall = true;
FpSpread1.ClientAutoCalculation = true;
```

```vbnet
FpSpread1.EnableAjaxCall = True
FpSpread1.ClientAutoCalculation = True<
```

## Using the Spread Designer

1. Select the **Settings** menu.
2. Select the **General** icon under the **Spread Settings** section.
3. Select the **General** tab and check the **Enable AJAX Call** box.
4. Select the **Edit** tab in order to set the **Client Auto Calculation** check box.
5. Click **OK**.
6. Click **Apply and Exit** to close the Spread Designer.