Seamless grid and canvas integration in a spreadsheet application

• US 10,664,652 B2
• Filed: 06/15/2013
• Issued: 05/26/2020
• Est. Priority Date: 06/15/2013
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Campbell, John, Radakovitz, Sam C
• Primary Examiner(s): Edwards, Jason T
• Application Number:
  US13/918,914
• Publication Number:
  US 20140372858A1
• Time in Patent Office: 2,537 Days
• Field of Search: 715220
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

Seamless grid and canvas integration in a spreadsheet application is provided. One or more data items may be pulled from a grid-structured spreadsheet and may be allowed to “float” on the grid-structure spreadsheet without regard to the underlying grid. The floating object may be pushed or inserted back into the grid of the same or different spreadsheet at any location. A pulled data object also may be dropped onto a grid-less canvas user interface object and may be moved about on the canvas object in a free form manner. References between data and computations in the moved data object are structured and maintained so that the data object may be manipulated and increased/decreased without adversely affecting the underlying grid and such that both data and computational references between the data object and the underlying grid are maintained.

Claims

1. A computer-implemented method of managing data in an electronic spreadsheet, comprising:

causing display of an electronic document wherein the electronic document is a grid-structured spreadsheet in which data is arranged in one or more cells of a grid;

causing display of a data object in the grid-structured spreadsheet, the data object positioned in one or more other cells of the grid-structured spreadsheet;

receiving a pulling of the data object out of the grid-structured spreadsheet such that the pulled data object is removed from the one or more other cells in which it is positioned;

depositing the pulled data object such that the pulled data object is cause to be displayed on top of the grid-structured spreadsheet, the pulled data object is not positioned in the one or more other cells, and the deposited pulled data object when displayed on top of the grid-structured spreadsheet may be moved freely on the grid-structured spreadsheet without being positioned in any cells of the grid-structured spreadsheet; and

updating the pulled data object while displayed as freely moveable, based on one or more of the following;

direct editing of a component of the pulled data object by a user;

recalculation of the spreadsheet while maintaining computational functions associated with the pulled data object, wherein each data item of the pulled data object may be mapped back to the data item from which it was extracted; and

adjustment of a formula within the grid-structured spreadsheet, wherein the formula provides a computational function associated with the pulled data object.

2. The method of claim 1, further comprising after depositing the pulled data object on the grid-structured spreadsheet, enabling one or more guide lines in the grid-structured spreadsheet to automatically align and position the deposited pulled data object on the grid-structured spreadsheet at a particular position.

3. The method of claim 2, further comprising automatically re-sizing the deposited pulled data object to a display size corresponding to one or more cells onto which the deposited pulled data object is positioned.

4. The method of claim 1, further comprising in response to receiving the pulling of the data object out of the grid-structured spreadsheet, creating a structured reference between any data items or computational functions in or associated with the pulled data object and corresponding data items or computational functions in or associated with the grid-structured spreadsheet such that relationships between data items or computational functions in or associated with the pulled data object and corresponding data items or computational functions in or associated with the grid-structured spreadsheet are maintained after the data object is pulled from the grid-structured spreadsheet.

5. The method of claim 1, wherein causing display of a data object in the grid-structured spreadsheet includes causing display of one or more of:

a data object in a cell;

a data object in a range of cells;

a table;

a chart;

a pivot table;

a pivot chart; and

a named range of cells.

6. The method of claim 1, further comprising

receiving a selection to push the pulled data object back into the grid-structured spreadsheet;

and

inserting the pulled data object back into the grid-structured spreadsheet such that the pulled data object is positioned in one or more cells of the grid-structured spreadsheet.

7. The method of claim 6, wherein inserting the pulled data object back into the grid-structured spreadsheet includes inserting the pulled data object into a second grid-structured spreadsheet and positioning the pulled data object in one or more cells of the second grid-structured spreadsheet.

8. The method of claim 1, wherein instead of depositing the pulled data object on the grid-structured spreadsheet, depositing the pulled data object on a canvas-like user interface such that the data object may be moved freely on the canvas-like user interface.

9. The method of claim 8, further comprising in response to receiving the pulling of the data object out of the grid-structured spreadsheet, creating a structured reference between any data items or computational functions in or associated with the pulled data object and corresponding data items or computational functions in or associated with the grid-structured spreadsheet such that relationships between data items or computational functions in or associated with the pulled data object and corresponding data items or computational functions in or associated with the grid-structured spreadsheet are maintained after the data object is pulled from the grid-structured spreadsheet.

10. The method of claim 8, further comprising:

receiving a selection to pull the data object deposited on the canvas-like user interface and pushing the pulled data object back into the grid-structured spreadsheet; and

inserting the pulled data object back into the grid-structured spreadsheet such that the pulled data object is positioned in one or more cells of the grid-structured spreadsheet.

11. The method of claim 1, wherein updating the pulled data object while freely moveable comprises at least one of:

updating the pulled data object in response to changes made by the user to a data item located at another place in the grid-structured spreadsheet; and

updating the pulled data object when the spreadsheet recalculates.

12. The method of claim 1 wherein the pulled data object comprises more than one cell and at least one cell of the more than one cell of pulled data object is updated while displayed as freely moveable.

13. A computer-implemented method of utilizing spreadsheet objects in an electronic canvas, comprising:

displaying an electronic document wherein the electronic document is a grid-structured spreadsheet in which data is arranged in one or more cells of a grid;

displaying a data object in the grid-structured spreadsheet, the data object positioned in one or more other cells of the grid-structured spreadsheet;

receiving a pulling of the data object out of the grid-structured spreadsheet such that the pulled data object is removed from the one or more other cells in which it is positioned;

depositing the pulled data object such that the pulled data object is displayed on a canvas-like user interface, and the pulled data object may be moved freely on the canvas-like user interface; and

updating the pulled data object while displayed as freely moveable, based on one or more of the following;

direct editing of a component of the pulled object by a user;

recalculation of the spreadsheet while maintaining computational functions associated with the pulled data object, wherein each data item of the pulled data object may be mapped back to the data item from which it was extracted; and

adjustment of a formula within the grid-structured spreadsheet, wherein the formula provides a computational function associated with the pulled data object.

14. The method of claim 13, further comprising in response to receiving the pulling of the data object out of the grid-structured spreadsheet, creating a structured reference between any data items or computational functions in or associated with the pulled data object and corresponding data items or computational functions in or associated with the grid-structured spreadsheet such that relationships between data items or computational functions in or associated with the pulled data object and corresponding data items or computational functions in or associated with the grid-structured spreadsheet are maintained after the data object is pulled from the grid-structured spreadsheet.

15. The method of claim 13, wherein displaying a data object in the grid-structured spreadsheet includes displaying one or more of:

a data object in a cell;

a data object in a range of cells;

a table;

a chart;

a pivot table;

a pivot chart; and

a named range of cells.

16. The method of claim 13, further comprising:

receiving a selection to pull the data object deposited on the canvas-like user interface and pushing the pulled data object back into the grid-structured spreadsheet; and

inserting the pulled data object back into the grid-structured spreadsheet such that the pulled data object is positioned in one or more cells of the grid-structured spreadsheet.

17. The method of claim 16, wherein inserting the pulled data object back into the grid-structured spreadsheet includes inserting the pulled data object into a second grid-structured spreadsheet and positioning the pulled data object in one or more cells of the second grid-structured spreadsheet.

18. The method of claim 13, further comprising:

receiving a selection to pull the data object deposited on the canvas-like user interface; and

depositing the pulled data object on a second canvas-like user interface such that the deposited data object may be moved freely on the second canvas-like user interface.

19. The method of claim 13, further comprising:

associating the canvas-like user interface and the grid-structured spreadsheet together as part of a spreadsheet document and allowing navigation from the grid-structured spreadsheet to the canvas-like user interface and vice versa in the spreadsheet document.

20. The method of claim 19, wherein a portion or all of the grid-structured spreadsheet may be deposited on the canvas-like user interface as a data object that may be moved freely about on the canvas-like user interface.

21. The method of claim 19, further comprising adding one or more additional grid-structured spreadsheets and one or more additional canvas-like user interfaces to the spreadsheet document.

22. A system for managing data in an electronic spreadsheet, comprising:

one or more processors; and

a memory coupled to the one or more processors, the one or more processors operable to;

display an electronic document wherein the electronic document is a grid-structured spreadsheet in which data is arranged in one or more cells of a grid;

display a data object in the grid-structured spreadsheet, the data object positioned in one or more other cells of the grid-structured spreadsheet;

receive a pulling of the data object out of the grid-structured spreadsheet such that the pulled data object is removed from the one or more other cells in which it is positioned;

deposit the pulled data object such that the pulled data object is displayed on top of the grid-structured spreadsheet, the pulled data object is not positioned in the one or more other cells, and the deposited pulled data object when displayed on top of the grid-structured spreadsheet may be moved freely on the grid-structured spreadsheet without being positioned in any cells of the grid-structured spreadsheet;

update the pulled data object while displayed as freely moveable, based on one or more of the following;

direct editing of a component of the pulled data object by a user;

recalculation of the spreadsheet while maintaining computational functions associated with the pulled data object, wherein each data item of the pulled data object may be mapped back to the data item from which it was extracted; and

adjustment of a formula within the grid-structured spreadsheet, wherein the formula provides a computational function associated with the pulled data object; and

create a structured reference between any data items or computational functions in or associated with the pulled data object and corresponding data items or computational functions in or associated with the grid-structured spreadsheet such that relationships between data items or computational functions in or associated with the pulled data object and corresponding data items or computational functions in or associated with the grid-structured spreadsheet are maintained after the data object is pulled from the grid-structured spreadsheet.