公开(公告)号：EP1645972A3

公开(公告)日：2008-07-09

申请号：EP05105354.4

申请日：2005-06-17

申请人： MICROSOFT CORPORATION

发明人： Chamberlain, Benjamin C. ,  Weber, Brandon G. ,  Jones, Bruce Cordell ,  Ellis, Charles D. ,  Street, Christopher M. ,  Gainer, David F. ,  Vigesaa, Eric B.

IPC分类号： G06F17/24

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.

公开(公告)号：EP2738684A1

公开(公告)日：2014-06-04

申请号：EP14000551.3

申请日：2007-01-18

申请人： MICROSOFT CORPORATION

发明人： Chamberlain, Benjamin C. ,  Jones, Bruce Cordell ,  Street, Christopher M. ,  Vigesaa, Eric B.

IPC分类号： G06F17/24 ,  G06F17/21

CPC分类号： G06F17/246 ,  G06F17/211

摘要： Generally described, embodiments of the present invention relate to applying and evaluating an unlimited number of conditional formatting rules to a given range of cells. Additionally, multiple conditional formatting rules may be evaluated to TRUE for the same cell contained in a user interface and multiple formats applied to that cell.

摘要翻译： 通常描述，本发明的实施例涉及将无限数量的条件格式化规则应用于并且评估给定的小区范围。 此外，对于包含在用户界面中的相同单元格以及应用于该单元格的多种格式，可以将多个条件格式化规则评估为TRUE。

公开(公告)号：EP1645972A2

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

申请号：EP05105354.4

申请日：2005-06-17

申请人： MICROSOFT CORPORATION

发明人： Chamberlain, Benjamin C. ,  Weber, Brandon G. ,  Jones, Bruce Cordell ,  Ellis, Charles D. ,  Street, Christopher M. ,  Gainer, David F. ,  Vigesaa, Eric B.

IPC分类号： G06F17/24

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.

摘要翻译： 的有条件地格式化数据的显示图像的方法，游离缺失盘没有涉及提供初步显示自动示出施加到之前制备的条件实际上适用于该数据的数据的条件的预期的后果。 这通过有条件地格式化某些数据是在电子表格中的数据进行分析的爱情特别有用。 该方法包括识别所述数据的一个或多个参数被条件格式化的所述显示器上，选择预定条件; 和自动施加暂时预定条件的参数（一个或多个），施加到数据的预定条件的所述显示器上显示临时预览没有满足预定条件。 因此，该方法提供对预先改变施加到该数据的条件和参数，并自动提供的寻求对所显示的数据改变的条件的应用程序的影响的适当的预览的能力。