公开(公告)号：US06948154B1

公开(公告)日：2005-09-20

申请号：US09438084

申请日：1999-11-10

申请人： Gregg Evan Rothermel ,  Margaret Myers Burnett ,  Lixin Li

发明人： Gregg Evan Rothermel ,  Margaret Myers Burnett ,  Lixin Li

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

CPC分类号： G06F17/246

摘要： The invention includes a method for testing a spreadsheet cell. Du-associations are collected for the spreadsheet cell. The cell's execution trace is tracked. After the user validates the cell, the du-associations that participated in the execution trace are marked as executed. Du-associations for other cells that are affected by the testing a spreadsheet cell are similarly marking as exercised. If the user changes a cell's contents, the collected du-associations for the cell are discarded and the steps of collecting test elements, tracking execution traces, and marking are repeated. Cells that depend on the changed cell also repeat these steps. After the user marks a cell as validated, a validation symbol is shown on the cell. If the cell's validation status is later brought into question, the validation symbol can change or be removed entirely. The invention also includes a method for providing a user with feedback of the testedness of the spreadsheet cells. The du-associations for each spreadsheet cell are maintained, and the subset of du-associations that have been exercised 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关联的数量，为提供给用户的单元格计算测试度量。

公开(公告)号：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关联的数量，为提供给用户的单元格计算测试度量。

公开(公告)号：US07266763B2

公开(公告)日：2007-09-04

申请号：US10306937

申请日：2002-11-26

申请人： Simon Peyton-Jones ,  Alan Frank Blackwell ,  Margaret Myers Burnett

发明人： Simon Peyton-Jones ,  Alan Frank Blackwell ,  Margaret Myers Burnett

IPC分类号： G06F17/00 ,  G06F7/00

CPC分类号： G06F17/246 ,  Y10S707/99931

摘要： A method of creating a user-defined function in a spreadsheet application is provided. The user-defined function is callable by a calling label in the spreadsheet application. A formula is received in the spreadsheet application. The formula is transferred to a function sheet of the spreadsheet application to define at least a portion of a function body. An interface is defined by identifying the calling label, an input parameter and a result parameter of the user-defined function. The function body operates on an argument corresponding to the input parameter and generates a result corresponding to the result parameter. The interface is stored in association with the function body to create the user-defined function.

摘要翻译： 提供了一种在电子表格应用程序中创建用户定义函数的方法。 用户定义的函数可以通过电子表格应用程序中的调用标签来调用。 在电子表格应用程序中接收到一个公式。 公式被转移到电子表格应用程序的功能表以定义函数体的至少一部分。 通过标识用户定义的函数的调用标签，输入参数和结果参数来定义接口。 功能体对与输入参数相对应的参数进行操作，并生成与结果参数对应的结果。 该界面与函数体相关联存储，以创建用户定义的函数。