Arranging workbook elements using a dynamic grid layout
Arranging workbook elements using a dynamic grid layout including presenting, by a workbook client on a client computing system, a workbook comprising an element grid for placing workbook elements, wherein the element grid comprises a plurality of grid columns and a plurality of grid rows; receiving, by the workbook client at a particular location within the element grid, a first workbook element for placement on the element grid, wherein the particular location is between two lines of the element grid; and moving, by the workbook client, the first workbook element to align with a nearest line of the two lines of the element grid.
1. A method for arranging workbook elements using a dynamic grid layout, the method comprising:
presenting, by a workbook client on a client computing system, a workbook comprising an element grid for placing workbook elements, wherein the element grid comprises a plurality of grid columns and a number of grid rows;
receiving, by the workbook client at a particular location within the element grid, a first workbook element for placement on the element grid, wherein the particular location is between two lines of the element grid;
moving, by the workbook client, the first workbook element to align with a nearest line of the two lines of the element grid;
receiving a resize instruction to resize the element grid, wherein the resize instruction includes a location on a vertical axis, wherein the first workbook element spans the location on the vertical axis, and wherein a second workbook element within the workbook does not span the location on the vertical axis; and
resizing, vertically based on the resize instruction, the element grid and the first workbook element without resizing the second workbook element by changing the number of grid rows.
2. The method of claim 1 , further comprising:
detecting that a third workbook element has been placed within a same space on the element grid as the first workbook element; and
presenting a placement option for the third workbook element.
3. The method of claim 2 , further comprising:
receiving, in response to presenting the placement option, an instruction to split the space on the element grid between the first workbook element and the third workbook element;
resizing the first workbook element to occupy a first half of the space on the element grid; and
placing the third workbook element to occupy a second half of the space on the element grid.
4. The method of claim 2 , further comprising:
receiving, in response to presenting the placement option, an instruction to replace the first workbook element with the third workbook element; and
replacing the first workbook element in the space on the element grid with the third workbook element.
5. The method of claim 2 , further comprising:
receiving, in response to presenting the placement option, an instruction to insert the third workbook element to a location adjacent to the first workbook element; and
placing the third workbook element adjacent to the first workbook element.
6. The method of claim 1 , further comprising:
detecting that a subset of the plurality of grid rows above the first workbook element are empty; and
presenting an option to remove the subset of the plurality of grid rows.
7. The method of claim 1 , further comprising:
detecting that a subset of the plurality of grid columns adjacent to the first workbook element are empty; and
presenting an option to remove the subset of the plurality of grid columns.
8. The method of claim 1 , further comprising:
maintaining a vertical height of the first workbook element in response to detecting that a size of the workbook has changed.
9. The method of claim 1 , wherein the first workbook element presents a dataset from a cloud-based data warehouse.
10. An apparatus for arranging workbook elements using a dynamic grid layout, 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:
presenting, by a workbook client on a client computing system, a workbook comprising an element grid for placing workbook elements, wherein the element grid comprises a plurality of grid columns and a number of grid rows;
receiving, by the workbook client at a particular location within the element grid, a first workbook element for placement on the element grid, wherein the particular location is between two lines of the element grid;
moving, by the workbook client, the first workbook element to align with a nearest line of the two lines of the element grid;
receiving a resize instruction to resize the element grid, wherein the resize instruction includes a location on a vertical axis, wherein the first workbook element spans the location on the vertical axis, and wherein a second workbook element within the workbook does not span the location on the vertical axis; and
resizing, vertically based on the resize instruction, the element grid and the first workbook element without resizing the second workbook element by changing the number of grid rows.
11. The apparatus of claim 10 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
detecting that a third workbook element has been placed within a same space on the element grid as the first workbook element; and
presenting a placement option for the third workbook element.
12. The apparatus of claim 11 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
receiving, in response to presenting the placement option, an instruction to split the space on the element grid between the first workbook element and the third workbook element;
resizing the first workbook element to occupy a first half of the space on the element grid; and
placing the second workbook element to occupy a third half of the space on the element grid.
13. The apparatus of claim 11 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
receiving, in response to presenting the placement option, an instruction to replace the first workbook element with the third workbook element; and
replacing the first workbook element in the space on the element grid with the third workbook element.
14. The apparatus of claim 11 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
receiving, in response to presenting the placement option, an instruction to insert the third workbook element to a location adjacent to the first workbook element; and
placing the third workbook element adjacent to the first workbook element.
15. The apparatus of claim 10 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
detecting that a subset of the plurality of grid rows above the first workbook element are empty; and
presenting an option to remove the subset of the plurality of grid rows.
16. The apparatus of claim 10 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
detecting that a subset of the plurality of grid columns adjacent to the first workbook element are empty; and
presenting an option to remove the subset of the plurality of grid columns.
17. The apparatus of claim 10 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
maintaining a vertical height of the first workbook element in response to detecting that a size of the workbook has changed.
18. A computer program product for arranging workbook elements using a dynamic grid layout, 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:
presenting, by a workbook client on a client computing system, a workbook comprising an element grid for placing workbook elements, wherein the element grid comprises a plurality of grid columns and a number of grid rows;
receiving, by the workbook client at a particular location within the element grid, a first workbook element for placement on the element grid, wherein the particular location is between two lines of the element grid;
moving, by the workbook client, the first workbook element to align with a nearest line of the two lines of the element grid;
receiving a resize instruction to resize the element grid, wherein the resize instruction includes a location on a vertical axis, wherein the first workbook element spans the location on the vertical axis, and wherein a second workbook element within the workbook does not span the location on the vertical axis; and
resizing, vertically based on the resize instruction, the element grid and the first workbook element without resizing the second workbook element by changing the number of grid rows.