Asynchronous user defined functions
    2.
    发明授权
    Asynchronous user defined functions 有权
    异步用户定义的功能

    公开(公告)号:US08584004B2

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

    申请号:US12107959

    申请日:2008-04-23

    CPC classification number: G06Q40/04

    Abstract: 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.

    Abstract translation: 提供了允许用户创建可以同时运行而不使用多个计算线程的用户定义函数(UDF)的框架。 计算引擎在开始运行异步功能而不等待接收结果时,继续执行与待处理异步功能无关的计算运算的剩余部分。 当计算引擎接收或完成时,结果值在计算周期的较后时间被引入计算。 当接收到结果时,计算诸如依赖函数的下游操作,而不改变操作内的依赖性流。

    MULTIDIMENSIONAL CUBE FUNCTIONS
    3.
    发明申请
    MULTIDIMENSIONAL CUBE FUNCTIONS 审中-公开
    多维CUBE功能

    公开(公告)号:US20100312748A1

    公开(公告)日:2010-12-09

    申请号:US12852235

    申请日:2010-08-06

    CPC classification number: G06F17/246 G06F16/283

    Abstract: 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.

    Abstract translation: 多维数据集函数可用于从多维数据库获取数据。 多维数据集函数可以包含在电子表格的一个或多个单元格内。 这些立方体函数的行为与可能包含在电子表格中的标准函数类似。 示例性立方体功能包括获得:立方体成员,立方体值,多维数据集,排名成员,KPI,成员属性和与集合有关的计数。 电子表格中的多维数据集功能可以从一个或多个多维数据库访问多维数据集数据。 在单个单元格中使用多维数据集公式允许用户从电子表格中添加/删除行和/或列。

    Scrollable and re-sizeable formula bar
    4.
    发明授权
    Scrollable and re-sizeable formula bar 有权
    可滚动和可重配的公式栏

    公开(公告)号:US07590944B2

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

    申请号:US11096940

    申请日:2005-03-31

    CPC classification number: G06F17/246

    Abstract: 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.

    Abstract translation: 本发明涉及用于在电子表格图形用户界面内显示内容的系统和方法的新的和改进的实施例。 在一个实施例中,计算机系统具有执行用于在电子表格应用程序内显示数据的方法的图形用户界面。 该方法包括显示公式栏,其包括显示电子表格中包含的数据的文本框,在文本框中显示电子表格数据的第一部分,以及扩展公式栏以在文本框中显示电子表格数据的第二部分 。

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

    公开(公告)号:US07415481B2

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

    申请号:US10956940

    申请日:2004-09-30

    CPC classification number: G06F17/246 Y10S707/99943

    Abstract: 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.

    Abstract translation: 本发明涉及电子表格程序中的新型结构化名称,其允许用户参考表格中的表,数据列,表的表,表中的总计,数据透视表(RIV)以及数据透视表数据的部分 通过数据的标题。 本发明的实施例包括用于参考包括接收一个或多个语义指定的一组数据的方法,其中所述一个或多个语义指定命名描述数据结构中的一个或多个数据项的一组上下文信息, 自动创建结构参考,并将上下文信息与结构参考相关联。 本发明的其他实施例涉及与用户界面的交互,用于在显示设备上显示对电子表格中的数据的结构参考,其包括从用户接收一个或多个参考数据结构的一个或多个元素的语义指定 ,创建对数据结构的元素的结构参考,以及将结构引用显示为一个或多个语义指定的集合。

    Multidimensional cube functions
    6.
    发明授权
    Multidimensional cube functions 有权
    多维立方体函数

    公开(公告)号:US07805433B2

    公开(公告)日:2010-09-28

    申请号:US11251598

    申请日:2005-10-14

    CPC classification number: G06F17/30592 G06F17/246

    Abstract: 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.

    Abstract translation: 多维数据集函数可用于从多维数据库获取数据。 多维数据集函数可以包含在电子表格的一个或多个单元格内。 这些立方体函数的行为与可能包含在电子表格中的标准函数类似。 示例性立方体功能包括获得:立方体成员,立方体值,多维数据集,排名成员,KPI,成员属性和与集合有关的计数。 电子表格中的多维数据集功能可以从一个或多个多维数据库访问多维数据集数据。 在单个单元格中使用多维数据集公式允许用户从电子表格中添加/删除行和/或列。

    Fireplace log retainer
    7.
    发明授权
    Fireplace log retainer 失效
    壁炉日志保持架

    公开(公告)号:US6055978A

    公开(公告)日:2000-05-02

    申请号:US108207

    申请日:1998-07-01

    Inventor: Charles D. Ellis

    CPC classification number: F24B1/193

    Abstract: A log retainer has a two or more mounting brackets connected together by a cross bar. Each mounting bracket has a lower and upper mounting arm which is used to connect the retainer to the grate without adapting the grate. Each of the lower mounting arms has fingers extending therefrom, and each of the upper mounting arms has a thumb extending therefrom, the fingers and thumb engaging members of the grate to support the mounting brackets and cross bar above the grate to retain the logs in the grate.

    Abstract translation: 对数保持器具有两个或更多个通过横杆连接在一起的安装支架。 每个安装支架具有下安装臂和上安装臂,其用于将保持器连接到格栅而不调整格栅。 每个下安装臂具有从其延伸的指状物,并且每个上安装臂具有从其延伸的拇指,格栅的指状物和拇指接合构件,以支撑安装支架,并在格栅上方横向固定,以将原木保持在 炉排

    Sorting spreadsheet data by format
    8.
    发明授权
    Sorting spreadsheet data by format 有权
    按格式排序电子表格数据

    公开(公告)号:US08745482B2

    公开(公告)日:2014-06-03

    申请号:US12869367

    申请日:2010-08-26

    CPC classification number: G06F17/246 G06F3/0482 G06F3/04847 G06F17/212

    Abstract: 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.

    Abstract translation: 本发明包括用于组织数据应用中显示的数据的方法和用户界面。 具体地,本发明提供了用于通过应用于数据的一个或多个部分的格式来布置数据显示的方法和系统。 格式包括显示数据的不同视觉特征。 在示例性实施例中,数据应用程序通过单元格的填充颜色,单元格内的数据的字体颜色或插入单元格的图标的类型来组织数据。 组织包括数据的任何类型的重新排列。 在示例性实施例中,数据应用根据格式对所显示的数据进行排序或过滤。

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

    公开(公告)号:US20130013995A1

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

    申请号:US13620854

    申请日:2012-09-15

    CPC classification number: G06F17/246 G06F9/541 G06F9/547 H04L67/40

    Abstract: 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.

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

Patent Agency Ranking