This article provides recommendations for optimizing forms that comply with legislation requirements, and other similar entities (such as reports or spreadsheet documents).
1. Optimize templates by avoiding a large number of columns or merged cells.
You can win a fraction of a second every time a user finishes editing a cell by simplifying a template. We recommend that you use custom column width in each row instead of cell merging (the users will not notice any difference).
2. Calculate the changes on the client-side. Only calculate cells that actually depend on the changed cell.
If your application makes a server call in order to update the form state when a user changes a cell value, this can impact the performance.
3. Do not update button states dynamically based on the currently selected spreadsheet document area.
Instead, make the action tied to a button available only in a specific document area. If you cannot explicitly specify the area, you can implement a user notification explaining why the action is not available.
4. If a server call is necessary, implement a single call.
This example includes two server calls, which is incorrect:
To correct this, you have to replace the two lines with a single server procedure call, which includes all of the server method calls.Next page: Page-by-page output to a spreadsheet document