i-nth logo

Authors

John C. Nash, Neil Smith, & Andy Adler

Abstract

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:

  • 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.
  • 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.

Sample

Virtual access to a spreadsheet
Virtual access to a spreadsheet

Our solution to accessing shared spreadsheets is to keep the spreadsheet file in one location where it can be protected by access controls.

Users access the spreadsheet files that reside on a server from their local workstation over a network. A spreadsheet program on the server is used to manipulate the spreadsheet, and access controls limit manipulation of the spreadsheet to this program.

Publication

2003, EuSpRIG

Full article

Audit and change analysis of spreadsheets