-
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
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）以及数据透视表数据的部分 通过数据的标题。 本发明的实施例包括用于参考包括接收一个或多个语义指定的一组数据的方法，其中所述一个或多个语义指定命名描述数据结构中的一个或多个数据项的一组上下文信息， 自动创建结构参考，并将上下文信息与结构参考相关联。 本发明的其他实施例涉及与用户界面的交互，用于在显示设备上显示对电子表格中的数据的结构参考，其包括从用户接收一个或多个参考数据结构的一个或多个元素的语义指定 ，创建对数据结构的元素的结构参考，以及将结构引用显示为一个或多个语义指定的集合。
-
公开(公告)号：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
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.
摘要翻译： 本发明提供了可以操纵大量数据的几种数据库公式。 每个数据库公式是可自定义和可重复的，无需用户干预。 因此，用户可以输入许多选项，其可以覆盖用户对某些形式或格式的数据输出的期望，选择一组输入数据，并且一致地接收一组输出数据。 在一些实施例中，用户可以在语义上引用该组数据，而不是指定要在数据库公式中使用的单元格的范围。 参考数据语义上允许数据库公式适应新数据可能占用的单元格范围内的变化。
-
公开(公告)号：US08161372B2
公开(公告)日：2012-04-17
申请号：US11297991
申请日：2005-12-09
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.
摘要翻译： 电子表格中的单个单元格可能包含由可扩展值类型定义的可扩展值。 可扩展值类型是作为支持的数据类型合并到电子表格中的用户定义的值类型。 通常，可扩展数据类型为电子表格内部未定义的类型提供支持。 当定义可扩展值类型时，开发一组相关的函数来对类型进行操作。 这些功能被添加到电子表格支持的一组基本功能中。 因此，这些功能与基本电子表格功能的集合基本相似。 包含在单元格内的可扩展值可以以与所支持的基本类型作用相同的方式起作用。
-
4.发明授权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.
摘要翻译： 电子表格应用程序或支持公式单元格的其他应用程序，可自动为多种公式功能提供支持。 自动提供的各种公式函数包括一个返回公式逻辑值的函数，如果逻辑可以被评估而没有错误。 另一个函数在公式单元格中找到与第一列中特定值相同的行中的值，并且与第一行中的特定值相同的列。 其他功能允许选择一组多个查找行和列，以匹配用作函数中的变量的值。 电子表格应用程序还被配置为自动提供除了所描述的功能之外的其他功能。
-
公开(公告)号：US20090172063A1
公开(公告)日：2009-07-02
申请号：US11964497
申请日：2007-12-26
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的电子表格相对应的计算线程。
-
6.发明授权公开(公告)号：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
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.
-
7.发明授权Method, system, and apparatus for providing access to workbook models through remote function cells 有权用于通过远程功能单元提供对工作簿模型的访问的方法，系统和装置公开(公告)号：US08578399B2
公开(公告)日：2013-11-05
申请号：US10903781
申请日：2004-07-30
申请人： 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
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.
摘要翻译： 提供了一种方法，系统和装置，用于通过远程函数调用来暴露和调用工作簿模型。 根据该系统，客户端计算机执行用于创建工作簿模型的电子表格程序。 工作簿模型可以与定义功能名称的数据一起发布到服务器计算机，以及应用作模型的输入和输出的单元格。 该系统还包括服务器计算机，其接收并响应指向工作簿功能的远程功能调用。 当在服务器计算机上接收到用于工作簿功能的功能调用时，服务器计算机填充工作簿中标识为具有通过函数调用接收的输入参数的输入的单元，并重新计算工作簿。 然后，输出单元格中包含的数据作为远程函数调用的回复返回。
-
8.发明申请Method, system, and apparatus for providing access to workbook models through remote function calls 有权用于通过远程功能调用提供对工作簿模型的访问的方法，系统和装置公开(公告)号：US20090235154A1
公开(公告)日：2009-09-17
申请号：US10903781
申请日：2004-07-30
申请人： 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/00
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.发明申请Method, System, and Apparatus for Providing Access to Workbook Models Through Remote Function Calls 有权通过远程功能呼叫提供对工作簿模型的访问的方法，系统和装置公开(公告)号：US20130013995A1
公开(公告)日：2013-01-10
申请号：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/00
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.
摘要翻译： 提供了一种方法，系统和装置，用于通过远程函数调用来暴露和调用工作簿模型。 根据该系统，客户端计算机执行用于创建工作簿模型的电子表格程序。 工作簿模型可以与定义功能名称的数据一起发布到服务器计算机，以及应用作模型的输入和输出的单元格。 该系统还包括服务器计算机，其接收并响应指向工作簿功能的远程功能调用。 当在服务器计算机上接收到用于工作簿功能的函数调用时，服务器计算机填充工作簿中标识为具有通过函数调用接收的输入参数的输入的单元，并重新计算工作簿。 然后，输出单元格中包含的数据作为远程函数调用的回复返回。
-
公开(公告)号：US07805433B2
公开(公告)日：2010-09-28
申请号：US11251598
申请日：2005-10-14
CPC分类号： G06F17/30592 , G06F17/246
摘要： 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，成员属性和与集合有关的计数。 电子表格中的多维数据集功能可以从一个或多个多维数据库访问多维数据集数据。 在单个单元格中使用多维数据集公式允许用户从电子表格中添加/删除行和/或列。
-
-
-
-
-
-
-
-
-
搜索结果
29 条记录 (耗时 0.051 秒)
