公开(公告)号：EP1643387A3

公开(公告)日：2007-01-10

申请号：EP05105344.5

申请日：2005-06-17

申请人： MICROSOFT CORPORATION

发明人： Becker, Andrew J. ,  Ellis, Charles D. ,  Chirilov, Joseph M. ,  Niemisto, Juha P ,  Androski, Matthew J. ,  Collie, Robert C. ,  Hawking, Robert G. ,  Peyton-Jones, Simon

IPC分类号： 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.

公开(公告)号：EP1643387A2

公开(公告)日：2006-04-05

申请号：EP05105344.5

申请日：2005-06-17

申请人： MICROSOFT CORPORATION

发明人： Becker, Andrew J. ,  Ellis, Charles D. ,  Chirilov, Joseph M. ,  Niemisto, Juha P ,  Androski, Matthew J. ,  Collie, Robert C. ,  Hawking, Robert G. ,  Peyton-Jones, Simon

IPC分类号： 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.

摘要翻译： 本发明提供了几个数据库公式确实可以操纵大型数据集。 每个数据库式是可定制的和可重复的，而无需用户干预。 因此，用户可以通过输入多种选择确实可以覆盖用户的愿望输出某些形式或格式的数据，选择一组输入数据，并始终得到一组输出数据。 在一些实施例中，用户可参考该组数据的语义而不是指定的范围内的细胞的数据库公式中使用的。 参照数据语义允许数据库公式调整到在细胞的新数据可以占据的范围内改变。

公开(公告)号：EP1643375A2

公开(公告)日：2006-04-05

申请号：EP05105242.1

申请日：2005-06-15

申请人： MICROSOFT CORPORATION

发明人： Becker, Andrew J. ,  Ellis, Charles D. ,  Chirilov, Joseph M. ,  Niemisto, Juha P. ,  Androski, Matthew J. ,  Collie, Robert C. ,  Hawking, Robert G. ,  Peyton-Jones, Simon ,  Zhong, Weide

IPC分类号： G06F17/24

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.

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

公开(公告)号：EP1640875B1

公开(公告)日：2013-11-06

申请号：EP05105810.5

申请日：2005-06-29

申请人： MICROSOFT CORPORATION

发明人： Jones, Bruce Cordell ,  Rothschiller, Chad B. ,  Gainer, David F. ,  Campbell, Duane ,  Duzak, Jeffrey J. ,  Androski, Matthew J.

IPC分类号： G06F17/24 ,  G06F9/46

CPC分类号： G06F9/505 ,  G06F17/246

公开(公告)号：EP1643375A3

公开(公告)日：2008-03-05

申请号：EP05105242.1

申请日：2005-06-15

申请人： MICROSOFT CORPORATION

发明人： Becker, Andrew J. ,  Ellis, Charles D. ,  Chirilov, Joseph M. ,  Niemisto, Juha P. ,  Androski, Matthew J. ,  Collie, Robert C. ,  Hawking, Robert G. ,  Peyton-Jones, Simon ,  Zhong, Weide

IPC分类号： G06F17/24

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.

公开(公告)号：EP1640875A3

公开(公告)日：2008-04-16

申请号：EP05105810.5

申请日：2005-06-29

申请人： MICROSOFT CORPORATION

发明人： Jones, Bruce Cordell ,  Rothschiller, Chad B. ,  Gainer, David F. ,  Campbell, Duane ,  Duzak, Jeffrey J. ,  Androski, Matthew J.

IPC分类号： G06F17/24 ,  G06F9/46

CPC分类号： G06F9/505 ,  G06F17/246

摘要： Embodiments of the invention involve a method of concurrent processing of chain calculations using multiple processors each having a separate recalculation engine in a spreadsheet program. The operations basically include first determining a number of available processors, then allocating a recalculation engine to each available processor, distributing the formulas between the recalculation engines, and then concurrently evaluating the formulas distributed to each recalculation engine when a recalc operation is called for in the spreadsheet program.

公开(公告)号：EP1640875A2

公开(公告)日：2006-03-29

申请号：EP05105810.5

申请日：2005-06-29

申请人： MICROSOFT CORPORATION

发明人： Jones, Bruce Cordell ,  Rothschiller, Chad B. ,  Gainer, David F. ,  Campbell, Duane ,  Duzak, Jeffrey J. ,  Androski, Matthew J.

IPC分类号： G06F17/24 ,  G06F9/46

CPC分类号： G06F9/505 ,  G06F17/246

摘要： Embodiments of the invention involve a method of concurrent processing of chain calculations using multiple processors each having a separate recalculation engine in a spreadsheet program. The operations basically include first determining a number of available processors, then allocating a recalculation engine to each available processor, distributing the formulas between the recalculation engines, and then concurrently evaluating the formulas distributed to each recalculation engine when a recalc operation is called for in the spreadsheet program.

摘要翻译： 本发明的实施例涉及一种使用多个处理器并行处理链计算的方法，每个处理器在电子表格程序中具有单独的重新计算引擎。 这些操作基本上包括首先确定可用处理器的数量，然后将重新计算引擎分配给每个可用的处理器，在重新计算引擎之间分配公式，然后在再次计算引擎中调用重新计算操作时同时评估分配给每个重新计算引擎的公式 电子表格程序。