公开(公告)号：US07155667B1

公开(公告)日：2006-12-26

申请号：US09599810

申请日：2000-06-21

申请人： Matthew J. Kotler ,  Alexander G. Gounares ,  Oliver G. Fisher ,  Richard J. Wolf ,  Vinod Anantharaman ,  Matthew D. Morgan ,  Christopher Matthew Franklin

发明人： Matthew J. Kotler ,  Alexander G. Gounares ,  Oliver G. Fisher ,  Richard J. Wolf ,  Vinod Anantharaman ,  Matthew D. Morgan ,  Christopher Matthew Franklin

IPC分类号： G06F15/00

CPC分类号： G06F17/246 ,  G06F17/211 ,  G06F17/245 ,  Y10S707/99942

摘要： 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.

摘要翻译： 一个架构将电子表格功能集成到通常用于文字处理程序和HTML文档的表格中。 该体系结构提供了一个表用户界面（UI），在不被编辑时类似于表，并在编辑时将表格元素添加到表中。 在表UI的基础上，架构将数据处理功能与演示功能分离开来。 该架构包括一个表格外观管理器，用于管理表格如何显示在文档中，包括诸如表格大小，选择，剪切，复制，粘贴，拆分，合并，表格格式化等特性。 架构还具有一个电子表格功能管理器来管理表的电子表格功能，如重新计算，公式处理，排序，引用等。 分支架构支持跨表参考，参考编辑，文档中所有表中的自动通用重新计算，以及嵌套表结构，其中一个表嵌套在另一个表的单元格中。

公开(公告)号：US07350141B2

公开(公告)日：2008-03-25

申请号：US10942527

申请日：2004-09-16

申请人： Matthew J. Kotler ,  Alexander G. Gounares ,  Oliver G. Fisher ,  Richard J. Wolf ,  Vinod Anantharaman ,  Matthew D. Morgan ,  Christopher Matthew Franklin

发明人： Matthew J. Kotler ,  Alexander G. Gounares ,  Oliver G. Fisher ,  Richard J. Wolf ,  Vinod Anantharaman ,  Matthew D. Morgan ,  Christopher Matthew Franklin

IPC分类号： G06F15/00

CPC分类号： G06F17/246 ,  G06F17/211 ,  G06F17/245 ,  Y10S707/99942

摘要： 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.

公开(公告)号：US07673227B2

公开(公告)日：2010-03-02

申请号：US10942528

申请日：2004-09-16

申请人： Matthew J. Kotler ,  Alexander G. Gounares ,  Oliver G. Fisher ,  Richard J. Wolf ,  Vinod Anantharaman ,  Matthew D. Morgan ,  Christopher Matthew Franklin

发明人： Matthew J. Kotler ,  Alexander G. Gounares ,  Oliver G. Fisher ,  Richard J. Wolf ,  Vinod Anantharaman ,  Matthew D. Morgan ,  Christopher Matthew Franklin

IPC分类号： G06F17/00

CPC分类号： G06F17/246 ,  G06F17/211 ,  G06F17/245 ,  Y10S707/99942

摘要： 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.

摘要翻译： 一个架构将电子表格功能集成到通常用于文字处理程序和HTML文档的表格中。 该体系结构提供了一个表用户界面（UI），在不被编辑时类似于表，并在编辑时将表格元素添加到表中。 在表UI的基础上，架构将数据处理功能与演示功能分离开来。 该架构包括一个表格外观管理器，用于管理表格如何显示在文档中，包括诸如表格大小，选择，剪切，复制，粘贴，拆分，合并，表格格式化等特性。 架构还具有一个电子表格功能管理器来管理表的电子表格功能，如重新计算，公式处理，排序，引用等。 分支架构支持跨表参考，参考编辑，文档中所有表中的自动通用重新计算，以及嵌套表结构，其中一个表嵌套在另一个表的单元格中。

公开(公告)号：US07549115B2

公开(公告)日：2009-06-16

申请号：US10961947

申请日：2004-10-08

申请人： Matthew J. Kotler ,  Vinod Anantharaman ,  Christopher Matthew Franklin ,  Oliver G. Fisher ,  Alexander G. Gounares ,  Matthew D. Morgan ,  Richard J. Wolf

发明人： Matthew J. Kotler ,  Vinod Anantharaman ,  Christopher Matthew Franklin ,  Oliver G. Fisher ,  Alexander G. Gounares ,  Matthew D. Morgan ,  Richard J. Wolf

IPC分类号： G06F15/00 ,  G06F17/00

CPC分类号： G06F17/245 ,  G06F17/246 ,  Y10S707/99931

摘要： 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.

摘要翻译： 一个架构将电子表格功能集成到通常用于文字处理程序和HTML文档的表格中。 该体系结构提供了一个表用户界面（UI），在不被编辑时类似于表，并在编辑时将表格元素添加到表中。 在表UI的基础上，架构将数据处理功能与演示功能分离开来。 该架构包括一个表格外观管理器，用于管理表格如何显示在文档中，包括诸如表格大小，选择，剪切，复制，粘贴，拆分，合并，表格格式化等特性。 架构还具有一个电子表格功能管理器来管理表的电子表格功能，如重新计算，公式处理，排序，引用等。 分支架构支持跨表参考，参考编辑，文档中所有表中的自动通用重新计算，以及嵌套表结构，其中一个表嵌套在另一个表的单元格中。

公开(公告)号：US07506242B2

公开(公告)日：2009-03-17

申请号：US10961283

申请日：2004-10-08

申请人： Matthew J. Kotler ,  Alexander G. Gounares ,  Oliver G. Fisher ,  Richard J. Wolf ,  Vinod Anantharaman ,  Matthew D. Morgan ,  Christopher Matthew Franklin

发明人： Matthew J. Kotler ,  Alexander G. Gounares ,  Oliver G. Fisher ,  Richard J. Wolf ,  Vinod Anantharaman ,  Matthew D. Morgan ,  Christopher Matthew Franklin

IPC分类号： G06F15/00 ,  G06F17/00

CPC分类号： G06F17/245 ,  G06F17/246 ,  Y10S707/99931

摘要： 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.

公开(公告)号：US07412645B2

公开(公告)日：2008-08-12

申请号：US10839604

申请日：2004-05-04

申请人： Matthew J. Kotler ,  Alexander G. Gounares ,  Oliver G. Fisher ,  Richard J. Wolf ,  Vinod Anantharaman ,  Matthew D. Morgan ,  Christopher Matthew Franklin

发明人： Matthew J. Kotler ,  Alexander G. Gounares ,  Oliver G. Fisher ,  Richard J. Wolf ,  Vinod Anantharaman ,  Matthew D. Morgan ,  Christopher Matthew Franklin

IPC分类号： G06F17/00

CPC分类号： G06F17/246 ,  G06F17/211 ,  G06F17/245 ,  Y10S707/99942

摘要： 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.

摘要翻译： 一个架构将电子表格功能集成到通常用于文字处理程序和HTML文档的表格中。 该体系结构提供了一个表用户界面（UI），在不被编辑时类似于表，并在编辑时将表格元素添加到表中。 在表UI的基础上，架构将数据处理功能与演示功能分离开来。 该架构包括一个表格外观管理器，用于管理表格如何显示在文档中，包括诸如表格大小，选择，剪切，复制，粘贴，拆分，合并，表格格式化等特性。 架构还具有一个电子表格功能管理器来管理表的电子表格功能，如重新计算，公式处理，排序，引用等。 分支架构支持跨表参考，参考编辑，文档中所有表中的自动通用重新计算，以及嵌套表结构，其中一个表嵌套在另一个表的单元格中。

公开(公告)号：US07506243B2

公开(公告)日：2009-03-17

申请号：US10962251

申请日：2004-10-09

申请人： Matthew J. Kotler ,  Alexander G. Gounares ,  Oliver G. Fisher ,  Richard J. Wolf ,  Vinod G. Anantharaman ,  Matthew D. Morgan ,  Christopher Matthew Franklin

发明人： Matthew J. Kotler ,  Alexander G. Gounares ,  Oliver G. Fisher ,  Richard J. Wolf ,  Vinod G. Anantharaman ,  Matthew D. Morgan ,  Christopher Matthew Franklin

IPC分类号： G06F17/00

CPC分类号： G06F17/245 ,  G06F17/246 ,  Y10S707/99931

摘要： 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.

摘要翻译： 一个架构将电子表格功能集成到通常用于文字处理程序和HTML文档的表格中。 该体系结构提供了一个表用户界面（UI），在不被编辑时类似于表，并在编辑时将表格元素添加到表中。 在表UI的基础上，架构将数据处理功能与演示功能分离开来。 该架构包括一个表格外观管理器，用于管理表格如何显示在文档中，包括诸如表格大小，选择，剪切，复制，粘贴，拆分，合并，表格格式化等特性。 架构还具有一个电子表格功能管理器来管理表的电子表格功能，如重新计算，公式处理，排序，引用等。 分支架构支持跨表参考，参考编辑，文档中所有表中的自动通用重新计算，以及嵌套表结构，其中一个表嵌套在另一个表的单元格中。

公开(公告)号：US07523390B2

公开(公告)日：2009-04-21

申请号：US10961313

申请日：2004-10-08

申请人： Matthew J. Kotler ,  Alexander G. Gounares ,  Oliver G. Fisher ,  Matthew D. Morgan ,  Christopher Matthew Franklin

发明人： Matthew J. Kotler ,  Alexander G. Gounares ,  Oliver G. Fisher ,  Matthew D. Morgan ,  Christopher Matthew Franklin

IPC分类号： G06F17/00 ,  G06F15/00

CPC分类号： G06F17/246 ,  G06F17/211

摘要： A system architecture integrates spreadsheet functionality into text. The architecture allows insertion of discrete individual fields, referred to as “free floating fields”, inline with normal textual sentences. In an HTML document, for example, the free floating fields are elements constructed along with text elements and rendered together as an integrated document. Once rendered, the free floating fields present contents that resemble normal text consistent with the surrounding text. The free floating fields offer spreadsheet functionality, including the ability to handle complex formulas, reference values in a separate free floating field or table, and automatically recalculate the formulas when a source value changes.

摘要翻译： 系统架构将电子表格功能集成到文本中。 该架构允许插入被称为“自由浮动字段”的离散个别字段，与正常文本句子一致。 例如，在HTML文档中，自由浮动字段是与文本元素一起构建的元素，并作为集成文档一起呈现。 渲染后，自由浮动字段会显示与正文文本一致的内容。 自由浮动字段提供电子表格功能，包括处理复杂公式的能力，单独的自由浮动字段或表中的引用值，以及当源值更改时自动重新计算公式。

公开(公告)号：US20090083615A1

公开(公告)日：2009-03-26

申请号：US12323832

申请日：2008-11-26

申请人： Matthew J. Kotler ,  Alexander G. Gounares ,  Oliver G. Fisher ,  Matthew D. Morgan ,  Christopher Matthew Franklin

发明人： Matthew J. Kotler ,  Alexander G. Gounares ,  Oliver G. Fisher ,  Matthew D. Morgan ,  Christopher Matthew Franklin

IPC分类号： G06F17/00

CPC分类号： G06F17/246 ,  G06F17/211

摘要： A system architecture integrates spreadsheet functionality into text. The architecture allows insertion of discrete individual fields, referred to as “free floating fields”, inline with normal textual sentences. In an HTML document, for example, the free floating fields are elements constructed along with text elements and rendered together as an integrated document. Once rendered, the free floating fields present contents that resemble normal text consistent with the surrounding text. The free floating fields offer spreadsheet functionality, including the ability to handle complex formulas, reference values in a separate free floating field or table, and automatically recalculate the formulas when a source value changes.

摘要翻译： 系统架构将电子表格功能集成到文本中。 该架构允许插入被称为“自由浮动字段”的离散个别字段，与正常文本句子一致。 例如，在HTML文档中，自由浮动字段是与文本元素一起构建的元素，并作为集成文档一起呈现。 渲染后，自由浮动字段会显示与正文文本一致的内容。 自由浮动字段提供电子表格功能，包括处理复杂公式的能力，单独的自由浮动字段或表中的引用值，以及当源值更改时自动重新计算公式。

公开(公告)号：US07702998B2

公开(公告)日：2010-04-20

申请号：US12323832

申请日：2008-11-26

申请人： Matthew J. Kotler ,  Alexander G. Gounares ,  Oliver G. Fisher ,  Matthew D. Morgan ,  Christopher Matthew Franklin

发明人： Matthew J. Kotler ,  Alexander G. Gounares ,  Oliver G. Fisher ,  Matthew D. Morgan ,  Christopher Matthew Franklin

IPC分类号： G06F15/00

CPC分类号： G06F17/246 ,  G06F17/211

摘要： A system architecture integrates spreadsheet functionality into text. The architecture allows insertion of discrete individual fields, referred to as “free floating fields”, inline with normal textual sentences. In an HTML document, for example, the free floating fields are elements constructed along with text elements and rendered together as an integrated document. Once rendered, the free floating fields present contents that resemble normal text consistent with the surrounding text. The free floating fields offer spreadsheet functionality, including the ability to handle complex formulas, reference values in a separate free floating field or table, and automatically recalculate the formulas when a source value changes.

摘要翻译： 系统架构将电子表格功能集成到文本中。 该架构允许插入被称为“自由浮动字段”的离散个别字段，与正常文本句子一致。 例如，在HTML文档中，自由浮动字段是与文本元素一起构建的元素，并作为集成文档一起呈现。 渲染后，自由浮动字段会显示与正文文本一致的内容。 自由浮动字段提供电子表格功能，包括处理复杂公式的能力，单独的自由浮动字段或表中的引用值，以及当源值更改时自动重新计算公式。