Microsoft Technology Licensing, LLC

Rishabh Tandon

Robert G Hawking

Johnny S Campbell

Joseph M Chirilov

Michael J Smith

Michael Hopkins Smith

Robert Archer

Robert L Archer

Michael H Smith

Techniques for performing a process during a real time collaboration by multiple users or clients on a spreadsheet file are disclosed herein which may permit calculations to be performed locally by at least one of the clients. By doing so, increases in performance are realized since only data updates need to be provided to the host machine. As such, a determination is preferably made whether calculations performed locally can result in different data. If conflicting data is a possibility, then the calculations for the spreadsheet file will usually be performed remotely by a host machine. If not, then each client capable of doing so will perform the calculations locally and then provide only the updated data to the host machine. The determination of whether to perform the calculations locally or not may also be made dynamically, such as when one or more new formulas are added to the spreadsheet file.

Private views of data and local calculations during real time collaboration

Techniques for collaborating on a spreadsheet file by client computers in real time are disclosed herein. In particular, a revision manager module is preferably provided with a host machine which receives updates from the client computers, processes such updates, and then applies them to the spreadsheet file. Additionally, a technique is described for handling updates sent to the revision manager by clients simultaneously or near simultaneously. In this case, the revision manager determines whether the updates to the spreadsheet file are transformable or able to be merged. If so, the updates are combined into the spreadsheet file and applied thereto. If the updates are not transformable, the revision manager confirms that all clients have received all previous updates before applying the non-transformable update to the spreadsheet file.

Spreadsheet collaboration between rich and browser clients

Growing community of inventors

Sammamish, WA, United States of America

Rishabh Tandon