Browse > Article

XCEL: Object-oriented Spreadsheet  

최종명 (숭실대학교 컴퓨터학과)
유재우 (숭실대학교 컴퓨터학과)
Abstract
Spreadsheet is one of the most widely used programming tool because of its ease of use, however there have been few researches on applying object-oriented techniques in developing spreadsheet applications. Generally, spreadsheet applications contain a lot of errors, and spreadsheet has some drawbacks such as low reusability and hard maintenance. In order to solve these problems, we introduce an object-oriented spreadsheet system, named XCEL. It enables users to develop applications using systematic techniques with data modelling method, and allows users to apply object-oriented technologies to spreadsheet programming. The data modelling method allows to define classes using XML and flowchart, and the spreadsheet represents an object with contiguous cells. XCEL has advantage that users can apply object-oriented technology to spreadsheet programming.
Keywords
XML; object-oriented; spreadsheet; end-user computing; XML;
Citations & Related Records
연도 인용수 순위
  • Reference
1 D. Bricklin and B. Frankston, 'VisiCalc; Information from its creators, Dan Bricklin and Bob Frankston', 1999. available at http://www.bricklin.com/visicalc.htm
2 Brian Knight, David Chadwick and Kamalasen Rajalingham, 'A Structured Methodology for Spreadsheet Modelling,' in Proc. of EuSpRIG, pp. 43-50, 2001
3 Jim Hugunin, 'Python and Java: The Best of Both Worlds,' in Proc. of the 6th International Python Conference, 1997. available at http://www.jython.org/
4 Gregg Rothermel, et al, 'A Methodology for Testing Spreadsheets,' in ACM Transaction on Software Engineering and Methodology, Vol. 10, No. 1, pp. 110-147, 2001   DOI
5 Bjorn Lisper and Johan Malmstrom, 'Haxcel: A Spreadsheet Interface to Haskell,' in Proc. of International Workshop on the Implementation of Functional Languages, pp. 206-222, 2002. available at http://www.mrtc.mdh.se/
6 Steve Wilson, 'Building a Visual Programming Language,' in MacTech, Vol. 13, No. 4, 1997. available at http://www.mactech.com/
7 Piersol, K. W., 'Object Oriented Spreadsheets: The Analytic Spreadsheet Package,' in OOPSLA'86. pp. 385-390. 1986   DOI
8 Michael Spenke and Christian Beilken, 'A Spreadsheet Interface for Logic Programming,' in CHI, pp. 75-80, 1988   DOI
9 Chris Clack and Lee Braine, 'Object-oriented functional spreadsheets,' in Proc. of the Glasgow Workshop on Functional Programming, pp. 1 -12, 1997
10 Walpole Djang et al, 'Similarity Inheritance: A New Model of Inheritance for spreadsheet VPLs,' in IEEE Symposium on Visual Languages. pp. 134-141, 1998
11 Jay Earley and Howard Sturgis, 'A Formalism for Translator Interactions,' in Comm. of ACM, Vol. 13. No. 10, pp. 607-617, 1970   DOI
12 Hendry D.G. and Green T.R.G. 'Creating. comprehending. and explaining spreadsheets: a cognitive interpretation of what discretionary users think of the spreadsheet model,' in International Journal of Human-Computer Studies. Vol. 40, No. 6, pp. 1033-1065, 1994   DOI   ScienceOn
13 M. Burnett and A. Amblerr, 'Interactive Visual Data Abstraction in a Declarative Visual Programming Language, in Journal of Visual Languages and Computing,' pp. 29-60. Mar., 1994   DOI   ScienceOn
14 Jocelyn Paine, 'Model Master: an object-oriented spreadsheet front end,' in Proc. of CALECO97, 1997. available at http://www.ifs.org.uk/~popx/
15 Jocelyn Paine, 'Ensuring Spreadsheet Integrity with Model Master,' in Proc. of EuSpRIG, 2001. available at http://www.ifs.org.uk/~popx/
16 A.E. DiAntonio, Spreadsheet Applications, Prentice-Hall, 1986
17 Takeo Igarashi et al, 'Fluid Visualization of Spreadsheet Structures,' in IEEE Symposium on Visual Languages, pp. 118-125, 1998
18 Tomas Isakowitz, Shimon Schocken and Henry C. Lucas, Jr, 'Toward a Logical/Physical Theory of Spreadsheet Modeling,' in ACM Transactions on Information Systems, Vol. 13, No. 1, pp. 1-37, Jan, 1995   DOI   ScienceOn
19 Panko R.R and Halverson R.P. Jr., 'Spreadsheets on Trial: A Framework for Research on Spreadsheet Risks,' in Proc. of the 29th Hawaii International Conference on System Sciences, 1996
20 Jorma Sajaniemi, Markku Tukianinen and Jarmo Vaisanen, 'Goals and Plans in Spreadsheet Calculation,' in Technical Report A-1999-1, Dept. of Computer Science, University of Joensuu, 1999
21 Panko R. R., Spreadsheet Research(SSR) Website (http://panko.cba.hawaii.edu/ssr/) Honolulu, Hawaii: University of Hawaii
22 Coopers & Lybrand in London. Description available at http://www.planningobjects.com/junglel.htm
23 Raymond J Butler, 'Is This Spreadsheet a Tax Evader? How H.M. Customs & Excise Test Spreadsheet Applications,' in Proc. of the 33rd Hawaii International Conference on System Sciences, 2000
24 Kamalasen Rajalingham et aI, 'Quality Control in Spreadsheets: A Software Engineering-Based Approach to Spreadsheet Development,' in Proc. of the 33rd Hawaii nternational Conference on System Sciences, 2000
25 Ed Haui-hsin Chi et al, 'A Spreadsheet Approach to Information Visualization,' in Proc. of Information Visualization Symposium, pp. 17-24, 1997
26 Jeff A. Johnson et aI, 'Ace: Building Interactive Graphics Applications,' in Comm of the ACM, Vol. 36, No. 4, pp, 41-55, 1993   DOI   ScienceOn