图纸的审核和变更分析
Audit and Change Analysis of Spreadsheets
摘要：
由于电子表格在实际工作中的重要性越来越大，因此需要控制和验证其内容。一般来说，电子表格很难验证，因为数据和可执行信息存储在一起。具有多个作者的电子表格应用程序尤其难以验证，因为对访问的控制难以实施。面对类似的问题，传统的软件工程已经开发了许多工具和方法来控制，验证和审计大型应用程序与多个开发人员。我们提出了一些工具，我们已经开发，使1）审计选定的，过滤，或所有的变化，在一个电子表格中，也就是说，当一个单元格被改变，其原始和新的内容和谁作出了改变，和2）控制访问电子表格文件（S），使审计是值得信赖的。我们的工具适用于OpenOffice.org计算电子表格，通常可以与Microsoft Excel交换。
英文摘要：
Because spreadsheets have a large and growing importance in real-world work, their contents need to be controlled and validated. Generally spreadsheets have been difficult to verify, since data and executable information are stored together. Spreadsheet applications with multiple authors are especially difficult to verify, since controls over access are difficult to enforce. Facing similar problems, traditional software engineering has developed numerous tools and methodologies to control, verify and audit large applications with multiple developers. We present some tools we have developed to enable 1) the audit of selected, filtered, or all changes in a spreadsheet, that is, when a cell was changed, its original and new contents and who made the change, and 2) control of access to the spreadsheet file(s) so that auditing is trustworthy. Our tools apply to OpenOffice.org calc spreadsheets, which can generally be exchanged with Microsoft Excel.
机构、总结、中文摘要均由AI分析而来，可能存在错误，请以论文正文为准。
