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

1. 发明授权

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.
摘要翻译：本发明涉及用于在电子表格图形用户界面内显示内容的系统和方法的新的和改进的实施例。在一个实施例中，计算机系统具有执行用于在电子表格应用程序内显示数据的方法的图形用户界面。该方法包括显示公式栏，其包括显示电子表格中包含的数据的文本框，在文本框中显示电子表格数据的第一部分，以及扩展公式栏以在文本框中显示电子表格数据的第二部分。

2. 发明授权

US07933862B2 One click conditional formatting method and system for software programs 有权
标题翻译：一键式条件格式化方法和软件程序系统
公开(公告)号：US07933862B2
公开(公告)日：2011-04-26
申请号：US10951468
申请日：2004-09-27
申请人： Benjamin C. Chamberlain , Brandon G. Weber , Bruce Cordell Jones , Charles D. Ellis , Christopher M. Street , David E. Gainer , Eric B. Vigesaa
发明人： Benjamin C. Chamberlain , Brandon G. Weber , Bruce Cordell Jones , Charles D. Ellis , Christopher M. Street , David E. Gainer , Eric B. Vigesaa
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/246
摘要： A method of conditionally formatting a display of data is disclosed that involves providing a preliminary display automatically showing the intended consequences of the condition applied to the data prior to making the condition actually apply to the data. This is especially useful in analysis of spreadsheet data by conditionally formatting certain data. The method involves identifying one or more parameters of the data to be conditionally formatted on the display, selecting a predetermined condition; and automatically applying temporarily the predetermined condition to the parameter(s), displaying a temporary preview on the display of the predetermined condition applied to data that meet the predetermined condition. The method also provides the capability to preliminarily change the conditions and parameters applied to the data and automatically provide appropriate previews of the effect of such application of changed conditions on the displayed data.
摘要翻译：公开了一种有条件地格式化数据显示的方法，其涉及提供在使条件实际应用于数据之前自动显示应用于数据的条件的预期后果的初步显示。这对通过有条件地格式化某些数据来分析电子表格数据特别有用。该方法包括识别要在显示器上有条件地格式化的数据的一个或多个参数，选择预定条件; 并且自动地将预定条件临时应用于参数，在显示上显示应用于满足预定条件的数据的预定条件的临时预览。该方法还提供初步改变应用于数据的条件和参数的能力，并自动提供对所显示数据的变更条件的应用效果的适当预览。

3. 发明授权

US07634730B2 Task helpers 有权
标题翻译：任务助手
公开(公告)号：US07634730B2
公开(公告)日：2009-12-15
申请号：US11014013
申请日：2004-12-15
申请人： Brandon G. Weber , Charles D. Ellis
发明人： Brandon G. Weber , Charles D. Ellis
IPC分类号： G06F13/00 , G06F17/00
CPC分类号： G06F17/246
摘要： The present invention provides a set of task-based helpers that automatically generate formulas that complete a task for the user. In one embodiment, the task helpers automatically create a formula from one or more functions that help complete more complicated tasks. The present invention also provides embodiments of user interfaces that help the user select the appropriate task helper and receive the discrete parameters of the formula for the task.
摘要翻译：本发明提供一组基于任务的助手，其自动生成为用户完成任务的公式。在一个实施例中，任务帮助者自动从一个或多个功能创建一个有助于完成更复杂任务的功能的公式。本发明还提供了帮助用户选择适当的任务帮助者并且接收用于该任务的公式的离散参数的用户界面的实施例。

4. 发明授权

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.

5. 发明授权

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

6. 发明申请

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，成员属性和与集合有关的计数。电子表格中的多维数据集功能可以从一个或多个多维数据库访问多维数据集数据。在单个单元格中使用多维数据集公式允许用户从电子表格中添加/删除行和/或列。

7. 发明授权

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

8. 发明授权

US07805433B2 Multidimensional cube functions 有权
标题翻译：多维立方体函数
公开(公告)号：US07805433B2
公开(公告)日：2010-09-28
申请号：US11251598
申请日：2005-10-14
申请人： 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分类号： G06F7/00 , G06F17/00
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，成员属性和与集合有关的计数。电子表格中的多维数据集功能可以从一个或多个多维数据库访问多维数据集数据。在单个单元格中使用多维数据集公式允许用户从电子表格中添加/删除行和/或列。

9. 发明授权

US6055978A Fireplace log retainer 失效
标题翻译：壁炉日志保持架
公开(公告)号：US6055978A
公开(公告)日：2000-05-02
申请号：US108207
申请日：1998-07-01
申请人： Charles D. Ellis
发明人： Charles D. Ellis
IPC分类号： F24B1/193 , F23B1/193
CPC分类号： F24B1/193
摘要： 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.
摘要翻译：对数保持器具有两个或更多个通过横杆连接在一起的安装支架。每个安装支架具有下安装臂和上安装臂，其用于将保持器连接到格栅而不调整格栅。每个下安装臂具有从其延伸的指状物，并且每个上安装臂具有从其延伸的拇指，格栅的指状物和拇指接合构件，以支撑安装支架，并在格栅上方横向固定，以将原木保持在炉排

10. 发明授权

US08745482B2 Sorting spreadsheet data by format 有权
标题翻译：按格式排序电子表格数据
公开(公告)号：US08745482B2
公开(公告)日：2014-06-03
申请号：US12869367
申请日：2010-08-26
申请人： Charles D. Ellis , David F. Gainer , Samuel C. Radakovitz , Yonghong Zeng , Dave McDonald
发明人： Charles D. Ellis , David F. Gainer , Samuel C. Radakovitz , Yonghong Zeng , Dave McDonald
IPC分类号： G06F17/00
CPC分类号： G06F17/246 , G06F3/0482 , G06F3/04847 , G06F17/212
摘要： 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.
摘要翻译：本发明包括用于组织数据应用中显示的数据的方法和用户界面。具体地，本发明提供了用于通过应用于数据的一个或多个部分的格式来布置数据显示的方法和系统。格式包括显示数据的不同视觉特征。在示例性实施例中，数据应用程序通过单元格的填充颜色，单元格内的数据的字体颜色或插入单元格的图标的类型来组织数据。组织包括数据的任何类型的重新排列。在示例性实施例中，数据应用根据格式对所显示的数据进行排序或过滤。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式