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

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

    公开(公告)号:US08578399B2

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

    申请号:US10903781

    申请日:2004-07-30

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

    Customizable spreadsheet table styles
    14.
    发明授权
    Customizable spreadsheet table styles 有权
    可自定义的电子表格样式

    公开(公告)号:US08549392B2

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

    申请号:US11214561

    申请日:2005-08-30

    CPC classification number: G06F17/246 G06F17/245

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

    Abstract translation: 表格样式提供了一种快速轻松地格式化整个电子表格表格的方法。 根据所描述的实现,可以创建和定制表样式,以便在电子表格应用程序中重复使用。 因此,用户不必为一个或多个电子表格中包含的每个表手动修改多个格式化选项。 还描述了图形用户界面,其提供对可以根据用户要求进行修改的现有表格样式的简单用户访问。

    FILTER AND SORT BY FORMAT
    15.
    发明申请
    FILTER AND SORT BY FORMAT 有权
    过滤和排序格式

    公开(公告)号:US20100325526A1

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

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

    Filter and sort by color
    16.
    发明授权
    Filter and sort by color 有权
    按颜色过滤和排序

    公开(公告)号:US07849395B2

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

    申请号:US11013628

    申请日:2004-12-15

    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 and system to associate cell and item metadata
    17.
    发明授权
    Method and system to associate cell and item metadata 失效
    关联单元格和项目元数据的方法和系统

    公开(公告)号:US07693860B2

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

    申请号:US11083492

    申请日:2005-03-18

    CPC classification number: G06F17/246 G06F17/241

    Abstract: The present invention generally relates to new and improved embodiments of methods and systems for capturing and providing arbitrarily rich data to be stored or manipulated within a spreadsheet. In one embodiment of the present invention, a method for creating spreadsheet metadata comprises receiving an item in a spreadsheet, receiving item metadata about the item, and associating the item metadata with the item to create spreadsheet metadata.

    Abstract translation: 本发明一般涉及用于捕获并提供要在电子表格内存储或操纵的任意丰富的数据的方法和系统的新的和改进的实施例。 在本发明的一个实施例中,用于创建电子表格元数据的方法包括:接收电子表格中的项目,接收关于该项目的项目元数据,以及将该项目元数据与该项目相关联以创建电子表格元数据。

    ASYNCHRONOUS USER DEFINED FUNCTIONS
    18.
    发明申请
    ASYNCHRONOUS USER DEFINED FUNCTIONS 有权
    异步用户定义的功能

    公开(公告)号:US20090271693A1

    公开(公告)日:2009-10-29

    申请号: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)的框架。 计算引擎在开始运行异步功能而不等待接收结果时,继续执行与待处理异步功能无关的计算运算的剩余部分。 当计算引擎接收或完成时,结果值在计算周期的较后时间被引入计算。 当接收到结果时,计算诸如依赖函数的下游操作,而不改变操作内的依赖性流。

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

    公开(公告)号:US20090235154A1

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

    申请号:US10903781

    申请日:2004-07-30

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

    Process for preparing a photographic emulsion containing tabular grains
exhibiting high speed
    20.
    发明授权
    Process for preparing a photographic emulsion containing tabular grains exhibiting high speed 失效
    制备含有表现出高速度的片状颗粒的照相乳剂的方法

    公开(公告)号:US4801522A

    公开(公告)日:1989-01-31

    申请号:US171233

    申请日:1988-03-23

    Inventor: Charles D. Ellis

    CPC classification number: G03C1/0051 Y10S430/161 Y10S430/168

    Abstract: Process for preparing a photographic emulsion containing tabular silver halide grains, which exhibit high speed upon sensitization, having a thickness of about 0.05 to 0.5 .mu.m, average grain volume of about 0.05 to 1.0 .mu.m.sup.3 and mean aspect ratio of greater than 2:1 comprisingA. adding silver nitrate to a vessel containing dispersing medium/bromide mixture, initial bromide ion concentration 0.08 to 0.25 N, to form tabular seed grains;B. adding an ammoniacal base solution, to achieve 0.002 to 0.2 normal of the base (e.g., after at least 2% of total silver nitrate has been added); andC. adding additional silver nitrate and halide, e.g., Br.sup.- or BrI.sup.-, by balanced double jet procedure. The emulsions are used in photographic elements for x-ray, graphic arts, etc.

    Abstract translation: 制备含有片状卤化银颗粒的感光乳剂的方法,其在感光时表现出高速度,其厚度为约0.05至0.5μm,平均颗粒体积为约0.05至1.0μm3,平均纵横比大于2:1 包括A.向含有分散介质/溴化物混合物的容器中加入硝酸银,初始溴离子浓度为0.08至0.25N,以形成片状晶粒; B.加入氨基溶液,达到0.002至0.2的碱的正常值(例如,在加入总硝酸银的至少2%之后); 和C.通过平衡双喷射方法加入另外的硝酸银和卤化物,例如Br​​-或BrI-。 该乳剂用于摄影元件中的X射线,平面艺术等。

Patent Agency Ranking