System and method for integrating spreadsheets and word processing tables
First Claim
1. An architecture embodied on one or more computer-readable storage media, the architecture comprising:
- a user interface to present a document containing text and a table, wherein the table supports full spreadsheet functionality; and
a table management system to manage how the table appears in the document and to manage spreadsheet functions for the table including automatic recalculation,wherein the bifurcated architecture provides document behavior operations, including one or more of spell checking, grammar checking, find, replace, and text formatting, across table boundaries, such that when invoked, document behavior operations that are applied to the text outside of the table are applied across a table boundary to text inside the 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.
-
Citations
24 Claims
-
1. An architecture embodied on one or more computer-readable storage media, the architecture comprising:
-
a user interface to present a document containing text and a table, wherein the table supports full spreadsheet functionality; and a table management system to manage how the table appears in the document and to manage spreadsheet functions for the table including automatic recalculation, wherein the bifurcated architecture provides document behavior operations, including one or more of spell checking, grammar checking, find, replace, and text formatting, across table boundaries, such that when invoked, document behavior operations that are applied to the text outside of the table are applied across a table boundary to text inside the table. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A method comprising:
-
presenting a table user interface (UI) within a markup language document including text and a table, the table UI containing data and at least one formula referencing the data, wherein the table supports full spreadsheet functionality; creating a cell table to hold the data and formula for the table UI; creating a format table to hold formatting information for the table UI; receiving user input in the table UI; parsing the user input to update the cell table and the format table; in an event the user input changes the data being referenced, automatically recalculating the formula in the cell table to produce a new result; presenting the table UI with the new result; and providing a document behavior operation including one or more of spell checking, grammar checking, find, replace, and text formatting, across table boundaries, such that when invoked, document behavior operations that are applied to the text outside of the table are applied across a table boundary to text inside the table. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16, 17, 18)
-
-
19. A computer readable medium having computer-executable instructions that, when executed on one or more processors, performs the following:
-
construct a table user interface (UI) for display within a document including text and a table, wherein the table supports the full spreadsheet functionality; create a cell table to hold data and at least one formula for the table UI; upon modification of the data, automatically recalculate the formula in the cell table to produce a new result; and provide a document behavior operation including one or more of spell checking, grammar checking, find, replace, and text formatting, across table boundaries, such that when invoked, document behavior operations that are applied to the text outside of the table are applied across a table boundary to text inside the table. - View Dependent Claims (20)
-
-
21. A computer readable medium having computer-executable instructions that, when executed on one or more processors, performs the following:
-
construct a first table user interface (UI) for display within a document including text and table, wherein the table supports full spreadsheet functionality; create a first cell table to hold data for the first table UI; construct a second table user interface (UI) for display within the document; create a second cell table to hold a formula for the second table UI, the formula referencing the data in the first cell table; upon modification of the data in the first cell table, automatically recalculate the formula in the second cell table to produce a new result; and providing a document behavior operation including one or more of spell checking, grammar checking, find, replace, and text formatting, across table boundaries, such that when invoked, document behavior operations that are applied to the text outside of the table are applied across a table boundary to text inside the table. - View Dependent Claims (22)
-
-
23. A computer readable medium having computer-executable instructions that, when executed on one or more processors, performs the following:
-
construct a table user interface (UI) for display within a document containing text and a table, wherein the table supports full spreadsheet functionality; create a first cell table to hold data for the table UI; construct a free floating field for display within the document; create a second cell table to hold a formula for the free floating field, the formula referencing the data in the first cell table; upon modification of the data in the first cell table, automatically recalculate the formula in the second cell table to produce a new result; and provide a document behavior operation including one or more of spell checking, grammar checking, find, replace, and text formatting, across table boundaries, such that when invoked, document behavior operations that are applied to the text outside of the table are applied across a table boundary to text inside the table.
-
-
24. An architecture comprising:
-
a user interface to present a document containing text and a table, wherein the table supports full spreadsheet functionality; and a table management system to manage how the table appears in the document and to manage spreadsheet functions for the table, the table management system comprising; a cell table to maintain data values and formulas used in the table; a delay parser to parse input for the cell table as needed; and a recalculation engine to automatically recalculate the formulas following a change to a data value or formula in the cell table, wherein the bifurcated architecture provides document behavior operations, including one or more of spell checking, grammar checking, find, replace, and text formatting, across table boundaries, such that when invoked, document behavior operations that are applied to the text outside of the table are applied across a table boundary to text inside the table.
-
Specification