利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

8 条记录 (耗时 0.066 秒)

    Method and implementation for referencing of dynamic data within spreadsheet formulas
    1.
    发明授权
    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）以及数据透视表数据的部分 通过数据的标题。 本发明的实施例包括用于参考包括接收一个或多个语义指定的一组数据的方法，其中所述一个或多个语义指定命名描述数据结构中的一个或多个数据项的一组上下文信息， 自动创建结构参考，并将上下文信息与结构参考相关联。 本发明的其他实施例涉及与用户界面的交互，用于在显示设备上显示对电子表格中的数据的结构参考，其包括从用户接收一个或多个参考数据结构的一个或多个元素的语义指定 ，创建对数据结构的元素的结构参考，以及将结构引用显示为一个或多个语义指定的集合。

    Extensible value types in cells
    3.
    发明授权
    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.

    摘要翻译： 电子表格中的单个单元格可能包含由可扩展值类型定义的可扩展值。 可扩展值类型是作为支持的数据类型合并到电子表格中的用户定义的值类型。 通常，可扩展数据类型为电子表格内部未定义的类型提供支持。 当定义可扩展值类型时，开发一组相关的函数来对类型进行操作。 这些功能被添加到电子表格支持的一组基本功能中。 因此，这些功能与基本电子表格功能的集合基本相似。 包含在单元格内的可扩展值可以以与所支持的基本类型作用相同的方式起作用。

    Multi-thread spreadsheet processing with dependency levels
    5.
    发明授权
    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.

    摘要翻译： 本公开涉及一种使用多个处理器的电子表格应用程序中处理链计算的方法和系统，每个处理器具有单独的重新计算引擎。 单个计算链可以重新排序成统一的链，其中支持和依赖公式被组织成儿童链的树层次结构。 统一链进一步分为依赖关系级别，每个依赖关系级别中的条目可能在重排序期间移动到下一个依赖关系级别。 如果依赖关系级别中的条目取决于在其自己的子链中未找到的另一个条目，则统一链被排序，使得条目仅依赖于先前的依赖关系级别中的条目。 此外，依赖关系级别允许控制线程在维护多线程处理能力的同时执行控制线程操作。

    Exiting a spreadsheet edit mode during a mouse drag operation
    7.
    发明授权
    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.

    摘要翻译： 用户可以点击电子表格单元格进入编辑模式并更改单元格的内容。 编辑模式可以通过点击和拖动操作退出。 单击和拖动操作不仅退出编辑模式，还可以选择一系列单元格。 鼠标指针定位时按住鼠标按钮可以执行点击和拖动在编辑单元格的上方，按住鼠标按钮的同时移动鼠标，并在达到所需单元格范围结束时释放鼠标按钮。 所选单元格的范围从编辑单元开始，并在鼠标按钮被释放时继续到鼠标指示器所在的单元格。

    System and method for editing a spreadsheet via an improved editing and cell selection model
    8.
    发明授权
    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.