专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US07415481B2 Method and implementation for referencing of dynamic data within spreadsheet formulas 有权
标题翻译：在电子表格公式中引用动态数据的方法和实现
公开(公告)号：US07415481B2
公开(公告)日：2008-08-19
申请号：US10956940
申请日：2004-09-30
申请人： Andrew J. Becker , Charles D. Ellis , Joseph M. Chirilov , Juha P. Niemisto , Matthew J. Androski , Robert C. Collie , Robert G. Hawking , Simon Peyton-Jones , Weide Zhong
发明人： Andrew J. Becker , Charles D. Ellis , Joseph M. Chirilov , Juha P. Niemisto , Matthew J. Androski , Robert C. Collie , Robert G. Hawking , Simon Peyton-Jones , Weide Zhong
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/246 , Y10S707/99943
摘要： The present invention relates to a new type of structured name within a spreadsheet program that allows users to refer to tables, columns of data within tables, headers of tables, totals from tables, PivotTables®, and portions of PivotTable® data by the data's headers. Embodiments of the present invention comprise a method for referring to a set of data that comprises receiving one or more semantic designations, wherein the one or more semantic designations name a set of context information that describes one or more items of data in a data structure, automatically creating a structural reference, and associating the context information with the structural reference. Other embodiments of the present invention relate to an interaction with a user interface for displaying on a display device a structural reference to data in a spreadsheet that comprises receiving one or more semantic designations from the user that refer to one or more elements of the data structure, creating a structural reference to the elements of the data structure, and displaying the structural reference as a collection of the one or more semantic designations.
摘要翻译：本发明涉及电子表格程序中的新型结构化名称，其允许用户参考表格中的表，数据列，表的表，表中的总计，数据透视表（RIV）以及数据透视表数据的部分通过数据的标题。本发明的实施例包括用于参考包括接收一个或多个语义指定的一组数据的方法，其中所述一个或多个语义指定命名描述数据结构中的一个或多个数据项的一组上下文信息，自动创建结构参考，并将上下文信息与结构参考相关联。本发明的其他实施例涉及与用户界面的交互，用于在显示设备上显示对电子表格中的数据的结构参考，其包括从用户接收一个或多个参考数据结构的一个或多个元素的语义指定，创建对数据结构的元素的结构参考，以及将结构引用显示为一个或多个语义指定的集合。

2. 发明授权

US07698287B2 Design of spreadsheet functions for working with tables of data 有权
标题翻译：设计用于处理数据表的电子表格功能
公开(公告)号：US07698287B2
公开(公告)日：2010-04-13
申请号：US10957502
申请日：2004-09-30
申请人： Andrew J. Becker , Charles D. Ellis , Joseph M. Chirilov , Juha P. Niemisto , Matthew J. Androski , Robert C. Collie , Robert G. Hawking , Simon Peyton-Jones
发明人： Andrew J. Becker , Charles D. Ellis , Joseph M. Chirilov , Juha P. Niemisto , Matthew J. Androski , Robert C. Collie , Robert G. Hawking , Simon Peyton-Jones
IPC分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/246 , Y10S707/99942
摘要： The present invention provides several database formulas that can manipulate large sets of data. Each database formula is customizable and repeatable without user intervention. Thus, users may enter numerous options that can cover the user's desire for data output in certain forms or formats, select a set of input data, and consistently receive a set of output data. In some embodiments, the user may refer to the set of data semantically instead of specifying a range of cells to use in the database formula. Referring to the data semantically allows the database formulas to adjust to changes in the range of cells new data may occupy.
摘要翻译：本发明提供了可以操纵大量数据的几种数据库公式。每个数据库公式是可自定义和可重复的，无需用户干预。因此，用户可以输入许多选项，其可以覆盖用户对某些形式或格式的数据输出的期望，选择一组输入数据，并且一致地接收一组输出数据。在一些实施例中，用户可以在语义上引用该组数据，而不是指定要在数据库公式中使用的单元格的范围。参考数据语义上允许数据库公式适应新数据可能占用的单元格范围内的变化。

3. 发明授权

US08161372B2 Extensible value types in cells 有权
标题翻译：单元格中的可扩展值类型
公开(公告)号：US08161372B2
公开(公告)日：2012-04-17
申请号：US11297991
申请日：2005-12-09
申请人： Charles D. Ellis , Matthew J. Androski , Robert G. Hawking , Simon Peyton Jones
发明人： Charles D. Ellis , Matthew J. Androski , Robert G. Hawking , Simon Peyton Jones
IPC分类号： G06F17/00
CPC分类号： G06F17/246
摘要： Individual cells within a spreadsheet may contain an extensible value as defined by an extensible value type. The extensible value type is a user defined value type that is incorporated into the spreadsheet as a supported data type. Generally, the extensible data types provide support for types that are not internally defined by a spreadsheet. When the extensible value type is defined, an associated set of functions are developed to operate on the type. These functions are added to the set of base functions supported by the spreadsheet. The functions, therefore, behave in a substantially similar manner to the set of base spreadsheet functions. The extensible values that are contained within the cells may be acted upon in the same way that supported base types are acted upon.
摘要翻译：电子表格中的单个单元格可能包含由可扩展值类型定义的可扩展值。可扩展值类型是作为支持的数据类型合并到电子表格中的用户定义的值类型。通常，可扩展数据类型为电子表格内部未定义的类型提供支持。当定义可扩展值类型时，开发一组相关的函数来对类型进行操作。这些功能被添加到电子表格支持的一组基本功能中。因此，这些功能与基本电子表格功能的集合基本相似。包含在单元格内的可扩展值可以以与所支持的基本类型作用相同的方式起作用。

4. 发明授权

US08726143B2 System and method for a spreadsheet application supporting diverse formulaic functions 有权
标题翻译：支持多种公式功能的电子表格应用程序的系统和方法
公开(公告)号：US08726143B2
公开(公告)日：2014-05-13
申请号：US11036500
申请日：2005-01-14
申请人： Roy Simkhay , Charles D. Ellis , Alexander Babanov , David F. Gainer , Daniel P. Cory , Matthew J. Androski , Andrew J. Becker , Jeremy R. Pankratz , Monica McAmis , Simon Loftus Peyton Jones
发明人： Roy Simkhay , Charles D. Ellis , Alexander Babanov , David F. Gainer , Daniel P. Cory , Matthew J. Androski , Andrew J. Becker , Jeremy R. Pankratz , Monica McAmis , Simon Loftus Peyton Jones
IPC分类号： G06F17/00
CPC分类号： G06F17/246
摘要： A spreadsheet application or other application supporting formulaic cells that automatically provides support for a number of diverse formulaic functions. The automatically provided diverse formulaic functions include a function returning the value of the formula logic if the logic can be evaluated without an error. Another function finds a value in a formulaic cell that is in the same row as a particular value from the first column and the same column as a particular value in the first row. Other functions allow a selection of a set of multiple lookup rows and columns for matching the values used as variables in the function. The spreadsheet application is further configured to automatically supply other functions in addition to those described.
摘要翻译：电子表格应用程序或支持公式单元格的其他应用程序，可自动为多种公式功能提供支持。自动提供的各种公式函数包括一个返回公式逻辑值的函数，如果逻辑可以被评估而没有错误。另一个函数在公式单元格中找到与第一列中特定值相同的行中的值，并且与第一行中的特定值相同的列。其他功能允许选择一组多个查找行和列，以匹配用作函数中的变量的值。电子表格应用程序还被配置为自动提供除了所描述的功能之外的其他功能。

5. 发明授权

US08032821B2 Multi-thread spreadsheet processing with dependency levels 有权
标题翻译：具有依赖关系级别的多线程电子表格处理
公开(公告)号：US08032821B2
公开(公告)日：2011-10-04
申请号：US11430486
申请日：2006-05-08
申请人： Jeffrey J. Duzak , Andrew Becker , Matthew J. Androski , Duane Campbell
发明人： Jeffrey J. Duzak , Andrew Becker , Matthew J. Androski , Duane Campbell
IPC分类号： G06F17/12
CPC分类号： G06F17/246 , G06F9/5066
摘要： This disclosure relates to a method and system of processing chain calculations in spreadsheet applications utilizing multiple processors, each having a separate recalculation engine. A single calculation chain may be reordered into a unified chain where supporting and dependent formulas are organized into a tree hierarchy of child chains. The unified chain is further divided into dependency levels, where entries in each dependency level may be moved to a next dependency level during reordering. If an entry within a dependency level is dependent upon another entry not found within its own child chain, the unified chain is ordered such that an entry is only dependent upon an entry in a prior dependency level. Further, dependency levels allow a control thread to perform control-thread-only operations while maintaining multi-thread processing capabilities.
摘要翻译：本公开涉及一种使用多个处理器的电子表格应用程序中处理链计算的方法和系统，每个处理器具有单独的重新计算引擎。单个计算链可以重新排序成统一的链，其中支持和依赖公式被组织成儿童链的树层次结构。统一链进一步分为依赖关系级别，每个依赖关系级别中的条目可能在重排序期间移动到下一个依赖关系级别。如果依赖关系级别中的条目取决于在其自己的子链中未找到的另一个条目，则统一链被排序，使得条目仅依赖于先前的依赖关系级别中的条目。此外，依赖关系级别允许控制线程在维护多线程处理能力的同时执行控制线程操作。

6. 发明授权

US07533139B2 Method and system for multithread processing of spreadsheet chain calculations 有权
标题翻译：电子表格链计算的多线程处理方法和系统
公开(公告)号：US07533139B2
公开(公告)日：2009-05-12
申请号：US10951576
申请日：2004-09-27
申请人： Bruce Cordell Jones , Chad B. Rothschiller , David F. Gainer , Jeffrey J. Duzak , Matthew J. Androski , Duane Campbell
发明人： Bruce Cordell Jones , Chad B. Rothschiller , David F. Gainer , Jeffrey J. Duzak , Matthew J. Androski , Duane Campbell
IPC分类号： G06F7/00
CPC分类号： G06F9/505 , G06F17/246
摘要： Embodiments of the invention involve a method of concurrent processing of chain calculations using multiple processors each having a separate recalculation engine in a spreadsheet program. The operations basically include first determining a number of available processors, then allocating a recalculation engine to each available processor, distributing the formulas between the recalculation engines, and then concurrently evaluating the formulas distributed to each recalculation engine when a recalc operation is called for in the spreadsheet program.
摘要翻译：本发明的实施例涉及一种使用多个处理器并行处理链计算的方法，每个处理器在电子表格程序中具有单独的重新计算引擎。这些操作基本上包括首先确定可用处理器的数量，然后将重新计算引擎分配给每个可用的处理器，在重新计算引擎之间分配公式，然后在重新计算引擎中调用重新计算操作时同时评估分配给每个重新计算引擎的公式电子表格程序。

7. 发明授权

US07237186B2 Exiting a spreadsheet edit mode during a mouse drag operation 失效
标题翻译：在鼠标拖动操作期间退出电子表格编辑模式
公开(公告)号：US07237186B2
公开(公告)日：2007-06-26
申请号：US10286275
申请日：2002-10-31
申请人： Matthew J. Androski , Mark S. Igra , Kent R. Lowry , Brian Frank , Jeanell D. Sullivan , Justin M. Maguire, III
发明人： Matthew J. Androski , Mark S. Igra , Kent R. Lowry , Brian Frank , Jeanell D. Sullivan , Justin M. Maguire, III
IPC分类号： G06F15/00
CPC分类号： G06F17/246
摘要： A user can click on a spreadsheet cell to enter edit mode and alter the contents of the cell. Edit mode can be exited through a click and drag maneuver. The click and drag maneuver not only exits edit mode, but also selects a range of cells. The click and drag is performed by depressing a mouse button while the mouse indicator is positioned Over the edit cell, moving the mouse while holding the mouse button depressed, and releasing the mouse button when the end of the desired range of cells is reached. The range of selected cells starts with the edit cell and continues to the cell over which the mouse indicator was positioned when the mouse button was released.
摘要翻译：用户可以点击电子表格单元格进入编辑模式并更改单元格的内容。编辑模式可以通过点击和拖动操作退出。单击和拖动操作不仅退出编辑模式，还可以选择一系列单元格。鼠标指针定位时按住鼠标按钮可以执行点击和拖动在编辑单元格的上方，按住鼠标按钮的同时移动鼠标，并在达到所需单元格范围结束时释放鼠标按钮。所选单元格的范围从编辑单元开始，并在鼠标按钮被释放时继续到鼠标指示器所在的单元格。

8. 发明授权

US06549878B1 System and method for editing a spreadsheet via an improved editing and cell selection model 失效
公开(公告)号：US06549878B1
公开(公告)日：2003-04-15
申请号：US09223864
申请日：1998-12-31
申请人： Kent R. Lowry , Mark S. Igra , Brian Frank , Jeanell D. Sullivan , Justin M. Maguire, III , Matthew J. Androski
发明人： Kent R. Lowry , Mark S. Igra , Brian Frank , Jeanell D. Sullivan , Justin M. Maguire, III , Matthew J. Androski
IPC分类号： G06F1721
CPC分类号： G06F17/246
摘要： Editing cells within a spreadsheet to change the contents of a spreadsheet. To enter edit mode and alter the contents of a cell, the user first selects a cell by single clicking a mouse button while the mouse indicator is positioned above the cell. The user then initiates another single click when the mouse indicator is positioned above the selected cell. Once edit mode is active, the user may change the contents of the cell from within the web browser window as desired. Edit mode can be exited through one of three methods: an “exit and save” signal, an “exit and discard” signal, or a click and drag maneuver. The exit and save signal prompts the invention to save all changes to the cell that the user has made. The exit and discard signal prompts the invention to discard any changes made to the cell by the user, revert to the pre-edit mode contents of the edit cell, and exit edit mode. Finally, a click and drag maneuver not only exits edit mode, but selects a range of cells. The click and drag is performed by depressing a mouse button while the mouse indicator is positioned over the edit cell, moving the mouse while holding the mouse button depressed, and releasing the mouse button when the end of the desired range of cells is reached. The range of cells selected will then start with the edit cell and continue to the cell over which the mouse indicator was positioned when the mouse button was released.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式