AJAX allows the component to refresh without refreshing the entire page. You can add AJAX support to the FpSpread component by setting the EnableAjaxCall 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 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 property to enable AJAX support or use EnableAjaxCall and the ClientAutoCalculation properties to enable AJAX support of formulas.

Using Code

You can set the EnableAjaxCall property and the ClientAutoCalculation property in code.

Example

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

C#	Copy Code
FpSpread1.EnableAjaxCall = true; FpSpread1.ClientAutoCalculation = true;

VB	Copy Code
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.