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

1. 发明授权

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.
摘要翻译：本发明提供了可以操纵大量数据的几种数据库公式。每个数据库公式是可自定义和可重复的，无需用户干预。因此，用户可以输入许多选项，其可以覆盖用户对某些形式或格式的数据输出的期望，选择一组输入数据，并且一致地接收一组输出数据。在一些实施例中，用户可以在语义上引用该组数据，而不是指定要在数据库公式中使用的单元格的范围。参考数据语义上允许数据库公式适应新数据可能占用的单元格范围内的变化。

2. 发明授权

US6057837A On-screen indentification and manipulation of sources that an object depends upon 失效
标题翻译：屏幕上识别和操纵物体依赖的来源
公开(公告)号：US6057837A
公开(公告)日：2000-05-02
申请号：US892737
申请日：1997-07-15
申请人： Darrin N. Hatakeda , Howard W. Cherry, IV , John P. O'Neill , Russell S. Johnson , Juha P. Niemisto
发明人： Darrin N. Hatakeda , Howard W. Cherry, IV , John P. O'Neill , Russell S. Johnson , Juha P. Niemisto
IPC分类号： G06F17/24 , G06F15/00
CPC分类号： G06F17/246
摘要： Manipulating an object that is dependent upon one or more cells in a spreadsheet is facilitated by manipulating indicators that bound the relevant cells. The object can be a spreadsheet cell formula that contains a reference to one or more cells. The object can also be a graph object that is dependent upon one or more cells. In response to the selection of one of the objects, an indicator is displayed proximate to the cell or cells that the object is dependent upon. If the selected object is dependent upon multiple ranges of cells, then multiple indicators are displayed. Each indicator is displayed proximate to a cell or range of cells for the purpose of highlighting or identifying that the object is dependent upon that cell or range of cells. The highlighting or identifying is acceptably achieved with on-screen indicators that are color-coded. Each indicator can border a cell or a range of cells that the object is dependent upon. Each indicator can be moved, expanded or contracted so that it includes a different cell or range of cells. The selected object is updated to be dependent upon the cells currently identified by the associated indicator or indicators.
摘要翻译：操纵依赖于电子表格中的一个或多个单元格的对象，通过操纵绑定相关单元格的指标来实现。对象可以是包含对一个或多个单元格的引用的电子表格单元格公式。该对象还可以是依赖于一个或多个单元的图形对象。响应于对象中的一个的选择，指示符被显示在对象所依赖的单元格或单元格附近。如果所选对象取决于多个单元格范围，则会显示多个指示符。每个指示符显示在单元格或单元格范围附近，目的是突出显示或识别对象取决于单元格或单元格范围。突出显示或识别可以通过彩色编码的屏幕指示符来实现。每个指标可以与对象所依赖的单元格或单元格区域相邻。每个指示器可以移动，扩展或收缩，使其包含不同的单元格或单元格范围。所选择的对象被更新为依赖于由相关联的指示符或指示符当前标识的小区。

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. 发明授权

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

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式