公开(公告)号：US06766509B1

公开(公告)日：2004-07-20

申请号：US09472771

申请日：1999-12-27

申请人： Andrei Ernstovich Sheretov ,  Margaret Myers Burnett ,  Gregg Evan Rothermel

发明人： Andrei Ernstovich Sheretov ,  Margaret Myers Burnett ,  Gregg Evan Rothermel

IPC分类号： G06F944

CPC分类号： G06F17/246

摘要： The invention includes two methods for testing a spreadsheet region. Du-associations are collected for the spreadsheet region. In the Straightforward approach, du-associations are collected for each cell in the region. Each cell's execution trace is tracked. After the user validates a cell, the du-associations for the cell that participated in the execution trace are marked as executed. In the Region Representative approach, a region representative represents the region. Each cell's execution trace is tracked. After the user validates a cell, the du-associations for the region representative that participated in the execution trace for the validated cell are marked as executed. Du-associations for other cells that are affected by the testing of a spreadsheet region are similarly marked as covered. If the user changes a shared non-constant formula, the collected du-associations for the region are discarded and the steps of collecting test elements and tracking execution traces are repeated. Cells that depend on the changed cell also partially discard and collect anew test elements and repeat the tracking step. The invention also includes a method for providing a user with feedback of the testedness of the spreadsheet region. The du-associations for each region are maintained, and the subset of du-associations that have been covered is identified. Using the numbers of tested and untested du-associations, a testedness measure is calculated for the cell, which is provided to the user.

摘要翻译： 本发明包括用于测试电子表格区域的两种方法。 为电子表格区域收集了杜协会。 在简单的方法中，针对该地区的每个单元收集双关联。 跟踪每个单元格的执行跟踪。 在用户验证单元后，参与执行跟踪的单元格的du关联标记为已执行。 在区域代表方式中，区域代表代表该地区。 跟踪每个单元格的执行跟踪。 用户验证单元后，参与执行跟踪的区域代表的du关联被标记为已执行。 受电子表格区域测试影响的其他单元的相关性同样标记为覆盖。 如果用户改变共享的非常数公式，则丢弃该区域的收集的二关联，并重复收集测试元素和跟踪执行跟踪的步骤。 依赖于改变的细胞的细胞也部分地丢弃并收集新的测试元件并重复跟踪步骤。 本发明还包括一种用于向用户提供电子表格区域的测试的反馈的方法。 维护每个区域的协会，并确定已被覆盖的双关联的子集。 使用测试和未测试的du关联的数量，为提供给用户的单元格计算测试度量。