# US 2026/0064665 A1 · Spreadsheet with Dynamic Database Queries

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

- Number: US 2026/0064665 A1
- Document ID: US20260064665A1
- Status: Published application
- Kind: A1
- Application number: 19/383,346
- Filed: 2025-11-07
- Published: 2026-03-05
- Earliest claimed: 2019-09-13
- Assignees: ClearFactr, Inc.
- Applicants: ClearFactr, Inc.
- Inventors: Dean Andrew Zarras
- Web page: https://patentgrep.com/patent/US20260064665A1

## CPC

- G06F 16/2379: {Updates performed during online database operations; commit processing}
- G06F 16/2457: with adaptation to user needs
- G06F 16/245: Query processing
- G06F 16/24553: {of query operations}
- G06F 16/248: Presentation of query results
- G06F 16/283: {Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP}
- G06F 40/18: of spreadsheets (form-filling G06F40/174)
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A spreadsheet supports formulas in cells that trigger queries of a data source. The parameters for queries can include or depend on values in other cells in the spreadsheet. Thus, the precise query submitted to the data source is dynamic, being dependent on the data and formulas in the spreadsheet. Furthermore, on receiving the query results, they are added to cells in the spreadsheet, which can be parameters for other queries defined in other cells. Changing the value of a single cell can automatically trigger an update of an arbitrarily deep hierarchy of calculations that can include an arbitrary number of data source queries.

## Claims

### Claim 1

A method of updating a spreadsheet using a dynamic database query, the method comprising:
receiving a request to update a specified cell in the spreadsheet, the request including a value or formula for the specified cell;
updating the specified cell to include the value or formula;
identifying additional cells that depend on the specified cell;
obtaining a dependency hierarchy for the additional cells;
updating the additional cells according to the dependency hierarchy, wherein updating a first cell of the additional cells comprises dynamically defining a data source query using a current value of another cell in the spreadsheet and updating the first cell to include a result returned by the data source query; and
providing the spreadsheet for display.
