ClassSheets - model-based, object-oriented design of spreadsheet applications

By: Jan-Christopher Bals, Fabian Christ, Gregor Engels, Martin Erwig

Abstract

Using spreadsheets is the preferred method to calculate, display or store anything that fits into a table-like structure. They are often used by end users to create applications. But they have one critical drawback - they are very error-prone. To reduce the error-proneness, we purpose a new way of object-oriented modeling of spreadsheets prior to using them. These spreadsheet models, termed ClassSheets, are used to generate concrete spreadsheets on the instance level. By this approach sources of errors are reduced and spreadsheet applications are easier to understand.

Cite as:

Jan-Christopher Bals, Fabian Christ, Gregor Engels, Martin Erwig, “ClassSheets - model-based, object-oriented design of spreadsheet applications”, Journal of Object Technology, Volume 6, no. 9 (October 2007), pp. 383-398, doi:10.5381/jot.2007.6.9.a19.