User interface for integrated spreadsheets and word processing tables
First 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.
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.
148 Citations
20 Claims
-
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. - View Dependent Claims (2, 3, 4)
-
-
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. - View Dependent Claims (6, 7, 8, 9, 10, 11)
-
-
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. - View Dependent Claims (13, 14, 15, 16, 17)
-
-
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. - View Dependent Claims (19, 20)
-
Specification