US 12,260,170 B2
Ability to add non-direct ancestor columns in child spreadsheets
Xiameng Chen, Foster City, CA (US); and Shaun Logan, Melrose, MA (US)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Jul. 28, 2022, as Appl. No. 17/876,327.
Prior Publication US 2024/0037325 A1, Feb. 1, 2024
Int. Cl. G06F 16/28 (2019.01); G06F 16/22 (2019.01); G06F 40/18 (2020.01)
CPC G06F 40/18 (2020.01) [G06F 16/221 (2019.01); G06F 16/282 (2019.01)] 16 Claims
OG exemplary drawing
 
1. A non-transitory computer-readable storage medium having instructions to facilitate retrieving context information into a client-side worksheet of a spreadsheet, the non-transitory computer-readable storage medium executed by a computer to perform a process of:
determining one or more non-direct ancestor data dimensions of one or more non-direct ancestor worksheets of a descendant worksheet in a hierarchically structured workbook of a spreadsheet, wherein a non-direct ancestor is any ancestor other than a parent;
selectively retrieving the one or more non-direct ancestor data dimensions of the one or more non-direct ancestor worksheets via one or more servers via one or more web services or Application Programming Interfaces (APIs), resulting in one or more retrieved data dimensions;
displaying the one or more retrieved data dimensions in the descendant worksheet in combination with one or more preexisting data dimensions of the descendant worksheet, wherein the one or more retrieved data dimensions are the one or more non-direct ancestor data dimensions of the one or more non-direct ancestor worksheets that were obtained by the selectively retrieving and wherein the descendent worksheet is in the hierarchical structured workbook of the spread sheet;
receiving input in the descendant worksheet specifying a parent worksheet of the descendant worksheet, resulting in received input;
using the received input to retrieve the one or more non-direct ancestor data dimensions from one or more ancestors of the parent worksheet for subsequent display in the descendant worksheet;
detecting a modification to a first data dimension of the one or more preexisting data dimensions in the descendant worksheet; and
receiving a signal to update data of a server-side data model corresponding to the first data dimension in response to the detecting.