User interface for integrated spreadsheets and word processing tables

• US 7,673,227 B2
• Filed: 09/16/2004
• Issued: 03/02/2010
• Est. Priority Date: 06/21/2000
• Status: Expired due to Fees

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Fisher, Oliver G., Kotler, Matthew J., Franklin, Christopher Matthew, Wolf, Richard J., Anantharaman, Vinod, Morgan, Matthew D., Gounares, Alexander G.
• Primary Examiner(s): Hutton; Doug
• Assistant Examiner(s): Tran; Quoc A
• Application Number:
  US10/942,528
• Publication Number:
  US 20050034060A1
• Time in Patent Office: 1,993 Days
• Field of Search: 715/509, 715/514, 715/515, 715204-277
• US Class Current: 715/212
• CPC Class Codes: G06F 40/103 Formatting, i.e. changing of presentation of documents automatic justification G06F40/189; automatic line break hyphenation G06F40/191
• CPC Class Codes: G06F 40/177 of tables; using ruled lines
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation

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

1. An architecture comprising:

a processor;

a memory coupled to the processor; and

one or more modules stored in the memory and executable via the processor, the one or more modules including;

a user interface to present an xml document having text-based body elements and at least one table configured with spreadsheet functions, wherein the user interface is configured to overlay an entry field on a particular cell in the table to facilitate user entry of a formula into the particular cell;

a table appearance manager to;

manage how the table appears in the user interface such that the table resembles a table when not being edited and adds spreadsheet elements to the table when being edited; and

apply one or more common document behaviors selectable via the user interface to both the text-based body elements and across boundaries of the table to text within the table; and

a spreadsheet functionality manager to manage the spreadsheet functions for the table that is presented within the xml document of a particular application.

2. The architecture of claim 1, wherein the table appearance manager comprises:

a table component to support editing functionality of the table; and

a spreadsheet component to receive data and formulas input into the table.

3. The architecture of claim 1, wherein the spreadsheet functionality manager comprises:

a cell table to maintain data values and formulas used in the table; and

a format table to maintain formatting information used in the table.

4. The architecture of claim 1, wherein the spreadsheet functionality manager comprises:

a cell table to maintain data values and formulas used in the table; and

a recalculation engine to recalculate the formulas following a change to a data value or formula in the cell table.

5. The architecture of claim 1, wherein the user interface presents multiple tables, and the spreadsheet functionality manager is configured to track references made from one table to another table.

6. The architecture of claim 1, wherein the user interface presents multiple tables, and the spreadsheet functionality manager is configured to maintain data and formulas for the multiple tables and track references made from one table to another table, the spreadsheet functionality manager being further configured to update any data and formulas in the multiple tables that is affected by a change made to one of the tables.

7. A computer readable medium having computer-executable instructions that, when executed on one or more processors, cause the one or more processors to:

present an xml document having text-based body elements, and tables configured to enable spreadsheet functions, such that the tables appear as tables in the xml document when not being edited and appear with added spreadsheet elements when being edited, the tables being presentable from the xml document of a particular application;

overlay an entry field on a particular cell in at least one table to facilitate user entry of a formula into the particular cell;

apply one or more selectable common document behaviors to both the text-based body elements and across boundaries of the tables to text within the tables;

manage the spreadsheet functions for the tables that are presented including;

create a reference from a first table to contents of a second table; and

upon modification of the contents in the second table, update the first table.

8. The computer readable medium of claim 7, further comprising computer-executable instructions to present a free floating field and create a reference from the free floating field to one of the first and second tables.

9. The computer readable medium of claim 7, further comprising computer-executable instructions to nest the first table within the second table.

10. A method for managing tables, comprising:

presenting an xml document having text-based body elements and tables configured to enable spreadsheet functions, such that the tables appear as tables in the xml document when not being edited and appear with added spreadsheet elements when being edited, the tables being presentable from the xml document of a single integrated application, the xml document created by the single integrated application using integrated word processing and spreadsheet functionality;

overlaying an entry field on a particular cell in at least one table to facilitate user entry of a formula into the particular cell;

applying one or more selectable common document behaviors to both the text-based body elements and across boundaries of the tables to text within the tables;

managing the spreadsheet functions for the tables that are presented including;

creating a reference from the first table to contents of the second table; and

upon modification of the contents in the second table, updating the first table and presenting the updated first table.

11. The method of claim 10, further comprising presenting a free floating field and create a reference from the free floating field to one of the first and second tables.

12. The method of claim 10, further comprising nesting the first table within the second table.

13. The method of claim 10, wherein the one or more selectable common document behaviors include at least spell checking, grammar checking, text formatting, find, and replace.