Associating conditions to summary table data
    3.
    发明授权
    Associating conditions to summary table data 有权
    将条件与汇总表数据相关联

    公开(公告)号:US08832544B2

    公开(公告)日:2014-09-09

    申请号:US12857067

    申请日:2010-08-16

    IPC分类号: G06F17/30 G06F17/00 G06F17/24

    摘要: A method and system associate conditional formats with selected data points or groups of data points within a summary table. In one embodiment, related groups of data are determined based upon currently highlighted cells in a summary table. A user then selects from the groups and identifies conditional formats to be associated with the specified data points. The conditional formats are associated with currently displayed as well as non-displayed data within the summary table. The associated conditions are saved relative to the data points rather than the original cell positions so that the conditions remain associated with the data points following a reorganization of the summary table.

    摘要翻译: 方法和系统将条件格式与摘要表中的所选数据点或数据点组相关联。 在一个实施例中,基于摘要表中当前突出显示的单元确定相关的数据组。 然后,用户从组中选择并识别与指定数据点相关联的条件格式。 条件格式与摘要表中的当前显示以及未显示的数据相关联。 相关条件相对于数据点而不是原始单元位置被保存,使得条件在重组汇总表之后保持与数据点相关联。

    Associating conditions to summary table data
    6.
    发明授权
    Associating conditions to summary table data 有权
    将条件与汇总表数据相关联

    公开(公告)号:US07779000B2

    公开(公告)日:2010-08-17

    申请号:US11215634

    申请日:2005-08-29

    IPC分类号: G06F17/30

    摘要: A method and system associate conditional formats with selected data points or groups of data points within a summary table. In one embodiment, related groups of data are determined based upon currently highlighted cells in a summary table. A user then selects from the groups and identifies conditional formats to be associated with the specified data points. The conditional formats are associated with currently displayed as well as non-displayed data within the summary table. The associated conditions are saved relative to the data points rather than the original cell positions so that the conditions remain associated with the data points following a reorganization of the summary table.

    摘要翻译: 方法和系统将条件格式与摘要表中的所选数据点或数据点组相关联。 在一个实施例中,基于摘要表中当前突出显示的单元确定相关的数据组。 然后,用户从组中选择并识别与指定数据点相关联的条件格式。 条件格式与摘要表中的当前显示以及未显示的数据相关联。 相关条件相对于数据点而不是原始单元位置被保存,使得条件在重组汇总表之后保持与数据点相关联。

    Block properties and calculated columns in a spreadsheet application
    7.
    发明授权
    Block properties and calculated columns in a spreadsheet application 有权
    阻止电子表格应用程序中的属性和计算列

    公开(公告)号:US08621340B2

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

    申请号:US11018418

    申请日:2004-12-20

    IPC分类号: G06F17/16 G06F17/30

    CPC分类号: G06F17/246

    摘要: Block properties and improved calculated columns properties are provided in a spreadsheet application. Once block properties are set for a group of spreadsheet cells or a spreadsheet list, the properties may be applied to the entire group of selected cells or list as opposed to requiring application of properties to individual cells. If rows or columns are added to the group of selected cells or list, properties applied to the group of cells or list are automatically applied to the new rows or columns. Block properties also provide for intelligent-behaving list borders where list borders are not corrupted by the movement or changing of columns or rows sharing edges with a list border. Calculated columns are a type of block property that extends the functionality of formulas throughout an entire column of an associated group of cells or list.

    摘要翻译: 电子表格应用程序中提供了块属性和改进的计算列属性。 一旦为一组电子表格单元格或电子表格列表设置了块属性,则可以将属性应用于所选单元格或列表的整个组,而不是要求将属性应用于单个单元格。 如果将行或列添加到所选单元格或列表的组中,则应用于单元格或列表组的属性将自动应用于新行或列。 块属性还提供智能行为列表边框,其中列表边框没有被列表边框移动或更改列或列共享边缘而损坏。 计算的列是一种类型的块属性,可以在关联的单元格或列表组的整个列中扩展公式的功能。

    Utilizing spreadsheet references with grouped aggregate views
    9.
    发明授权
    Utilizing spreadsheet references with grouped aggregate views 有权
    利用分组的聚合视图的电子表格引用

    公开(公告)号:US08185817B2

    公开(公告)日:2012-05-22

    申请号:US12141114

    申请日:2008-06-18

    CPC分类号: G06F17/246

    摘要: Various technologies and techniques are disclosed for utilizing spreadsheet references with grouped aggregate views. A grouped aggregate view feature enables a user to create a grouped aggregate view of data. A calculation feature enables the user to calculations for the grouped aggregate view of data that are based upon relative or absolute references to data in the grouped aggregate view. Input is received from a user to write a calculation within a first cell in a grouped aggregate view. Input is received from the user to select a second cell to reference when writing the calculation. The user is presented with available references that are relevant to data contained in the second cell. Input is received from the user to select one of the available references that are relevant for the second cell. The selected one of the available references is placed into the first cell.

    摘要翻译: 公开了利用具有分组聚集视图的电子表格引用的各种技术和技术。 分组的聚合视图功能使用户能够创建数据的分组聚合视图。 计算功能使用户能够对分组的聚合视图数据进行计算,该视图基于分组聚合视图中对数据的相对或绝对引用。 从用户接收输入以在分组聚合视图中的第一个单元格内写入计算。 从用户接收到输入,以便在写入计算时选择第二个单元格进行参考。 向用户呈现与第二小区中包含的数据相关的可用参考。 从用户接收输入以选择与第二小区相关的可用参考之一。 所选择的一个可用参考被放入第一个单元格中。

    ASSOCIATING CONDITIONS TO SUMMARY TABLE DATA
    10.
    发明申请
    ASSOCIATING CONDITIONS TO SUMMARY TABLE DATA 有权
    摘要表数据的相关条件

    公开(公告)号:US20110035653A1

    公开(公告)日:2011-02-10

    申请号:US12857067

    申请日:2010-08-16

    IPC分类号: G06F17/00

    摘要: A method and system associate conditional formats with selected data points or groups of data points within a summary table. In one embodiment, related groups of data are determined based upon currently highlighted cells in a summary table. A user then selects from the groups and identifies conditional formats to be associated with the specified data points. The conditional formats are associated with currently displayed as well as non-displayed data within the summary table. The associated conditions are saved relative to the data points rather than the original cell positions so that the conditions remain associated with the data points following a reorganization of the summary table.

    摘要翻译: 方法和系统将条件格式与摘要表中的所选数据点或数据点组相关联。 在一个实施例中,基于摘要表中当前突出显示的单元确定相关的数据组。 然后,用户从组中选择并识别与指定数据点相关联的条件格式。 条件格式与摘要表中的当前显示以及未显示的数据相关联。 相关条件相对于数据点而不是原始单元位置被保存,使得条件在重组汇总表之后保持与数据点相关联。