# US 2025/0094697 A1 · Non-anonymous functions as arguments in spreadsheet environments

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

- Number: US 2025/0094697 A1
- Document ID: US20250094697A1
- Status: Published application
- Kind: A1
- Application number: 18/471,058
- Filed: 2023-09-20
- Published: 2025-03-20
- Earliest claimed: 2023-09-20
- Assignees: Microsoft Technology Licensing, LLC
- Applicants: Microsoft Technology Licensing, LLC
- Inventors: Joseph John MCDAID; Andrew James BECKER
- Web page: https://patentgrep.com/patent/US20250094697A1

## CPC

- G06F 40/18: of spreadsheets (form-filling G06F40/174)
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Technology is disclosed herein by which a spreadsheet function is accepted as an argument to another function in a spreadsheet. In an implementation, a computing apparatus identifies a formula in a cell, the formula including a first function which has a parameter for the name of a second, non-anonymous function. The computing apparatus passes the function name as an argument to the first function for execution. In executing the first function, the computing apparatus calls the second function and passes a value as an argument to the second function. The computing apparatus updates the spreadsheet based on one or more results of the first function. In an implementation, when the first function calls the second function, the first function iterates through a range of values passed to it as an argument.

## Claims

### Claim 1

A computing apparatus comprising:
one or more computer readable storage media;
one or more processors operatively coupled with the one or more computer readable storage media; and
program instructions stored on the one or more computer readable storage media that, when executed by the one or more processors, direct the computing apparatus to at least:
identify a formula in a cell of a spreadsheet, wherein the formula includes a first function having a parameter comprising a name of a second function, and wherein the second function comprises a non-anonymous function;
pass the name of the second function as an argument to the first function;
execute the first function, wherein the first function calls the second function and passes a value as an argument to the second function; and
populate the spreadsheet based on one or more results of the first function.

### Claim 2 (depends on 1)

The computing apparatus of claim 1, wherein the first function also has a parameter comprising a range, wherein the program instructions further direct the computing apparatus to pass the range as an argument to the first function, and wherein the value comprises a value from the range.

### Claim 3 (depends on 2)

The computing apparatus of claim 2, wherein the formula follows a syntax comprising: a name of a function followed by a list of parameters captured parenthetically after the name of the function, and wherein one parameter in the list of parameters identifies another function to be passed as an argument to the function along with at least one other of the list of parameters.

### Claim 4 (depends on 3)

The computing apparatus of claim 3, wherein the first function, when calling the second function, iterates through the range passed to it as an argument and, for each iteration through the range, calls the second function and passes one or more values from the range that differ relative to each other iteration through the range.

### Claim 5 (depends on 4)

The computing apparatus of claim 4, wherein the list of parameters comprises a conditional expression, and wherein the first function, when calling the second function, passes the value in the range to the second function if the value satisfies the conditional expression.

### Claim 6 (depends on 1)

The computing apparatus of claim 1, wherein the parameters do not include a LAMBDA function and wherein the range comprises a group of cells in the spreadsheet.

### Claim 7 (depends on 6)

The computing apparatus of claim 6, wherein the first function comprises a BYCOL function and wherein the second function comprises one of a native function and a user-defined function of a spreadsheet application.

### Claim 8 (depends on 1)

The computing apparatus of claim 1, wherein a syntax of the parameters requires a cell range and a name but does not require any parameters to be explicitly included for the second function.

### Claim 9

A method of operating a spreadsheet application, comprising:
receiving a formula in a cell of a spreadsheet;
identifying, in the formula, a first function having a parameter comprising a name of a second function, wherein the second function comprises a non-anonymous function;
passing the name of the second function as an argument to the first function;
executing the first function, wherein the first function calls the second function and passes a value as an argument to the second function; and
populating the spreadsheet based on one or more results of the first function.

### Claim 10 (depends on 9)

The method of claim 9, wherein the first function also has a parameter comprising a range, wherein the method further comprises passing the range as an argument to the first function, and wherein the value comprises a value from the range.

### Claim 11 (depends on 10)

The method of operating the spreadsheet application of claim 10, wherein the formula follows a syntax comprising: a name of a function followed by a list of parameters captured parenthetically after the name of the function, and wherein one parameter in the list of parameters identifies another function to be passed as an argument to the function along with at least one other of the list of parameters.

### Claim 12 (depends on 11)

The method of operating the spreadsheet application of claim 11, wherein the first function, when calling the second function, iterates through the range passed to it as an argument and, for each iteration through the range, calls the second function and passes one or more values from the range that differs relative to each other iteration through the range.

### Claim 13 (depends on 12)

The method of operating the spreadsheet application of claim 12, wherein the list of parameters comprises a conditional expression, and wherein the first function, when calling the second function, passes a value in a range of values to the second function if the value satisfies the conditional expression.

### Claim 14 (depends on 9)

The method of operating the spreadsheet application of claim 9, wherein the parameters do not include a LAMBDA function and wherein the range comprises a group of cells in the spreadsheet.

### Claim 15 (depends on 14)

The method of operating the spreadsheet application of claim 14, wherein the first function comprises a BYCOL function and wherein the second function comprises one of a native function and a user-defined function of the spreadsheet application.

### Claim 16 (depends on 9)

The method of operating the spreadsheet application of claim 9, wherein a syntax of the parameters requires a range and a name but does not require any parameters to be explicitly included for the second function.

### Claim 17

One or more computer readable storage media having program instructions stored thereon that, when executed by one or more processors of a computing device, direct the computing device to at least:
identify a formula in a cell of a spreadsheet, wherein the formula includes a first function having parameters comprising a range and a name of a second function, and wherein the second function comprises a non-anonymous function;
pass the range and the name of the second function as arguments to the first function;
execute the first function, wherein the first function calls the second function and passes a value from the range as an argument to the second function; and
populate the spreadsheet based on one or more results of the first function.

### Claim 18 (depends on 17)

The one or more computer readable storage media of claim 17, wherein the formula follows a syntax comprising: a name of a function followed by a list of parameters captured parenthetically after the name of the function, and wherein one parameter in the list of parameters identifies another function to be passed as an argument to the function along with at least one other of the list of parameters.

### Claim 19 (depends on 18)

The one or more computer readable storage media of claim 18, wherein the first function, when calling the second function, iterates through the range passed to it as an argument and, for each iteration through the range, calls the second function and passes one or more values from the range that differ relative to each other iteration through the range.

### Claim 20 (depends on 19)

The one or more computer readable storage media of claim 19, wherein the list of parameters comprises a conditional expression, and wherein the first function, when calling the second function, passes the value in the range to the second function if the value satisfies the conditional expression.
