Exploded-range references
First Claim
1. A tangible, non-transitory, machine-readable medium, comprising machine-readable instructions that, when executed by one or more processors, cause the one or more processors to:
- identify a first range of cells in a base table of a spreadsheet application, the first range of cells specified in a first formula in the base table;
receive a request to organize the base table into an organized table, organized table view, or a combination thereof, based upon commonalities within a particular row or column of the base table;
organize rows and columns of the base table into the organized table, organized table view, or a combination thereof, grouping the rows and columns based upon the commonalities;
convert, based on tracking via a coordinate system, a cell index system, or a combination of both, the first range of cells in the base table into a second range of cells of the organized table, such that the second range of cells of the organized table, organized table view, or a combination thereof, includes the same cells as the first range of cells in the base table, despite the organization of the rows and columns of the base table into the organized table, organized table view, or a combination thereof; and
generate the organized table, organized table view, or a combination thereof, in the spreadsheet application with the first formula, substituting the second range of cells for the first range of cells.
1 Assignment
0 Petitions
Accused Products
Abstract
Systems, methods, and devices for tracking spreadsheet table cells from a base table to an organized table/organized table view, and updating of a formula reference based on the tracked cells are provided. In some embodiments, cells may be tracked to convert a first range of cells in the base table into a second range of cells in the organized table/organized table view, such that the second range of cells includes the same cells as the first range of cells, despite any reorganization of rows and columns. In some embodiments, a summary reference cell that provides a sub-group summary based upon the grouping within the organized table/organized table view may also be provided.
29 Citations
17 Claims
-
1. A tangible, non-transitory, machine-readable medium, comprising machine-readable instructions that, when executed by one or more processors, cause the one or more processors to:
-
identify a first range of cells in a base table of a spreadsheet application, the first range of cells specified in a first formula in the base table; receive a request to organize the base table into an organized table, organized table view, or a combination thereof, based upon commonalities within a particular row or column of the base table; organize rows and columns of the base table into the organized table, organized table view, or a combination thereof, grouping the rows and columns based upon the commonalities; convert, based on tracking via a coordinate system, a cell index system, or a combination of both, the first range of cells in the base table into a second range of cells of the organized table, such that the second range of cells of the organized table, organized table view, or a combination thereof, includes the same cells as the first range of cells in the base table, despite the organization of the rows and columns of the base table into the organized table, organized table view, or a combination thereof; and generate the organized table, organized table view, or a combination thereof, in the spreadsheet application with the first formula, substituting the second range of cells for the first range of cells. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A tangible, non-transitory, machine-readable medium, comprising machine-readable instructions that, when executed by one or more processors, cause the one or more processors to:
-
identify a first range of cells in a base table of a spreadsheet application, the first range of cells specified in a first formula in the base table; receive a request to organize the base table into an organized table, organized table view, or a combination thereof, based upon commonalities within a particular row or column of the base table; organize rows and columns of the base table into the organized table, organized table view, or a combination thereof, grouping the rows and columns based upon the commonalities; convert the first range of cells in the base table into a second range of cells of the organized table, such that the second range of cells of the organized table, organized table view, or a combination thereof, includes the same cells as the first range of cells in the base table, despite the organization of the rows and columns of the base table into the organized table, organized table view, or a combination thereof; and generate the organized table, organized table view, or a combination thereof, in the spreadsheet application with the first formula, substituting the second range of cells for the first range of cells, wherein the grouping causes the second range of cells in the organized table, organized table view, or a combination thereof, to be arranged in noncontiguous arrangement. - View Dependent Claims (8, 9)
-
-
10. A tangible, non-transitory, machine-readable medium, comprising machine-readable instructions that, when executed by one or more processors, cause the one or more processors to:
generate an organized table, organized table view, or a combination thereof, in a spreadsheet application, by; organizing rows and columns of a base table into the organized table, organized table view, or a combination thereof, grouping the rows and columns into groups based upon commonalities within a particular row, column, or both of the base table; inserting a summary header, a summary cell, or both that provides a group summary based upon the grouping within the organized table, organized table view, or a combination thereof; convert a first range of cells in a formula of the base table into a second range of cells of the organized table, organized table view, or a combination thereof, such that the second range of cells of the organized table, organized table view, or a combination thereof, includes the same cells as the first range of cells in the base table, despite the organization of the rows and columns of the base table into the organized table; and substitute the second range of cells in the formula in the organized table, organized table view, or a combination thereof. - View Dependent Claims (11, 12, 13)
-
14. A system, comprising:
-
an electronic display, configured to display a graphical user interface (GUI) comprising a spreadsheet; and one or more processors, configured to; render, in the GUI, a base table; identify a first range of cells in the base table that are specified in a first formula in the base table; receive, via a selection in the GUI, a request to organize the base table into an organized table, organized table view, or a combination thereof, based upon commonalities within a particular row or column of the base table; in response to receiving the request to organize the base table, generate a grouping dialog box that provides selectable grouping options; organize rows and columns of the base table into the organized table, organized table view, or a combination thereof, in accordance with the selectable grouping options, grouping the rows and columns into groups based upon the commonalities; convert the first range of cells in the base table into a second range of cells of the organized table, organized table view, or a combination thereof, such that the second range of cells of the organized table, organized table view, or a combination thereof, includes the same cells as the first range of cells in the base table, despite the organization of the rows and columns of the base table into the organized table, organized table view, or a combination thereof; and generate the organized table, organized table view, or a combination thereof, in the GUI with the first formula, substituting the second range of cells for the first range of cells. - View Dependent Claims (15, 16, 17)
-
Specification