Live editing a workbook with multiple clients
Live editing a workbook with multiple clients including receiving, by a table manager, a request by a first client on a first client computing system to edit a workbook in an exploration mode that displays edits to the workbook without altering the workbook; receiving, by the table manager from the first client, an exploration edit targeting the exploration of the workbook; applying, by the table manager, the exploration edit to the exploration of the workbook; and presenting, by the table manager to a second client on a second client computing system, the application of the exploration edit to the exploration of the workbook.
1. A method for live editing a workbook with multiple clients, the method comprising:
receiving, by a table manager, a request to edit a workbook in an exploration mode by a first client on a first client computing system with permission to edit the workbook in the exploration mode and without permission to edit the workbook, wherein the exploration mode displays edits to the workbook without altering the workbook, and wherein the workbook presents a data set retrieved by the table manager from a database included within a cloud-based data warehouse;
receiving, by the table manager from the first client, an exploration edit targeting the exploration of the workbook;
applying, by the table manager, the exploration edit to the exploration of the workbook without changing the workbook underlying the exploration of the workbook, including:
creating a temporary workbook file using the workbook as a data source; and
applying the exploration edit to the temporary workbook file;
presenting, by the table manager to a second client on a second client computing system, the application of the exploration edit to the exploration of the workbook;
storing, by the table manager separate from the workbook, a bookmark for the exploration of the workbook comprising the exploration edit and an identifier of the workbook, wherein the bookmark describes a state of the exploration of the workbook comprising the exploration edit; and
in response to a request for the bookmark from a third client on a third client computing system, presenting, to the third client, the application of the exploration edit to the workbook in the exploration mode.
2. The method of claim 1 , further comprising:
detecting that an update has been made to the workbook by a client accessing the workbook; and
presenting the exploration of the workbook comprising the update to the first client on the first client computing system and the second client on the second client computing system.
3. The method of claim 1 , wherein presenting, to the second client on the second client computing system, the application of the exploration edit to the exploration of the workbook is performed contemporaneously with presenting, to the first client on the first client computing system, the application of the exploration edit to the exploration of the workbook.
4. The method of claim 1 , wherein presenting, to the second client on the second client computing system, the application of the exploration edit to the exploration of the workbook comprises presenting an animation of the change to the exploration of the workbook caused by the exploration edit.
5. The method of claim 1 , wherein the exploration edit modifies a visualization of the workbook.
6. The method of claim 1 , wherein the exploration edit modifies a spreadsheet structure of the workbook.
7. The method of claim 1 , wherein the cloud-based data warehouse is separate from a computing system comprising the table manager.
8. The method of claim 1 , wherein the table manager is on an intermediary computing system.
9. 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 table manager, a request to edit a workbook in an exploration mode by a first client on a first client computing system with permission to edit the workbook in the exploration mode and without permission to edit the workbook, wherein the exploration mode displays edits to the workbook without altering the workbook, wherein the workbook presents a data set retrieved by the table manager from a database included within a cloud-based data warehouse;
receiving, by the table manager from the first client, an exploration edit targeting the exploration of the workbook;
applying, by the table manager, the exploration edit to the exploration of the workbook without changing the workbook underlying the exploration of the workbook, including:
creating a temporary workbook file using the workbook as a data source; and
applying the exploration edit to the temporary workbook file;
presenting, by the table manager to a second client on a second client computing system, the application of the exploration edit to the exploration of the workbook;
storing, by the table manager separate from the workbook, a bookmark for the exploration of the workbook comprising the exploration edit and an identifier of the workbook, wherein the bookmark describes a state of the exploration of the workbook comprising the exploration edit; and
in response to a request for the bookmark from a third client on a third client computing system, presenting, to the third client, the application of the exploration edit to the workbook in the exploration mode.
10. The apparatus of claim 9 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
detecting that an update has been made to the workbook by a client accessing the workbook; and
presenting the exploration of the workbook comprising the update to the first client on the first client computing system and the second client on the second client computing system.
11. The apparatus of claim 9 , wherein presenting, to the second client on the second client computing system, the application of the exploration edit to the exploration of the workbook is performed contemporaneously with presenting, to the first client on the first client computing system, the application of the exploration edit to the exploration of the workbook.
12. The apparatus of claim 9 , wherein presenting, to the second client on the second client computing system, the application of the exploration edit to the exploration of the workbook comprises presenting an animation of the change to the exploration of the workbook caused by the exploration edit.
13. The apparatus of claim 9 , wherein the exploration edit modifies a visualization of the workbook.
14. The apparatus of claim 9 , wherein the exploration edit modifies a spreadsheet structure of the workbook.
15. The apparatus of claim 9 , wherein the cloud-based data warehouse is separate from a computing system comprising the table manager.
16. 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 table manager, a request to edit a workbook in an exploration mode by a first client on a first client computing system with permission to edit the workbook in the exploration mode and without permission to edit the workbook, wherein the exploration mode displays edits to the workbook without altering the workbook, wherein the workbook presents a data set retrieved by the table manager from a database included within a cloud-based data warehouse;
receiving, by the table manager from the first client, an exploration edit targeting the exploration of the workbook;
applying, by the table manager, the exploration edit to the exploration of the workbook without changing the workbook underlying the exploration of the workbook, including:
creating a temporary workbook file using the workbook as a data source; and
applying the exploration edit to the temporary workbook file;
presenting, by the table manager to a second client on a second client computing system, the application of the exploration edit to the exploration of the workbook;
storing, by the table manager separate from the workbook, a bookmark for the exploration of the workbook comprising the exploration edit and an identifier of the workbook, wherein the bookmark describes a state of the exploration of the workbook comprising the exploration edit; and
in response to a request for the bookmark from a third client on a third client computing system, presenting, to the third client, the application of the exploration edit to the workbook in the exploration mode.