Authors
Jong-Myung Choi & Young-Chul Kim
Abstract
Spreadsheets are widely used in various areas by end users because they are easy to use. However, due to the lack of the methodology for analysis and design for spreadsheet applications, users suffer with problems such as high error rates, low reusability, and maintenance difficulties.
To mitigate these problems, we introduce a multi-paradigm spreadsheet that allows end users to analyze their problems and design for the solutions. Our multi-paradigm spreadsheet supports object-oriented programming, flowchart, XML, and spreadsheet. While writing the XML document, they analyze the problems by grouping similar things into one concept, and the concept develops into a class in object-oriented programming. The flowchart and spreadsheet are used for describing operations or methods of the class.
Our multi-paradigm spreadsheet is so simple that even end users can analyze and design for their applications.
Sample
This figure shows the appearance of the multi-paradigm spreadsheet.
When end users key in data into the cell, a new instance is created at first, and the value of the member field is assigned by calling the setter method. While keying in data, the calculation is performed automatically.
The viewing of the member fields on the spreadsheet is done by the calling getter methods.
Publication
2006, International Journal of Computer Science and Network Security, Volume 6, Number 4, April, pages 30-35
