US 12,007,970 B2
Automatic rewriting of subtotal calculations
Jason D. Frantz, San Francisco, CA (US); Robert C. Woollen, San Rafael, CA (US); and Joseph M. Hain, Benicia, CA (US)
Assigned to SIGMA COMPUTING, INC., San Francisco, CA (US)
Filed by SIGMA COMPUTING, INC., San Francisco, CA (US)
Filed on May 25, 2022, as Appl. No. 17/824,255.
Prior Publication US 2023/0409548 A1, Dec. 21, 2023
Int. Cl. G06F 16/22 (2019.01); G06F 16/28 (2019.01)
CPC G06F 16/221 (2019.01) [G06F 16/2282 (2019.01); G06F 16/283 (2019.01)] 18 Claims
OG exemplary drawing
 
1. A method for automatic rewriting of subtotal calculations, the method comprising:
presenting, by a table manager, a spreadsheet structure on a GUI of a client computing system, wherein the spreadsheet structure presents a data set from a cloud-based data warehouse;
receiving, at a first column of the spreadsheet structure by the table manager, a formula that includes a reference to a second column of the spreadsheet structure, wherein the formula is received from the client computing system, wherein receiving the formula that includes the reference to the second column of the spreadsheet structure comprises receiving a request to create the first column;
detecting, by the table manager, that the second column includes a subtotal calculation of a third column of the spreadsheet structure; and
rewriting, by the table manager, the formula by replacing the reference to the second column with the subtotal calculation of the third column.