US 11,657,217 B2
Methods and systems for presenting drop-down, pop-up or other presentation of a multi-value data set in a spreadsheet cell
Robert E. Dvorak, Portola Valley, CA (US)
Assigned to Adaptam Inc., Palo Alto, CA (US)
Filed by Adaptam Inc., Palo Alto, CA (US)
Filed on Jun. 25, 2021, as Appl. No. 17/359,418.
Claims priority of provisional application 63/044,989, filed on Jun. 26, 2020.
Claims priority of provisional application 63/044,990, filed on Jun. 26, 2020.
Prior Publication US 2021/0406458 A1, Dec. 30, 2021
Int. Cl. G06F 3/048 (2013.01); G06F 40/18 (2020.01); G06F 9/451 (2018.01); G06F 3/0482 (2013.01); G06F 3/0489 (2022.01)
CPC G06F 40/18 (2020.01) [G06F 3/0482 (2013.01); G06F 3/0489 (2013.01); G06F 9/451 (2018.02); G06F 9/453 (2018.02)] 44 Claims
OG exemplary drawing
 
1. A method of providing a user interface picklist for inserting a value into a cell, using a spreadsheet (predefined formula) function running on a system including at least one processor and memory coupled to the processor including:
responsive to a user interface picklist function in a cell of the spreadsheet that references a list source that is not adjacent to the cell that holds the user interface picklist function,
automatically retrieving, sorting and deduplicating values from the list source without modifying the list source itself;
returning an initially displayable value to the cell that is from the list source, is blank awaiting selection from the list source, or is an instruction regarding use of the list source;
making the picklist for the cell available responsive to the selection by presenting the sorted and deduplicated values; and
upon receiving a selection from the picklist, replacing the initially displayable value returned by the picklist for use in the cell.