Resolving mutations in a partially-loaded spreadsheet model

A system for resolving mutations in a partially-loaded spreadsheet model, the system comprising:

• a client computer, wherein the client computer is configured to:
• communicate with a server using a communication connection;
• load a first chunk of a spreadsheet stored on the server, wherein the first chunk represents a first range of cells in the spreadsheet;
• request a second chunk of the spreadsheet from the server, wherein the second chunk represents a second range of cells in the spreadsheet;
• store a plurality of pending user mutations generated by a user on the client computer in a pending queue, wherein the plurality of pending user mutations are applied to the first chunk, wherein each mutation in the plurality of mutations in the pending queue is labeled in a label as an unsent mutation;
• periodically send, the plurality of pending user mutations from the client computer to the server to be applied to the spreadsheet and after sending the plurality of mutations to the server, changing the label of each mutation in the plurality of mutations from the unsent mutations to a sent mutation;
• receive at the client computer, from the server, an acknowledgement after the plurality of pending user mutations are applied to the spreadsheet;
• delete the plurality of pending user mutations from the pending queue after the client computer receives the acknowledgement from the server;
• receive from the server a plurality of collaborator mutations;
• receive from the server the second chunk;
• transform the plurality of pending user mutations against the plurality of collaborator mutations;
• and
• apply the transformed plurality of pending user mutations to the second chunk.

A method for resolving mutations in a partially-loaded spreadsheet model, the method comprising:

• loading onto a client computer a first chunk of a spreadsheet stored on a server, wherein the first chunk represents a first range of cells in the spreadsheet;
• searching local memory of the client computer for a second chunk of the spreadsheet, wherein the second chunk represents a second range of cells in the spreadsheet;
• storing a plurality of pending user mutations on the client computer generated by a user on the client computer in a pending queue, wherein the plurality of pending user mutations are applied to the first chunk, wherein each mutation in the plurality of mutations in the pending queue is labeled in a label as an unsent mutation;
• periodically sending, the plurality of pending user mutations from the client computer to the server to be applied to the spreadsheet and after sending the plurality of mutations to the server, changing the label of each mutation in the plurality of mutations from the unsent mutations to a sent mutation;
• receiving at the client computer, from the server, an acknowledgement after the plurality of pending user mutations are applied to the spreadsheet;
• deleting the plurality of pending user mutations from the pending queue after the client computer receives the acknowledgement from the server;
• receiving from the server a plurality of collaborator mutations;
• retrieving the second chunk from the local memory;
• transforming the plurality of pending user mutations against the plurality of collaborator mutations;
• and
• applying the transformed plurality of pending user mutations to the second chunk.