Resolving live edit conflicts
Live editing a workbook with multiple clients including receiving, by a workbook manager from a first workbook client, a first workbook patch comprising a base version ID and a first workbook edit; determining, by the workbook manager, that the base version ID from the first workbook patch matches the version ID for a confirmed workbook on the workbook manager; applying, by the workbook manager, the first workbook edit to the confirmed workbook on the workbook manager; advancing, by the workbook manager, the version ID for the confirmed workbook; and sending, by the workbook manager, an acknowledgement of the first workbook patch to the first workbook client.
1. A method for live editing a workbook with multiple clients, the method comprising:
receiving, by a workbook manager from a first workbook client, a first workbook patch comprising a base version ID, a proposed version ID, and a first workbook edit;
determining, by the workbook manager, that the base version ID from the first workbook patch matches a version ID for a confirmed workbook on the workbook manager;
applying, by the workbook manager, the first workbook edit to the confirmed workbook on the workbook manager;
advancing, by the workbook manager, the version ID for the confirmed workbook to the proposed version ID from the first workbook patch; and
sending, by the workbook manager, an acknowledgement of the first workbook patch to the first workbook client.
2. The method of claim 1 , further comprising:
receiving, by the workbook manager from a second workbook client, a second workbook patch comprising a base version ID and a second workbook edit;
determining, by the workbook manager, that the base version ID from the second workbook patch does not match the version ID for the confirmed workbook on the workbook manager; and
sending, by the workbook manager, a rejection of the second workbook patch to the second workbook client.
3. The method of claim 1 , further comprising:
sending, by the workbook manager to a second workbook client, an instruction to apply the first workbook patch to the workbook on the second workbook client and advance the version ID of the workbook on the second workbook client.
4. The method of claim 1 , wherein the workbook manager receives the first workbook patch after the first workbook patch is applied to the workbook on first workbook client.
5. The method of claim 1 , wherein the first workbook client is on a first workbook client computing system.
6. The method of claim 1 , wherein the first workbook edit modifies a visualization of the workbook.
7. The method of claim 1 , wherein the first workbook edit modifies a spreadsheet structure of the workbook.
8. The method of claim 1 , wherein the confirmed workbook is populated with data from a cloud-based data warehouse.
9. The method of claim 1 , wherein the workbook manager is on an intermediary computing system.
10. An apparatus for live editing a workbook with multiple clients, the apparatus comprising a computer processor, a computer memory operatively coupled to the computer processor, the computer memory having disposed within it computer program instructions that, when executed by the computer processor, cause the apparatus to carry out the steps of:
receiving, by a workbook manager from a first workbook client, a first workbook patch comprising a base version ID, a proposed version ID, and a first workbook edit;
determining, by the workbook manager, that the base version ID from the first workbook patch matches a version ID for a confirmed workbook on the workbook manager;
applying, by the workbook manager, the first workbook edit to the confirmed workbook on the workbook manager;
advancing, by the workbook manager, the version ID for the confirmed workbook to the proposed version ID from the first workbook patch; and
sending, by the workbook manager, an acknowledgement of the first workbook patch to the first workbook client.
11. The apparatus of claim 10 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
receiving, by the workbook manager from a second workbook client, a second workbook patch comprising a base version ID and a second workbook edit;
determining, by the workbook manager, that the base version ID from the second workbook patch does not match the version ID for the confirmed workbook on the workbook manager; and
sending, by the workbook manager, a rejection of the second workbook patch to the second workbook client.
12. The apparatus of claim 10 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
sending, by the workbook manager to a second workbook client, an instruction to apply the first workbook patch to the workbook on the second workbook client and advance the version ID of the workbook on the second workbook client.
13. The apparatus of claim 10 , wherein the workbook manager receives the first workbook patch after the first workbook patch is applied to the workbook on first workbook client.
14. The apparatus of claim 10 , wherein the first workbook client is on a first workbook client computing system.
15. The apparatus of claim 10 , wherein the first workbook edit modifies a visualization of the workbook.
16. The apparatus of claim 10 , wherein the first workbook edit modifies a spreadsheet structure of the workbook.
17. The apparatus of claim 10 , wherein the confirmed workbook is populated with data from a cloud-based data warehouse.
18. A computer program product for live editing a workbook with multiple clients, the computer program product disposed upon a non-transitory computer readable medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out the steps of:
receiving, by a workbook manager from a first workbook client, a first workbook patch comprising a base version ID, a proposed version ID, and a first workbook edit;
determining, by the workbook manager, that the base version ID from the first workbook patch matches a version ID for a confirmed workbook on the workbook manager;
applying, by the workbook manager, the first workbook edit to the confirmed workbook on the workbook manager;
advancing, by the workbook manager, the version ID for the confirmed workbook to the proposed version ID from the first workbook patch; and
sending, by the workbook manager, an acknowledgement of the first workbook patch to the first workbook client.