System and method for integrating spreadsheets and word processing tables
First Claim
1. A method comprising:
- presenting first and second tables within a document, wherein the first table has a cell with contents; and
referencing the cell in the first table from a cell in the second table.
1 Assignment
0 Petitions
Accused Products
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.
168 Citations
25 Claims
-
1. A method comprising:
-
presenting first and second tables within a document, wherein the first table has a cell with contents; and
referencing the cell in the first table from a cell in the second table. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. One or more computer-readable media comprising computer-executable instructions for integrating spreadsheet functionality into tables, the computer-executable instructions comprising instructions for:
-
integrating text and tables into a document;
referencing a cell located in a first of the tables from a cell in a second of the tables;
providing column headers and row headers during editing of a table within the document, and not providing such headers at other times; and
providing automatic universal recalculation in response to the editing. - View Dependent Claims (9, 10, 11, 12, 13)
-
-
14. One or more computer-readable media comprising computer-executable instructions for integrating spreadsheet functionality into tables used in word processing and markup language documents, the computer-executable instructions comprising instructions for:
-
integrating text and tables into a document;
referencing content in a first of the tables from a second of the tables, wherein the first table is nested within the second table within the document; and
providing automatic universal recalculation in response to changes in the document. - View Dependent Claims (15, 16, 17, 18, 19)
-
-
20. A spreadsheet architecture for providing spreadsheet functionality to tables, comprising:
-
a document renderer configured to integrate text and tables into a document;
a spreadsheet engine configured to reference content in a first of the tables from a second of the tables, wherein the first table is nested within the second table; and
a recalculation engine configured to provide automatic universal recalculation in response to changes in the document. - View Dependent Claims (21, 22, 23, 24, 25)
-
Specification