Abstract: Variable formatting for cells in computer spreadsheets, tables, and other documents is provided. For a selected range of cells, cell formats vary with the value in each cell (or an associated value). Formats can include color-scale backgrounds, in-cell elements (e.g., icons and data bars), and other cell formats that can be varied with a value.

Abstract: Embodiments of the invention involve a method of concurrent processing of chain calculations using multiple processors each having a separate recalculation engine in a spreadsheet program. The operations basically include first determining a number of available processors, then allocating a recalculation engine to each available processor, distributing the formulas between the recalculation engines, and then concurrently evaluating the formulas distributed to each recalculation engine when a recalc operation is called for in the spreadsheet program.

Abstract: The present invention is provides a system and method for interacting with data from a collaboration system over a network. Collaboration data is obtained from the collaboration system and stored locally at the client. Operations such as sorting and filtering may be completed by the local client without any interaction from the collaboration server. When an operation such as adding, changing, and deleting data is performed the collaboration server is contacted to determine whether or not the change is valid. Changes made to the local data automatically update the data at the collaboration server. List controls are added to the browser user interface that are similar to a spreadsheet, such as MS Excel, which enables a user to view, add, change, or delete information corresponding to the data stored by the collaboration system in a manner in which they are familiar.