The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
May. 19, 2020
Filed:
Sep. 11, 2018
Apple Inc., Cupertino, CA (US);
Shawn Patrick Flisakowski, Saratoga, CA (US);
Matthew R. Lehrian, Pittsburgh, PA (US);
Edward P. Hogan, Pittsburgh, PA (US);
Anukul Kapoor, Pittsburgh, PA (US);
Marek R. Telgarsky, San Francisco, CA (US);
Apple Inc., Cupertino, CA (US);
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.