专利快速检索-快速检索全球专利，免费商用专利数据库-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. 发明授权

US08621340B2 Block properties and calculated columns in a spreadsheet application 有权
标题翻译：阻止电子表格应用程序中的属性和计算列
公开(公告)号：US08621340B2
公开(公告)日：2013-12-31
申请号：US11018418
申请日：2004-12-20
申请人： Joseph M. Chirilov , Dennis R. Newland , Eoin J. Burke , Hannah W. Zhou , John C. Haymond , Juha P. Niemisto , Robert C. Collie , Robert W. Coffen , Thao Moua
发明人： Joseph M. Chirilov , Dennis R. Newland , Eoin J. Burke , Hannah W. Zhou , John C. Haymond , Juha P. Niemisto , Robert C. Collie , Robert W. Coffen , Thao Moua
IPC分类号： G06F17/16 , G06F17/30
CPC分类号： G06F17/246
摘要： Block properties and improved calculated columns properties are provided in a spreadsheet application. Once block properties are set for a group of spreadsheet cells or a spreadsheet list, the properties may be applied to the entire group of selected cells or list as opposed to requiring application of properties to individual cells. If rows or columns are added to the group of selected cells or list, properties applied to the group of cells or list are automatically applied to the new rows or columns. Block properties also provide for intelligent-behaving list borders where list borders are not corrupted by the movement or changing of columns or rows sharing edges with a list border. Calculated columns are a type of block property that extends the functionality of formulas throughout an entire column of an associated group of cells or list.
摘要翻译：电子表格应用程序中提供了块属性和改进的计算列属性。一旦为一组电子表格单元格或电子表格列表设置了块属性，则可以将属性应用于所选单元格或列表的整个组，而不是要求将属性应用于单个单元格。如果将行或列添加到所选单元格或列表的组中，则应用于单元格或列表组的属性将自动应用于新行或列。块属性还提供智能行为列表边框，其中列表边框没有被列表边框移动或更改列或列共享边缘而损坏。计算的列是一种类型的块属性，可以在关联的单元格或列表组的整个列中扩展公式的功能。

4. 发明授权

US07480675B2 Automated placement of fields in a data summary table 有权
标题翻译：在数据摘要表中自动放置字段
公开(公告)号：US07480675B2
公开(公告)日：2009-01-20
申请号：US11222660
申请日：2005-09-09
申请人： Allan Folting , Konrad Tupaj , Robert C. Collie , Anatoly V. Grabar
发明人： Allan Folting , Konrad Tupaj , Robert C. Collie , Anatoly V. Grabar
IPC分类号： G06F7/00
CPC分类号： G06F17/246 , Y10S707/99943
摘要： A graphical user interface for creating a data summary table includes a pane including a plurality of fields, and a data summary table. Upon selection of a field to include in the data summary table, the user interface is programmed to analyze the field and automatically place the field in the data summary table.
摘要翻译：用于创建数据摘要表的图形用户界面包括包括多个字段的窗格和数据摘要表。在选择要包括在数据摘要表中的字段时，将用户界面编程为分析该字段并将该字段自动放置在数据汇总表中。

5. 发明授权

US08832544B2 Associating conditions to summary table data 有权
标题翻译：将条件与汇总表数据相关联
公开(公告)号：US08832544B2
公开(公告)日：2014-09-09
申请号：US12857067
申请日：2010-08-16
申请人： Eric B. Vigesaa , Allan Folting , Bruce Cordell Jones , Robert C. Collie
发明人： Eric B. Vigesaa , Allan Folting , Bruce Cordell Jones , Robert C. Collie
IPC分类号： G06F17/30 , G06F17/00 , G06F17/24
CPC分类号： G06F17/246 , G06F3/04842 , G06F17/211 , G06F17/30489 , G06F17/30504
摘要： A method and system associate conditional formats with selected data points or groups of data points within a summary table. In one embodiment, related groups of data are determined based upon currently highlighted cells in a summary table. A user then selects from the groups and identifies conditional formats to be associated with the specified data points. The conditional formats are associated with currently displayed as well as non-displayed data within the summary table. The associated conditions are saved relative to the data points rather than the original cell positions so that the conditions remain associated with the data points following a reorganization of the summary table.
摘要翻译：方法和系统将条件格式与摘要表中的所选数据点或数据点组相关联。在一个实施例中，基于摘要表中当前突出显示的单元确定相关的数据组。然后，用户从组中选择并识别与指定数据点相关联的条件格式。条件格式与摘要表中的当前显示以及未显示的数据相关联。相关条件相对于数据点而不是原始单元位置被保存，使得条件在重组汇总表之后保持与数据点相关联。

6. 发明授权

US06269377B1 System and method for managing locations of software components via a source list 有权
标题翻译：通过源列表管理软件组件的位置的系统和方法
公开(公告)号：US06269377B1
公开(公告)日：2001-07-31
申请号：US09157974
申请日：1998-09-21
申请人： Robert C. Collie , John C. Delo , Malcolm S. Haar , David E. Gonzalez
发明人： Robert C. Collie , John C. Delo , Malcolm S. Haar , David E. Gonzalez
IPC分类号： G06F1730
CPC分类号： G06F17/30067 , G06F8/61 , Y10S707/99942 , Y10S707/99943 , Y10S707/99944 , Y10S707/99945 , Y10S707/99953
摘要： A system and method for managing locations of software components via a source list. The needed software components are identified. A list of source locations is referenced repeatedly until a valid source location is found or until each source location on the list has been referenced. If a valid source location is found, the software components are retrieved from that source location. New source locations may be added to this list of source locations when the user identifies these new source locations. A list of source locations is continually maintained.
摘要翻译：一种用于通过源列表管理软件组件的位置的系统和方法。识别所需的软件组件。重复引用源位置列表，直到找到有效的源位置或直到列表中的每个源位置被引用为止。如果找到有效的源位置，则从该源位置检索软件组件。当用户识别这些新的源位置时，可以将新的源位置添加到源列表中。不断维护源位置列表。

7. 发明申请

US20110099143A1 EMBEDDING AND RETRIEVING DATA IN AN APPLICATION FILE FORMAT 有权
标题翻译：在应用文件格式中嵌入和检索数据
公开(公告)号：US20110099143A1
公开(公告)日：2011-04-28
申请号：US12605126
申请日：2009-10-23
申请人： Daniel C. Battagin , Gabhan Berry , Robert C. Collie , Lee B. Graber , Raman S. Iyer , Shahar Prish , Su-Piao Bill Wu
发明人： Daniel C. Battagin , Gabhan Berry , Robert C. Collie , Lee B. Graber , Raman S. Iyer , Shahar Prish , Su-Piao Bill Wu
IPC分类号： G06F17/30
CPC分类号： G06F17/30563 , G06F17/30914
摘要： Third party data embedding may be provided. Data associated with a third party provider may be saved in a native application save file. If a save file opened by the application is determined to comprise third party data, the application may determine whether an appropriate data provider is available. The application may connect to the data provider and provide on-demand, asynchronous access to the third party data upon request from a user.
摘要翻译：可以提供第三方数据嵌入。与第三方提供商相关联的数据可能会保存在本机应用程序保存文件中。如果由应用程序打开的保存文件被确定为包括第三方数据，则应用可以确定适当的数据提供者是否可用。应用可以连接到数据提供者，并且根据用户的请求提供对第三方数据的按需异步访问。

8. 发明授权

US07779000B2 Associating conditions to summary table data 有权
标题翻译：将条件与汇总表数据相关联
公开(公告)号：US07779000B2
公开(公告)日：2010-08-17
申请号：US11215634
申请日：2005-08-29
申请人： Eric B. Vigesaa , Allan Folting , Bruce Cordell Jones , Robert C. Collie
发明人： Eric B. Vigesaa , Allan Folting , Bruce Cordell Jones , Robert C. Collie
IPC分类号： G06F17/30
CPC分类号： G06F17/246 , G06F3/04842 , G06F17/211 , G06F17/30489 , G06F17/30504
摘要： A method and system associate conditional formats with selected data points or groups of data points within a summary table. In one embodiment, related groups of data are determined based upon currently highlighted cells in a summary table. A user then selects from the groups and identifies conditional formats to be associated with the specified data points. The conditional formats are associated with currently displayed as well as non-displayed data within the summary table. The associated conditions are saved relative to the data points rather than the original cell positions so that the conditions remain associated with the data points following a reorganization of the summary table.
摘要翻译：方法和系统将条件格式与摘要表中的所选数据点或数据点组相关联。在一个实施例中，基于摘要表中当前突出显示的单元确定相关的数据组。然后，用户从组中选择并识别与指定数据点相关联的条件格式。条件格式与摘要表中的当前显示以及未显示的数据相关联。相关条件相对于数据点而不是原始单元位置被保存，使得条件在重组汇总表之后保持与数据点相关联。

9. 发明授权

US08429118B2 Embedding and retrieving data in an application file format 有权
标题翻译：以应用程序文件格式嵌入和检索数据
公开(公告)号：US08429118B2
公开(公告)日：2013-04-23
申请号：US12605126
申请日：2009-10-23
申请人： Daniel C. Battagin , Gabhan Berry , Robert C. Collie , Lee B. Graber , Raman S. Iyer , Shahar Prish , Su-Piao Bill Wu
发明人： Daniel C. Battagin , Gabhan Berry , Robert C. Collie , Lee B. Graber , Raman S. Iyer , Shahar Prish , Su-Piao Bill Wu
IPC分类号： G06F7/00
CPC分类号： G06F17/30563 , G06F17/30914
摘要： Third party data embedding may be provided. Data associated with a third party provider may be saved in a native application save file. If a save file opened by the application is determined to comprise third party data, the application may determine whether an appropriate data provider is available. The application may connect to the data provider and provide on-demand, asynchronous access to the third party data upon request from a user.
摘要翻译：可以提供第三方数据嵌入。与第三方提供商相关联的数据可能会保存在本机应用程序保存文件中。如果由应用程序打开的保存文件被确定为包括第三方数据，则应用可以确定适当的数据提供者是否可用。应用可以连接到数据提供者，并且根据用户的请求提供对第三方数据的按需异步访问。

10. 发明授权

US08185817B2 Utilizing spreadsheet references with grouped aggregate views 有权
标题翻译：利用分组的聚合视图的电子表格引用
公开(公告)号：US08185817B2
公开(公告)日：2012-05-22
申请号：US12141114
申请日：2008-06-18
申请人： Robert C. Collie , Amir Netz , Paul J. Sanders , Cristian Petculescu
发明人： Robert C. Collie , Amir Netz , Paul J. Sanders , Cristian Petculescu
IPC分类号： G06F17/00 , G06F17/20 , G06F17/21 , G06F17/22 , G06F3/048
CPC分类号： G06F17/246
摘要： Various technologies and techniques are disclosed for utilizing spreadsheet references with grouped aggregate views. A grouped aggregate view feature enables a user to create a grouped aggregate view of data. A calculation feature enables the user to calculations for the grouped aggregate view of data that are based upon relative or absolute references to data in the grouped aggregate view. Input is received from a user to write a calculation within a first cell in a grouped aggregate view. Input is received from the user to select a second cell to reference when writing the calculation. The user is presented with available references that are relevant to data contained in the second cell. Input is received from the user to select one of the available references that are relevant for the second cell. The selected one of the available references is placed into the first cell.
摘要翻译：公开了利用具有分组聚集视图的电子表格引用的各种技术和技术。分组的聚合视图功能使用户能够创建数据的分组聚合视图。计算功能使用户能够对分组的聚合视图数据进行计算，该视图基于分组聚合视图中对数据的相对或绝对引用。从用户接收输入以在分组聚合视图中的第一个单元格内写入计算。从用户接收到输入，以便在写入计算时选择第二个单元格进行参考。向用户呈现与第二小区中包含的数据相关的可用参考。从用户接收输入以选择与第二小区相关的可用参考之一。所选择的一个可用参考被放入第一个单元格中。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式