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

1. 发明申请

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的电子表格相对应的计算线程。

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

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

US08584004B2 Asynchronous user defined functions 有权
标题翻译：异步用户定义的功能
公开(公告)号：US08584004B2
公开(公告)日：2013-11-12
申请号：US12107959
申请日：2008-04-23
申请人： Chris L. Rae , Charles D. Ellis , Jeffrey J. Duzak
发明人： Chris L. Rae , Charles D. Ellis , Jeffrey J. Duzak
IPC分类号： G06F17/12
CPC分类号： G06Q40/04
摘要： A framework for enabling users to create User Defined Functions (UDFs), which can run simultaneously without using multiple calculation threads, is provided. A calculation engine continues a remainder of calculation operations independent of a pending asynchronous function upon starting to run the asynchronous function without waiting to receive a result. The result value is introduced to the computation at a later time during the calculation cycle, when it is received or completed by the calculation engine. When the results are received, downstream operations such as dependent functions are calculated without changing a flow of dependencies within the operations.
摘要翻译：提供了允许用户创建可以同时运行而不使用多个计算线程的用户定义函数（UDF）的框架。计算引擎在开始运行异步功能而不等待接收结果时，继续执行与待处理异步功能无关的计算运算的剩余部分。当计算引擎接收或完成时，结果值在计算周期的较后时间被引入计算。当接收到结果时，计算诸如依赖函数的下游操作，而不改变操作内的依赖性流。

5. 发明申请

US20090228776A1 DYNAMIC FORMULAS FOR SPREADSHEET CELLS 审中-公开
标题翻译：动植物细胞的动态配方
公开(公告)号：US20090228776A1
公开(公告)日：2009-09-10
申请号：US12042500
申请日：2008-03-05
申请人： Allan Folting , Jeffrey J. Duzak , Charles D. Ellis
发明人： Allan Folting , Jeffrey J. Duzak , Charles D. Ellis
IPC分类号： G06F17/00
CPC分类号： G06F17/246
摘要： Multiple formulas are associated with a single cell of a spreadsheet. A base formula represents the actual value extracted from a data source. Adjustment formulas represent formulas for calculating adjustments to the value contained within the cell and other formulas can represent different calculation scenarios. Each of the formulas associated with the cell are dynamically updated and adjusted to react to changes elsewhere in the spreadsheet such that a user can recalculate the whole spreadsheet and move formulas around in the spreadsheet causing both the external data formula and all the adjustment formulas that may exist in the same cell to be updated accordingly.
摘要翻译：多个公式与电子表格的单个单元格相关联。基本公式表示从数据源中提取的实际值。调整公式表示用于计算对单元格中包含的值的调整的公式，其他公式可以表示不同的计算方案。与单元格相关联的每个公式被动态地更新和调整以对电子表格中的其他地方的变化做出反应，使得用户可以重新计算整个电子表格并在电子表格中移动公式，导致外部数据公式和可能的所有调整公式存在于要相应更新的同一个单元格中。

6. 发明申请

US20090271693A1 ASYNCHRONOUS USER DEFINED FUNCTIONS 有权
标题翻译：异步用户定义的功能
公开(公告)号：US20090271693A1
公开(公告)日：2009-10-29
申请号：US12107959
申请日：2008-04-23
申请人： Chris L. Rae , Charles D. Ellis , Jeffrey J. Duzak
发明人： Chris L. Rae , Charles D. Ellis , Jeffrey J. Duzak
IPC分类号： G06F17/00
CPC分类号： G06Q40/04
摘要： A framework for enabling users to create User Defined Functions (UDFs), which can run simultaneously without using multiple calculation threads, is provided. A calculation engine continues a remainder of calculation operations independent of a pending asynchronous function upon starting to run the asynchronous function without waiting to receive a result. The result value is introduced to the computation at a later time during the calculation cycle, when it is received or completed by the calculation engine. When the results are received, downstream operations such as dependent functions are calculated without changing a flow of dependencies within the operations.
摘要翻译：提供了允许用户创建可以同时运行而不使用多个计算线程的用户定义函数（UDF）的框架。计算引擎在开始运行异步功能而不等待接收结果时，继续执行与待处理异步功能无关的计算运算的剩余部分。当计算引擎接收或完成时，结果值在计算周期的较后时间被引入计算。当接收到结果时，计算诸如依赖函数的下游操作，而不改变操作内的依赖性流。

7. 发明授权

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

8. 发明授权

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.

9. 发明申请

US20100312748A1 MULTIDIMENSIONAL CUBE FUNCTIONS 审中-公开
标题翻译：多维CUBE功能
公开(公告)号：US20100312748A1
公开(公告)日：2010-12-09
申请号：US12852235
申请日：2010-08-06
申请人： Howard J. Dickerman , Brian W. Boon , Charles D. Ellis , Kaicheng Hu , Robert G. Hawking
发明人： Howard J. Dickerman , Brian W. Boon , Charles D. Ellis , Kaicheng Hu , Robert G. Hawking
IPC分类号： G06F17/30
CPC分类号： G06F17/246 , G06F16/283
摘要： Cube functions may be used to obtain data from a multidimensional database. The cube functions may be contained within one or more cells of a spreadsheet. These cube functions behave similarly to the standard functions that may be included within a spreadsheet. Exemplary cube functions include obtaining: a cube member, a cube value, a cube set, a ranked member, a KPI, a member property and a count relating to a set. The cube functions within the spreadsheet may access the cube data from one or more multidimensional databases. Using the cube formulas in individual cells allows the user to add/delete rows and/or columns from within the spreadsheet.
摘要翻译：多维数据集函数可用于从多维数据库获取数据。多维数据集函数可以包含在电子表格的一个或多个单元格内。这些立方体函数的行为与可能包含在电子表格中的标准函数类似。示例性立方体功能包括获得：立方体成员，立方体值，多维数据集，排名成员，KPI，成员属性和与集合有关的计数。电子表格中的多维数据集功能可以从一个或多个多维数据库访问多维数据集数据。在单个单元格中使用多维数据集公式允许用户从电子表格中添加/删除行和/或列。

10. 发明授权

US07590944B2 Scrollable and re-sizeable formula bar 有权
标题翻译：可滚动和可重配的公式栏
公开(公告)号：US07590944B2
公开(公告)日：2009-09-15
申请号：US11096940
申请日：2005-03-31
申请人： Brandon G. Weber , Charles D. Ellis
发明人： Brandon G. Weber , Charles D. Ellis
IPC分类号： G06F3/048
CPC分类号： G06F17/246
摘要： The present invention relates to new and improved embodiments of systems and methods for displaying content within a spreadsheet graphical user interface. In one embodiment, a computer system has a graphical user interface that performs a method for displaying data within a spreadsheet application. The method comprises displaying a formula bar comprising a text box that displays data contained in the spreadsheet, displaying a first portion of the spreadsheet data in the text box, and expanding the formula bar to display a second portion of the spreadsheet data in the text box.
摘要翻译：本发明涉及用于在电子表格图形用户界面内显示内容的系统和方法的新的和改进的实施例。在一个实施例中，计算机系统具有执行用于在电子表格应用程序内显示数据的方法的图形用户界面。该方法包括显示公式栏，其包括显示电子表格中包含的数据的文本框，在文本框中显示电子表格数据的第一部分，以及扩展公式栏以在文本框中显示电子表格数据的第二部分。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式