US 12,169,687 B2
Methods and systems for spreadsheet function and flex copy paste control of formatting and use of selection list panels
Robert E. Dvorak, Portola Valley, CA (US); Yuriy Garin, San Carlos, CA (US); and Alexey Verkhovskiy, Calgary (CA)
Assigned to Adaptam Inc., Palo Alto, CA (US)
Filed by Adaptam Inc., Palo Alto, CA (US)
Filed on May 2, 2023, as Appl. No. 18/142,560.
Claims priority of provisional application 63/337,576, filed on May 2, 2022.
Prior Publication US 2023/0351104 A1, Nov. 2, 2023
Int. Cl. G06F 3/048 (2013.01); G06F 40/103 (2020.01); G06F 40/18 (2020.01)
CPC G06F 40/18 (2020.01) [G06F 40/103 (2020.01)] 40 Claims
OG exemplary drawing
 
1. As an alternative to formatting cells, when the cells are populated by a built-in spreadsheet function contained in a cell of a spreadsheet, a method applying formatting as an argument of the built-in spreadsheet function including:
receiving a first signal from a user invoking a selection list panel, in a context of a user-specified built-in spreadsheet function in a spreadsheet cell that populates a plurality of cells in a spreadsheet range with function results;
responsive to the first signal, causing display of the selection list panel that includes a list of specifications appropriate to the context that are useable with the built-in spreadsheet function,
wherein a plurality of first specifications in the list are formatting specifications that configure formatting of output from the built-in spreadsheet to populate a plurality of cells in a spreadsheet range and override cell formatting otherwise applied to the spreadsheet range; and
receiving at least one second signal from the user selecting at least one of the formatting specifications, and configuring the formatting of the output from the built-in spreadsheet function accordingly when the spreadsheet function is committed to the spreadsheet cell.