Scope: managed applications.
1.1. If the form state needs to be recalculated once the cell value is changed by users (set values of adjacent dependent cells, set controls availability, and other), avoid server calls. Make all recalculations on the client instead. Context server calls for forms with spreadsheet documents can negatively affect user operations in the form.
Make sure the client update logic is optimized and quickly processes data. In particular:
1.3. Avoid using a large number of columns and merges in spreadsheet document layouts. We recommend that you use columns of variable width for different rows. The document appearance remains unchanged for the user.
This way you can reduce form opening time and timeout when users perform actions, which require context server calls.
2. In Microsoft Internet Explorer 6.0 and 7 web browsers, display of merged cells with added left border and missing bottom border is not supported for spreadsheet documents. We recommend that you add a bottom border for such cells.
3. In web client, if right alignment is set for a spreadsheet document cell and the cell does not fit the text, the visible text part is left aligned and the text is cut. If partial cell content display makes no sense (for example, numeric fields), set the Location property to Swamp in the cell. If the cut value makes sense (for example, string names), set the value to Cut.