Invention Grant
- Patent Title: Exploded-range references
-
Application No.: US16128306Application Date: 2018-09-11
-
Publication No.: US10657321B2Publication Date: 2020-05-19
- Inventor: Shawn Patrick Flisakowski , Matthew R. Lehrian , Edward P. Hogan , Anukul Kapoor , Marek R. Telgarsky
- Applicant: Apple Inc.
- Applicant Address: US CA Cupertino
- Assignee: Apple Inc.
- Current Assignee: Apple Inc.
- Current Assignee Address: US CA Cupertino
- Agency: Fletcher Yoder PC
- Main IPC: G06F17/00
- IPC: G06F17/00 ; G06F40/18 ; G06F40/103 ; G06F3/0482 ; G06F3/0484

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.
Public/Granted literature
- US20200081968A1 EXPLODED-RANGE REFERENCES Public/Granted day:2020-03-12
Information query