Dependency tree-based copying and pasting

1 . A method comprising:

receiving, by a workbook manager from a client computing system, a request to paste a first workbook element from a first workbook to a second workbook, wherein each workbook element includes a collection of graphical elements;

determining, by the workbook manager, that the first workbook element of the first workbook is in a first dependency relationship with one or more other workbook elements in the first workbook, including iterating, in response to the request to paste, through a dependency tree for the first workbook element to determine one or more dependency relationships including the first dependency relationship, wherein the dependency tree comprises nodes corresponding to workbook elements, wherein iterating includes traversing from a first node corresponding to the first workbook element toward a root node and identifying workbook elements dependent on the first workbook element for copying and preserving the dependencies;

copying, by the workbook manager in response to the determining, the one or more other workbook elements from the first workbook with the first workbook element to the second workbook, wherein the first dependency relationship is preserved after the copying; and

presenting, by the workbook manager on the client computing system, the second workbook comprising the first workbook element and the one or more other workbook elements.

2 . The method of claim 1 , wherein the one or more other workbook elements includes a second workbook element and a third workbook element, and wherein determining that the first workbook element of the first workbook is in a first dependency relationship with one or more other workbook elements in the first workbook comprises, based on a determination that the second workbook element and the third workbook element are in a second dependency relationship, preserving the second dependency relationship after the copying.

3 . The method of claim 1 , wherein the first workbook element includes a first data set that is hosted on a cloud-based data warehouse, and wherein the first data set is retrieved in response to a first database query that is composed to retrieve, from the cloud-based data warehouse, the first data set corresponding to the first workbook element.

4 . The method of claim 1 , further comprising:

identifying an update to the one or more other workbook elements; and

in response to the identifying, updating the first workbook element based on the first dependency relationship.

5 . The method of claim 1 , wherein the first workbook element is copied to a second workbook, further comprising:

presenting a copy of the first workbook element as part of the second workbook;

receiving input causing a change to the copy of the first workbook element; and

based on the received input, updating a presentation of the first workbook element as part of the first workbook.

6 . The method of claim 5 , further comprising:

in response to the received input, updating data corresponding to the first workbook element in a cloud-based data warehouse.

7 . An apparatus for dependency tree-based copying and pasting, 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:

receiving, from a client computing system, a request to paste a first workbook element from a first workbook to a second workbook, wherein each workbook element includes a collection of graphical elements;

determining that the first workbook element of the first workbook is in a first dependency relationship with one or more other workbook elements in the first workbook, including iterating, in response to the request to paste, through a dependency tree for the first workbook element to determine one or more dependency relationships including the first dependency relationship, wherein the dependency tree comprises nodes corresponding to workbook elements, wherein iterating includes traversing from a first node corresponding to the first workbook element toward a root node and identifying workbook elements dependent on the first workbook element for copying and preserving the dependencies;

copying, in response to the determining, the one or more other workbook elements from the first workbook with the first workbook element to the second workbook, wherein the first dependency relationship is preserved after the copying; and

presenting, on the client computing system, the second workbook comprising the first workbook element and the one or more other workbook elements.

8 . The apparatus of claim 7 , wherein the one or more other workbook elements includes a second workbook element and a third workbook element, and wherein the computer program instructions further cause the apparatus to carry out, based on a determination that the second workbook element and the third workbook element are in a second dependency relationship, preserving the second dependency relationship after the copying.

9 . The apparatus of claim 7 , wherein the computer program instructions further cause the apparatus to carry out:

identifying one or more operations that were applied, before the copying, to data of the first workbook element or the one or more other workbook elements; and

based on the identifying, preserving application of the one or more operations to data of the first workbook element or the one or more other workbook elements, wherein the one or more operations include data transformation operations, data formatting operations, or data ordering operations.

10 . The apparatus of claim 7 , wherein the first workbook element includes a first data set that is hosted on a cloud-based data warehouse, and wherein the first data set is retrieved in response to a first database query that is composed to retrieve, from the cloud-based data warehouse, the first data set corresponding to the first workbook element.

11 . The apparatus of claim 7 , wherein the computer program instructions further cause the apparatus to carry out:

identifying an update to the one or more other workbook elements; and

in response to the identifying, updating the first workbook element based on the first dependency relationship.

12 . The apparatus of claim 7 , wherein the first workbook element is copied to a second workbook, wherein the computer program instructions further cause the apparatus to carry out:

presenting a copy of the first workbook element as part of the second workbook;

receiving input causing a change to the copy of the first workbook element; and

based on the received input, updating a presentation of the first workbook element as part of the first workbook.

13 . The apparatus of claim 12 , wherein the computer program instructions further cause the apparatus to carry out:

in response to the received input, updating data corresponding to the first workbook element in a cloud-based data warehouse.

14 . A computer program product for dependency tree-based copying and pasting, the computer program product comprising a non-transitory computer readable medium having computer program instructions stored therein that, when executed, cause a computer to carry out:

receiving, from a client computing system, a request to paste a first workbook element from a first workbook to a second workbook, wherein each workbook element includes a collection of graphical elements;

determining that the first workbook element of the first workbook is in a first dependency relationship with one or more other workbook elements in the first workbook, including iterating, in response to the request to paste, through a dependency tree for the first workbook element to determine one or more dependency relationships including the first dependency relationship, wherein the dependency tree comprises nodes corresponding to workbook elements, wherein iterating includes traversing from a first node corresponding to the first workbook element toward a root node and identifying workbook elements dependent on the first workbook element for copying and preserving the dependencies;

copying, in response to the determining, the one or more other workbook elements from the first workbook with the first workbook element to the second workbook, wherein the first dependency relationship is preserved after the copying; and

presenting, on the client computing system, the second workbook comprising the first workbook element and the one or more other workbook elements.

15 . The computer program product of claim 14 , wherein the one or more other workbook elements includes a second workbook element and a third workbook element, and wherein the computer program instructions further cause the computer to carry out, based on a determination that the second workbook element and the third workbook element are in a second dependency relationship, preserving the second dependency relationship after the copying.

16 . The computer program product of claim 14 , wherein the computer program instructions further cause the computer to carry out:

identifying one or more operations that were applied, before the copying, to data of the first workbook element or the one or more other workbook elements; and

based on the identifying, preserving application of the one or more operations to data of the first workbook element or the one or more other workbook elements, wherein the one or more operations include data transformation operations, data formatting operations, or data ordering operations.