Journal of KIISE:Software and Applications (한국정보과학회논문지:소프트웨어및응용)

Korean Institute of Information Scientists and Engineers (한국정보과학회)
권호 표지

XCEL: Object-oriented Spreadsheet

XCEL: 객체지향 스프레드시트

  • Published : 2003.12.01
Download PDF
⟨ Previous Next ⟩

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.

스프레드시트는 사용하기 쉽기 때문에 가장 널리 사용되는 프로그래밍 도구이지만, 아직까지 스프레드시트 응용프로그램 개발에 객체지향 기술을 적용하려는 시도는 상대적으로 적었다. 일반적으로 스프레드시트 응용프로그램은 내부에 많은 오류를 포함하고 있으며, 재사용성이 낮고, 유지 보수가 어려운 단점을 가지고 있다. 이러한 문제를 해결하기 위해서 본 논문에서는 XCEL이라는 객체지향 스프레드시트를 소개한다. XCEL은 스프레드시트 응용프로그램을 체계적으로 개발하기 위한 데이타 모델링 방법과 스프레드시트에서 객체지향 프로그래밍을 표현하기 위한 방법을 지원한다. XCEL은 데이타 모델링에서 XML과 플로우차트를 이용해서 클래스를 정의하고, 스프레드시트에서는 연속된 셀들의 영역을 이용해서 객체들을 표현한다. XCEL을 이용하면 스프레드시트 응용프로그램 개발에 객체지향 기술들을 그대로 적용할 수 있는 장점이 있다.

Keywords

References

  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. Ed Haui-hsin Chi et al, 'A Spreadsheet Approach to Information Visualization,' in Proc. of Information Visualization Symposium, pp. 17-24, 1997
  3. Jeff A. Johnson et aI, 'Ace: Building Interactive Graphics Applications,' in Comm of the ACM, Vol. 36, No. 4, pp, 41-55, 1993 https://doi.org/10.1145/255950.153576
  4. Panko R. R., Spreadsheet Research(SSR) Website (http://panko.cba.hawaii.edu/ssr/) Honolulu, Hawaii: University of Hawaii
  5. Coopers & Lybrand in London. Description available at http://www.planningobjects.com/junglel.htm
  6. 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
  7. 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
  8. 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
  9. 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
  10. Takeo Igarashi et al, 'Fluid Visualization of Spreadsheet Structures,' in IEEE Symposium on Visual Languages, pp. 118-125, 1998
  11. 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 https://doi.org/10.1145/195705.195708
  12. A.E. DiAntonio, Spreadsheet Applications, Prentice-Hall, 1986
  13. Jocelyn Paine, 'Model Master: an object-oriented spreadsheet front end,' in Proc. of CALECO97, 1997. available at http://www.ifs.org.uk/~popx/
  14. Jocelyn Paine, 'Ensuring Spreadsheet Integrity with Model Master,' in Proc. of EuSpRIG, 2001. available at http://www.ifs.org.uk/~popx/
  15. 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 https://doi.org/10.1006/ijhc.1994.1047
  16. 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 https://doi.org/10.1006/jvlc.1994.1003
  17. Walpole Djang et al, 'Similarity Inheritance: A New Model of Inheritance for spreadsheet VPLs,' in IEEE Symposium on Visual Languages. pp. 134-141, 1998
  18. Jay Earley and Howard Sturgis, 'A Formalism for Translator Interactions,' in Comm. of ACM, Vol. 13. No. 10, pp. 607-617, 1970 https://doi.org/10.1145/355598.362740
  19. Michael Spenke and Christian Beilken, 'A Spreadsheet Interface for Logic Programming,' in CHI, pp. 75-80, 1988 https://doi.org/10.1145/67449.67466
  20. Chris Clack and Lee Braine, 'Object-oriented functional spreadsheets,' in Proc. of the Glasgow Workshop on Functional Programming, pp. 1 -12, 1997
  21. 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/
  22. Steve Wilson, 'Building a Visual Programming Language,' in MacTech, Vol. 13, No. 4, 1997. available at http://www.mactech.com/
  23. Piersol, K. W., 'Object Oriented Spreadsheets: The Analytic Spreadsheet Package,' in OOPSLA'86. pp. 385-390. 1986 https://doi.org/10.1145/28697.28737
  24. 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/
  25. 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 https://doi.org/10.1145/366378.366385
  26. Brian Knight, David Chadwick and Kamalasen Rajalingham, 'A Structured Methodology for Spreadsheet Modelling,' in Proc. of EuSpRIG, pp. 43-50, 2001