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

1. 发明授权

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.
摘要翻译：电子表格应用程序或支持公式单元格的其他应用程序，可自动为多种公式功能提供支持。自动提供的各种公式函数包括一个返回公式逻辑值的函数，如果逻辑可以被评估而没有错误。另一个函数在公式单元格中找到与第一列中特定值相同的行中的值，并且与第一行中的特定值相同的列。其他功能允许选择一组多个查找行和列，以匹配用作函数中的变量的值。电子表格应用程序还被配置为自动提供除了所描述的功能之外的其他功能。

2. 发明授权

US08549392B2 Customizable spreadsheet table styles 有权
标题翻译：可自定义的电子表格样式
公开(公告)号：US08549392B2
公开(公告)日：2013-10-01
申请号：US11214561
申请日：2005-08-30
申请人： Roy Simkhay , David F. Gainer , Tom J. Hoke , Benjamin C. Chamberlain , Paavany Jayanty , Charles D. Ellis
发明人： Roy Simkhay , David F. Gainer , Tom J. Hoke , Benjamin C. Chamberlain , Paavany Jayanty , Charles D. Ellis
IPC分类号： G06F17/00 , G06F17/24
CPC分类号： G06F17/246 , G06F17/245
摘要： Table styles provide a way to format an entire spreadsheet table quickly and easily. According to described implementations, table styles can be created and customized for repeated use in a spreadsheet application. As a result, a user does not have to manually modify multiple formatting options for each table included in one or more spreadsheets. A graphical user interface is also described that provides simple user access to existing table styles that can be modified according to the user's requirements.
摘要翻译：表格样式提供了一种快速轻松地格式化整个电子表格表格的方法。根据所描述的实现，可以创建和定制表样式，以便在电子表格应用程序中重复使用。因此，用户不必为一个或多个电子表格中包含的每个表手动修改多个格式化选项。还描述了图形用户界面，其提供对可以根据用户要求进行修改的现有表格样式的简单用户访问。

3. 发明授权

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

4. 发明授权

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

5. 发明授权

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

6. 发明授权

US08745482B2 Sorting spreadsheet data by format 有权
标题翻译：按格式排序电子表格数据
公开(公告)号：US08745482B2
公开(公告)日：2014-06-03
申请号：US12869367
申请日：2010-08-26
申请人： Charles D. Ellis , David F. Gainer , Samuel C. Radakovitz , Yonghong Zeng , Dave McDonald
发明人： Charles D. Ellis , David F. Gainer , Samuel C. Radakovitz , Yonghong Zeng , Dave McDonald
IPC分类号： G06F17/00
CPC分类号： G06F17/246 , G06F3/0482 , G06F3/04847 , G06F17/212
摘要： The present invention comprises methods and user interfaces for organizing data displayed within a data application. Specifically, the present invention provides methods and systems for arranging the display of the data by a format applied to one or more portions of the data. The formats comprise different visual characteristics of the displayed data. In exemplary embodiments, the data application organizes the data by the fill color of the cell, the font color of the data within the cell, or the type of icon inserted into the cell. The organizations comprise any type of rearrangement of the data. In exemplary embodiments, the data application sorts or filters the displayed data according to the format.
摘要翻译：本发明包括用于组织数据应用中显示的数据的方法和用户界面。具体地，本发明提供了用于通过应用于数据的一个或多个部分的格式来布置数据显示的方法和系统。格式包括显示数据的不同视觉特征。在示例性实施例中，数据应用程序通过单元格的填充颜色，单元格内的数据的字体颜色或插入单元格的图标的类型来组织数据。组织包括数据的任何类型的重新排列。在示例性实施例中，数据应用根据格式对所显示的数据进行排序或过滤。

7. 发明申请

US20100325526A1 FILTER AND SORT BY FORMAT 有权
标题翻译：过滤和排序格式
公开(公告)号：US20100325526A1
公开(公告)日：2010-12-23
申请号：US12869367
申请日：2010-08-26
申请人： Charles D. Ellis , David F. Gainer , Samuel C. Radakovitz , Yonghong Zhen , Dave McDonald
发明人： Charles D. Ellis , David F. Gainer , Samuel C. Radakovitz , Yonghong Zhen , Dave McDonald
IPC分类号： G06F17/00
CPC分类号： G06F17/246 , G06F3/0482 , G06F3/04847 , G06F17/212
摘要： The present invention comprises methods and user interfaces for organizing data displayed within a data application. Specifically, the present invention provides methods and systems for arranging the display of the data by a format applied to one or more portions of the data. The formats comprise different visual characteristics of the displayed data. In exemplary embodiments, the data application organizes the data by the fill color of the cell, the font color of the data within the cell, or the type of icon inserted into the cell. The organizations comprise any type of rearrangement of the data. In exemplary embodiments, the data application sorts or filters the displayed data according to the format.
摘要翻译：本发明包括用于组织数据应用中显示的数据的方法和用户界面。具体地，本发明提供了用于通过应用于数据的一个或多个部分的格式来布置数据显示的方法和系统。格式包括显示数据的不同视觉特征。在示例性实施例中，数据应用程序通过单元格的填充颜色，单元格内的数据的字体颜色或插入单元格的图标的类型来组织数据。组织包括数据的任何类型的重新排列。在示例性实施例中，数据应用根据格式对所显示的数据进行排序或过滤。

8. 发明授权

US07849395B2 Filter and sort by color 有权
标题翻译：按颜色过滤和排序
公开(公告)号：US07849395B2
公开(公告)日：2010-12-07
申请号：US11013628
申请日：2004-12-15
申请人： Charles D. Ellis , David F. Gainer , Samuel C. Radakovitz , Yonghong Zhen , Dave McDonald
发明人： Charles D. Ellis , David F. Gainer , Samuel C. Radakovitz , Yonghong Zhen , Dave McDonald
IPC分类号： G06F17/00
CPC分类号： G06F17/246 , G06F3/0482 , G06F3/04847 , G06F17/212
摘要： The present invention comprises methods and user interfaces for organizing data displayed within a data application. Specifically, the present invention provides methods and systems for arranging the display of the data by a format applied to one or more portions of the data. The formats comprise different visual characteristics of the displayed data. In exemplary embodiments, the data application organizes the data by the fill color of the cell, the font color of the data within the cell, or the type of icon inserted into the cell. The organizations comprise any type of rearrangement of the data. In exemplary embodiments, the data application sorts or filters the displayed data according to the format.
摘要翻译：本发明包括用于组织数据应用中显示的数据的方法和用户界面。具体地，本发明提供了用于通过应用于数据的一个或多个部分的格式来布置数据显示的方法和系统。格式包括显示数据的不同视觉特征。在示例性实施例中，数据应用程序通过单元格的填充颜色，单元格内的数据的字体颜色或插入单元格的图标的类型来组织数据。组织包括数据的任何类型的重新排列。在示例性实施例中，数据应用根据格式对所显示的数据进行排序或过滤。

9. 发明申请

US20090172063A1 Multi-Threaded Codeless User-Defined Functions 审中-公开
标题翻译：多线程无代码用户定义函数
公开(公告)号：US20090172063A1
公开(公告)日：2009-07-02
申请号：US11964497
申请日：2007-12-26
申请人： Joseph M. Chirilov , Jeffrey J. Duzak , Andrew J. Becker , Charles D. Ellis
发明人： Joseph M. Chirilov , Jeffrey J. Duzak , Andrew J. Becker , Charles D. Ellis
IPC分类号： G06F7/38 , G06F7/00
CPC分类号： G06F17/246
摘要： A multi-threaded codeless user-defined function (UDF) may be provided. First, at least one input value may be received from a calculation thread corresponding to a spreadsheet calling the codeless UDF. Then, the at least one input value may be saved in a thread storage area outside of a UDF storage area containing the codeless UDF. Next, the codeless UDF may be performed comprising performing at least one calculation using at least one formula in the codeless UDF and the at least one input value from the thread storage area. At least one output value produced in response to performing the codeless UDF may then be returned to the calculation thread corresponding to the spreadsheet calling the codeless UDF.
摘要翻译：可以提供多线程的无代码用户定义功能（UDF）。首先，可以从对应于调用无代码UDF的电子表格的计算线程接收至少一个输入值。然后，至少一个输入值可以保存在包含无代码UDF的UDF存储区域之外的线程存储区域中。接下来，可以执行无代码UDF，其包括使用无码UDF中的至少一个公式和来自线程存储区域的至少一个输入值来执行至少一个计算。响应于执行无代码UDF而产生的至少一个输出值然后可以被返回到与调用无代码UDF的电子表格相对应的计算线程。

10. 发明授权

US09317495B2 Method, system, and apparatus for providing access to workbook models through remote function calls 有权
公开(公告)号：US09317495B2
公开(公告)日：2016-04-19
申请号：US13620854
申请日：2012-09-15
申请人： Dan Y. Khen , Charles D. Ellis , Liviu Asnash , Eran Megiddo , Ira Levin , Simon Peyton-Jones
发明人： Dan Y. Khen , Charles D. Ellis , Liviu Asnash , Eran Megiddo , Ira Levin , Simon Peyton-Jones
IPC分类号： G06F17/24 , G06F9/54 , H04L29/06
CPC分类号： G06F17/246 , G06F9/541 , G06F9/547 , H04L67/40
摘要： A method, system, and apparatus are provided for exposing and calling workbook models via remote function calls. According to the system, a client computer executes a spreadsheet program for creating a workbook model. The workbook model may be published to a server computer along with data defining a function name and the cells that should be used as inputs and outputs to the model. The system also includes a server computer that receives and responds to remote function calls directed toward workbook functions. When a function call is received at the server computer for a workbook function, the server computer populates the cells in the workbook identified as inputs with input parameters received with the function call and recalculates the workbook. The data contained in the output cells is then returned as a reply to the remote function call.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式