# US 2026/0064952 A1 · Methods and systems for presenting drop-down, pop-up or other presentation of a multi-value data set in a spreadsheet cell

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2026/0064952 A1
- Document ID: US20260064952A1
- Status: Published application
- Kind: A1
- Application number: 19/385,104
- Filed: 2025-11-10
- Published: 2026-03-05
- Earliest claimed: 2020-06-26
- Assignees: Adaptam Inc.
- Applicants: Adaptam Inc.
- Inventors: Robert E. DVORAK
- Web page: https://patentgrep.com/patent/US20260064952A1

## CPC

- G06F 40/18: of spreadsheets (form-filling G06F40/174)
- G06F 3/0482: Interaction with lists of selectable items, e.g. menus
- G06F 3/0489: using dedicated keyboard keys or combinations thereof
- G06F 9/451: Execution arrangements for user interfaces
- G06F 9/453: {Help systems}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

The technology disclosed relates to accessing multiple data values by an improved spreadsheet function referencing a single spreadsheet cell. The multiple data value can reside in a range of cells, at locations other than the single spreadsheet cell, or in an external data source (NSC data). The multiple values are used by the spreadsheet function to calculate an algebraic or statistical result using the multiple values returned from the first cell, as if they were individual values returned by reference to multiple cells of the spreadsheet. In implementations, the spreadsheet function is a preexisting spreadsheet function. It can be a range function or an array function. The syntax of the preexisting spreadsheet function is unchanged by the returning multiple values from the first cell.

## Claims

### Claim 1

An improved method of applying a spreadsheet function running on a system including at least one processor and memory coupled to the processor that operates on values in a list or range of cells the improvement including:
evaluating the list or range on which an improved spreadsheet function operates and identifying a reference to a first cell;
returning from the first cell multiple values stored within that cell; and
applying the spreadsheet function to calculate an algebraic or statistical result using the multiple values returned from the first cell, as if they were individual values returned by reference to multiple cells of the spreadsheet.

### Claim 2 (depends on 1)

The method of claim 1, wherein the spreadsheet function is a preexisting spreadsheet function.

### Claim 3 (depends on 2)

The method of claim 2, wherein the preexisting spreadsheet function is a range function.

### Claim 4 (depends on 2)

The method of claim 2, wherein syntax of the preexisting spreadsheet function is unchanged by the returning from the first cell of the multiple values.

### Claim 5 (depends on 1)

The method of claim 1, wherein applying the preexisting spreadsheet function to the first cell reference does not require any intermediate function to reference the multiple values in the first cell.

### Claim 6 (depends on 1)

The method of claim 1, wherein the multiple values referenced by the first cell are accessed from an external source of Non-spreadsheet cell data.

### Claim 7 (depends on 1)

The method of claim 1, wherein the multiple values referenced by the first cell are accessed from a range of cell data.

### Claim 8

A device including a processor and memory, the memory loaded with instructions that, when executed, cause the processor to carry out an improved method for applying a spreadsheet function running that operates on values in a list or range of cells the improvement including:
evaluating the list or range on which an improved spreadsheet function operates and identifying a reference to a first cell;
returning from the first cell multiple values stored within that cell; and
applying the spreadsheet function to calculate an algebraic or statistical result using the multiple values returned from the first cell, as if they were individual values returned by reference to multiple cells of the spreadsheet.

### Claim 9 (depends on 8)

The device of claim 8, wherein the spreadsheet function is a preexisting spreadsheet function.

### Claim 10 (depends on 9)

The device of claim 9, wherein the preexisting spreadsheet function is a range function.

### Claim 11 (depends on 9)

The device of claim 9, wherein syntax of the preexisting spreadsheet function is unchanged by the returning from the first cell of the multiple values.

### Claim 12 (depends on 8)

The device of claim 8, wherein applying the preexisting spreadsheet function to the first cell reference does not require any intermediate function to reference the multiple values in the first cell.

### Claim 13 (depends on 8)

The device of claim 8, wherein the multiple values referenced by the first cell are accessed from an external source of non-spreadsheet cell data.

### Claim 14 (depends on 8)

The device of claim 8, wherein the multiple values referenced by the first cell are accessed from a range of cell data.

### Claim 15

A tangible computer readable storage media loaded with instructions that, when combined with a hardware device, configures the hardware device to carry out an improved method for applying a spreadsheet function running that operates on values in a list or range of cells the improvement including:
evaluating the list or range on which an improved spreadsheet function operates and identifying a reference to a first cell;
returning from the first cell multiple values stored within that cell; and
applying the spreadsheet function to calculate an algebraic or statistical result using the multiple values returned from the first cell, as if they were individual values returned by reference to multiple cells of the spreadsheet.

### Claim 16 (depends on 15)

The tangible computer readable storage media of claim 15, wherein the spreadsheet function is a preexisting spreadsheet function.

### Claim 17 (depends on 16)

The tangible computer readable storage media of claim 16, wherein the preexisting spreadsheet function is a range function.

### Claim 18 (depends on 16)

The tangible computer readable storage media of claim 16, wherein syntax of the preexisting spreadsheet function is unchanged by the returning from the first cell of the multiple values.

### Claim 19 (depends on 15)

The tangible computer readable storage media of claim 15, wherein applying the preexisting spreadsheet function to the first cell reference does not require any intermediate function to reference the multiple values in the first cell.

### Claim 20 (depends on 15)

The tangible computer readable storage media of claim 15, wherein the multiple values referenced by the first cell are accessed from an external source of non-spreadsheet cell data.

### Claim 21 (depends on 15)

The tangible computer readable storage media of claim 15, wherein the multiple values referenced by the first cell are accessed from a range of cell data.
