×

Exploded-range references

  • US 10,657,321 B2
  • Filed: 09/11/2018
  • Issued: 05/19/2020
  • Est. Priority Date: 09/11/2018
  • Status: Active Grant
First Claim
Patent Images

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 all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×