Integrating AJAX into your next application may solve many problems and give your users the interactivity and speed they are beginning to expect when looking for information on the Web. The use of AJAX in a Web Forms application provides many benefits and improvements. FarPoint recommends understanding AJAX before using it in any application development, especially in spreadsheet application development which has its own unique requirements.
FarPoint has developed leadership in the spreadsheet component marketplace with FarPoint Spread for Web Forms which is the high-end spreadsheet product for ASP.NET development. It is AJAX enabled and ATLAS tested. But they also offer a complete enterprise solution with FarPoint Spread .NET bundle which includes the Web Forms version along with a FarPoint Spread for Windows Forms version. Download the trials now to see how customizable a spreadsheet can be. FarPoint also makes a COM version of the spreadsheet control.
As developers begin to realize the diverse ways in which Web technologies can be used for ever more data intensive front ends and applications, technologies such as AJAX will become more prevalent. Integrating AJAX into your next application may solve many problems and give your users the interactivity and speed they are beginning to expect when looking for information on the Web. The use of AJAX in a Web Forms application provides many benefits and improvements. There are also limitations to its use and not all applications benefit from it. FarPoint recommends understanding AJAX before using it in any application development, especially in spreadsheet application development which has its own unique requirements.
AJAX Improves Web Interaction
To see just how responsive Web pages can be using AJAX, you need look no further than Google Maps, and other sites that offer lots of data that can be manipulated with ease through an ordinary Web browser, such as having your text completed while typing here.
Using AJAX and Spread
Spreadsheet applications can be some of the most data intensive applications with which to work. They can work on large data sets and require many calculations. With components such as Spread for Web Forms, spreadsheet applications can bind to databases with millions of cells of data that must be made available to end users. For a Web application, traditional ways of serving up pages can impose severe restrictions on a spreadsheet application's performance when it is bound to a large data set. Paging or moving around the sheet by the end user can demand system resource typically easily available to Windows applications but limiting Web applications. But with AJAX, those restrictions can be largely hidden from the end user as AJAX can send back to the server only those cells that have changed and updating only those calculations that need recalculating. For paging, only those rows that are displayed need to be fetched from the server.
FarPoint introduced support for AJAX in its latest version of FarPoint Spread for Web Forms. With simple Boolean properties on the FpSpread component class, Spread for Web Forms can be made aware that the application is using AJAX. See the product tour at our web site or available with the product download. The example from that product tour, with a custom toolbar to allow user interactivity, is briefly described here to show how AJAX can improve a spreadsheet application.
Here the user can format the text in an ordinary text cell and see the results immediately. Also, the sum of the numbered cells can be calculated when any of the individual numbers change without having to get the entire sheet from the server.
EnableAjaxCall property of the FpSpread component affects several aspects of the operation of the spreadsheet that makes it more responsive. Built-in functions are enabled that allow for client-side operations such as expanding and collapsing child sheets in a hierarchical display, sorting columns, inserting rows, searching, and filtering. There are also ones for paging, tabbing, and other navigational aids in Spread. These are the most common uses for AJAX in Spread. By using AJAX for expanding a hierarchical display, for example, only the child sheet is needed and retrieved from the server; a full postback of the entire hierarchy is not needed. You do not have to have this property set to True to programmatically call back to Spread through AJAX, but it does enable some of the built-in functionality of Spread.
Keeping Expectations Realistic
FarPoint Spread for Web Forms has an object-oriented design and underlying models to facilitate speedy, flexible, and scalable development. But AJAX will not solve all types of problems with performance issues on the client side. For example, applications with hundreds of client-side calculations may not save an appreciable amount of time with AJAX since the calculations in all these cells would still require recalculation when the data changes. With so many calculations, the client side would get bogged down and this would be better handled on the server where calculations can be performed faster with more processor bandwidth.
Also, you would have to handle anything outside of the spreadsheet on the form separately. For example, if you had a message box on the form but outside of Spread that required updating when the spreadsheet changed, client-side code would have to be written to handle that and AJAX would not help in that case. Remember also that if an AJAX callback is made, the Control
OnLoad method is not called, as it would with a normal full postback. If you need it to fire, then you would need to make code that calls it and put that code in the
onCallBackStopped event so that it can be run.
With Spread for Web Forms and AJAX, you can improve a data-intensive application. Once you have the right tools, you will be able to develop applications that may surprise even you.
Finding More Information
FarPoint Spread for Web Forms supports Microsoft Visual Studio .NET 2005. Spread is also available as a Windows Forms component and as a COM control. All versions are runtime royalty free. For more information, see our Web site.
You can easily download a free trial evaluation from the FarPoint website and see for yourself how easy it is to develop an application with spreadsheet capabilities.
Bill Albing creates technical documentation with as much automation and content management as possible and is a proponent of XML and structured authoring. With over 15 years experience, he is presently employed at FarPoint Technologies where he creates user-centered and API reference documentation for software products.