Method, system, and apparatus for providing access to workbook models through remote function cells
    1.
    发明授权
    Method, system, and apparatus for providing access to workbook models through remote function cells 有权
    用于通过远程功能单元提供对工作簿模型的访问的方法,系统和装置

    公开(公告)号:US08578399B2

    公开(公告)日:2013-11-05

    申请号:US10903781

    申请日:2004-07-30

    IPC分类号: G06F9/44 G06F17/00

    摘要: 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.

    摘要翻译: 提供了一种方法,系统和装置,用于通过远程函数调用来暴露和调用工作簿模型。 根据该系统,客户端计算机执行用于创建工作簿模型的电子表格程序。 工作簿模型可以与定义功能名称的数据一起发布到服务器计算机,以及应用作模型的输入和输出的单元格。 该系统还包括服务器计算机,其接收并响应指向工作簿功能的远程功能调用。 当在服务器计算机上接收到用于工作簿功能的功能调用时,服务器计算机填充工作簿中标识为具有通过函数调用接收的输入参数的输入的单元,并重新计算工作簿。 然后,输出单元格中包含的数据作为远程函数调用的回复返回。

    Method, system, and apparatus for providing access to workbook models through remote function calls
    2.
    发明申请
    Method, system, and apparatus for providing access to workbook models through remote function calls 有权
    用于通过远程功能调用提供对工作簿模型的访问的方法,系统和装置

    公开(公告)号:US20090235154A1

    公开(公告)日:2009-09-17

    申请号:US10903781

    申请日:2004-07-30

    IPC分类号: G06F17/00

    摘要: 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.

    摘要翻译: 提供了一种方法,系统和装置,用于通过远程函数调用来暴露和调用工作簿模型。 根据该系统,客户端计算机执行用于创建工作簿模型的电子表格程序。 工作簿模型可以与定义功能名称的数据一起发布到服务器计算机,以及应用作模型的输入和输出的单元格。 该系统还包括服务器计算机,其接收并响应指向工作簿功能的远程功能调用。 当在服务器计算机上接收到用于工作簿功能的函数调用时,服务器计算机填充工作簿中标识为具有通过函数调用接收的输入参数的输入的单元,并重新计算工作簿。 然后,输出单元格中包含的数据作为远程函数调用的回复返回。

    Method, System, and Apparatus for Providing Access to Workbook Models Through Remote Function Calls
    3.
    发明申请
    Method, System, and Apparatus for Providing Access to Workbook Models Through Remote Function Calls 有权
    通过远程功能呼叫提供对工作簿模型的访问的方法,系统和装置

    公开(公告)号:US20130013995A1

    公开(公告)日:2013-01-10

    申请号:US13620854

    申请日:2012-09-15

    IPC分类号: G06F17/00

    摘要: 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.

    摘要翻译: 提供了一种方法,系统和装置,用于通过远程函数调用来暴露和调用工作簿模型。 根据该系统,客户端计算机执行用于创建工作簿模型的电子表格程序。 工作簿模型可以与定义功能名称的数据一起发布到服务器计算机,以及应用作模型的输入和输出的单元格。 该系统还包括服务器计算机,其接收并响应指向工作簿功能的远程功能调用。 当在服务器计算机上接收到用于工作簿功能的函数调用时,服务器计算机填充工作簿中标识为具有通过函数调用接收的输入参数的输入的单元,并重新计算工作簿。 然后,输出单元格中包含的数据作为远程函数调用的回复返回。

    Method and implementation for referencing of dynamic data within spreadsheet formulas
    6.
    发明授权
    Method and implementation for referencing of dynamic data within spreadsheet formulas 有权
    在电子表格公式中引用动态数据的方法和实现

    公开(公告)号:US07415481B2

    公开(公告)日:2008-08-19

    申请号:US10956940

    申请日:2004-09-30

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

    Transaction and task scheduler
    7.
    发明授权
    Transaction and task scheduler 失效
    事务和任务调度程序

    公开(公告)号:US07716249B2

    公开(公告)日:2010-05-11

    申请号:US11229053

    申请日:2005-09-16

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F9/524 G06F9/466

    摘要: The described implementations relate to efficient scheduling of transactions and tasks. A memory location, address, or variable previously accessed by a blocked entity is observed periodically to determine an appropriate time to wake and retry the blocked entity. If the previous accessed memory location, address or variable changes state, a scheduler wakes the blocked entity and the blocked entity retries processing. A doubly-indexed data structure of blocked entities and memory locations associated with the blocked entities may be used to efficiently determine when a retrying execution would be profitable.

    摘要翻译: 所描述的实现涉及事务和任务的有效调度。 周期性地观察先前被阻塞实体访问的存储器位置,地址或变量,以确定唤醒并重试被阻塞实体的适当时间。 如果先前访问的存储器位置,地址或变量改变状态,则调度器唤醒被阻止的实体,并且被阻止的实体重试处理。 被阻止的实体和与被阻止的实体相关联的存储器位置的双重索引的数据结构可以用于有效地确定重试执行何时是有利可图的。

    Design of spreadsheet functions for working with tables of data
    8.
    发明申请
    Design of spreadsheet functions for working with tables of data 有权
    设计用于处理数据表的电子表格功能

    公开(公告)号:US20060075328A1

    公开(公告)日:2006-04-06

    申请号:US10957502

    申请日:2004-09-30

    IPC分类号: G06F17/24 G06F7/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.

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

    User defined spreadsheet functions
    9.
    发明授权
    User defined spreadsheet functions 有权
    用户定义的电子表格功能

    公开(公告)号:US07266763B2

    公开(公告)日:2007-09-04

    申请号:US10306937

    申请日:2002-11-26

    IPC分类号: G06F17/00 G06F7/00

    CPC分类号: G06F17/246 Y10S707/99931

    摘要: A method of creating a user-defined function in a spreadsheet application is provided. The user-defined function is callable by a calling label in the spreadsheet application. A formula is received in the spreadsheet application. The formula is transferred to a function sheet of the spreadsheet application to define at least a portion of a function body. An interface is defined by identifying the calling label, an input parameter and a result parameter of the user-defined function. The function body operates on an argument corresponding to the input parameter and generates a result corresponding to the result parameter. The interface is stored in association with the function body to create the user-defined function.

    摘要翻译: 提供了一种在电子表格应用程序中创建用户定义函数的方法。 用户定义的函数可以通过电子表格应用程序中的调用标签来调用。 在电子表格应用程序中接收到一个公式。 公式被转移到电子表格应用程序的功能表以定义函数体的至少一部分。 通过标识用户定义的函数的调用标签,输入参数和结果参数来定义接口。 功能体对与输入参数相对应的参数进行操作,并生成与结果参数对应的结果。 该界面与函数体相关联存储,以创建用户定义的函数。

    Transaction and task scheduler
    10.
    发明申请
    Transaction and task scheduler 失效
    事务和任务调度程序

    公开(公告)号:US20070073693A1

    公开(公告)日:2007-03-29

    申请号:US11229053

    申请日:2005-09-16

    IPC分类号: G06F17/30

    CPC分类号: G06F9/524 G06F9/466

    摘要: The described implementations relate to efficient scheduling of transactions and tasks. A memory location, address, or variable previously accessed by a blocked entity is observed periodically to determine an appropriate time to wake and retry the blocked entity. If the previous accessed memory location, address or variable changes state, a scheduler wakes the blocked entity and the blocked entity retries processing. A doubly-indexed data structure of blocked entities and memory locations associated with the blocked entities may be used to efficiently determine when a retrying execution would be profitable.

    摘要翻译: 所描述的实现涉及事务和任务的有效调度。 周期性地观察先前被阻塞实体访问的存储器位置,地址或变量,以确定唤醒并重试被阻塞实体的适当时间。 如果先前访问的存储器位置,地址或变量改变状态,则调度器唤醒被阻止的实体,并且被阻止的实体重试处理。 被阻止的实体和与被阻止的实体相关联的存储器位置的双重索引的数据结构可以用于有效地确定重试执行何时是有利可图的。