# US 2004/0210822 A1 · User interface for integrated spreadsheets and word processing tables

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

- Number: US 2004/0210822 A1
- Document ID: US20040210822A1
- Status: Published application
- Kind: A1
- Application number: 10/839,604
- Filed: 2004-05-04
- Published: 2004-10-21
- Earliest claimed: 2000-06-21
- Assignees: Microsoft Corporation
- Inventors: Matthew J. Kotler; Alexander G. Gounares; Oliver G. Fisher; Richard J. Wolf; Vinod Anantharaman; Matthew D. Morgan; Christopher Matthew Franklin
- Web page: https://patentgrep.com/patent/US20040210822A1

## CPC

- G06F 40/18: of spreadsheets (form-filling G06F40/174)
- G06F 40/103: Formatting, i.e. changing of presentation of documents (automatic justification G06F40/189; automatic line break hyphenation G06F40/191)
- G06F 40/177: of tables; using ruled lines
- Y10S 707/99942: Manipulating data structure, e.g. compression, compaction, compilation
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- Y10S: TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS

## Abstract

An architecture integrates spreadsheet functionality into tables commonly used in word processing programs and HTML documents. The architecture presents a table user interface (UI) that resembles a table when not being edited and adds spreadsheet elements to the table when being edited. Underlying the table UI, the architecture separates data handling functions from presentation functions. The architecture includes a table appearance manager to manage how the table appears in a document including such characteristics as table resizing, selection, cut, copy, paste, split, merge, table formatting and so on. The architecture also has a spreadsheet functionality manager to manage the spreadsheet functions for the table, such as recalculation, formula handling, sorting, referencing, and the like. The bifurcated architecture supports cross-table referencing, reference editing, automatic universal recalculation throughout all tables in the document, and nested table structures in which one table is nested within a cell of another table.

## Claims

### Claim 1

A method comprising:
presenting first and second spreadsheet tables, the spreadsheet tables supporting spreadsheet functionality; and
nesting the first table within the second table.

### Claim 2 (depends on 1)

The method of claim 1, further comprising constructing a formula in the second table that references contents in the first table.

### Claim 3 (depends on 2)

The method of claim 2, further comprising, upon modification of the contents in the first table, automatically recalculating the formula in the second table.

### Claim 4 (depends on 1)

A computer readable medium having computer-executable instructions that, when executed on one or more processors, perform the method as recited in claim 1.

### Claim 5

A method comprising:
presenting a table user interface (UI), the table UI resembling a table when not being edited and adding spreadsheet elements to the table when being edited;
enabling a user to enter data and one or more formulas into the table UI; and
upon modification of the data or one or more formulas in the table, automatically recalculating any of the one or more formulas affected by the modification and presenting the table UI with results from the recalculating.

### Claim 6 (depends on 5)

The method of claim 5, wherein the presenting comprises rendering the table UI as an HTML table.

### Claim 7 (depends on 5)

The method of claim 5, further comprising overlaying a formula edit box on the table UI to facilitate user entry of a formula into the table UI.

### Claim 8 (depends on 5)

The method of claim 5, further comprising:
presenting a free floating field user interface (UI); and
enabling a user to enter a formula into the free floating field UI that references contents of the table UI.

### Claim 9 (depends on 8)

The method of claim 8, further comprising upon modification of the contents of the table, automatically recalculating the formula in the free floating field UI.

### Claim 10 (depends on 5)

The method of claim 5, wherein the table UI is a first table UI, and further comprising:
copying the first table UI and pasting to form a second table UI; and
automatically updating the formulas in the first and second table UI to make appropriate references.

### Claim 11 (depends on 5)

A computer readable medium having computer-executable instructions that, when executed on one or more processors, perform the method as recited in claim 5.

### Claim 12

A user interface comprising:
a table residing within a document, the table having multiple cells; and
a formula edit box overlaid on a particular cell in the table to facilitate user entry of a formula into the particular cell.

### Claim 13 (depends on 12)

The user interface of claim 12, wherein the cells are arranged in rows and columns, and the table has row headers to identify the rows of cells and column headers to identify the columns of cells.

### Claim 14 (depends on 12)

The user interface of claim 12, wherein the cells are arranged in rows and columns, and the table has a row addition control for adding one or more rows to the table and a column addition control for adding one or more columns to the table.

### Claim 15 (depends on 12)

The user interface of claim 12, wherein the formula edit box initially defaults to a size and shape of the particular cell in the table.

### Claim 16 (depends on 12)

The user interface of claim 12, wherein the formula edit box dynamically resizes as the user enters the formula.

### Claim 17 (depends on 12)

The user interface of claim 12, wherein the formula edit box extends horizontally and subsequently enlarges vertically as the user enters the formula.

### Claim 18

A user interface comprising:
multiple tables, each table having multiple cells; and
an entry tool to facilitate entry of a formula in a first table that references contents in a second table.

### Claim 19 (depends on 18)

The user interface of claim 18, wherein the entry tool comprises a formula edit box overlaid on a particular cell in the first table to facilitate user entry of the formula into the particular cell.

### Claim 20 (depends on 18)

The user interface of claim 18, wherein the entry tool comprises referencing a particular cell in the second table using a pointer and adding a variable to the formula that references the particular cell.
