Extending the boundary of spreadsheet programming: Lessons learned from Chinese governmental projects

Spreadsheet is one of the most commonly used end user programming environments. As such, there has been significant effort made by researchers and the industry to develop techniques and tools to improve spreadsheets. In the course of developing spreadsheet-based applications in Chinese governmental projects, we found that enabling end-user to program on the all-in-one, hard-to-validate Chinese spreadsheet is a very challenging task. To do so, we construct system on MS Excel, and provide additional, yet customized, script language for end-user programming.

[1]  Marko C. J. D. van Eekelen,et al.  Implementing a Functional Spreadsheet in Clean , 1995, J. Funct. Program..

[2]  Margaret M. Burnett,et al.  End user software engineering: CHI 2007 special interest group meeting , 2007, CHI Extended Abstracts.

[3]  Alan G. Yoder,et al.  Real spreadsheets for real programmers , 1994, Proceedings of 1994 IEEE International Conference on Computer Languages (ICCL'94).

[4]  Raymond R. Panko,et al.  Spreadsheets on trial: a survey of research on spreadsheet risks , 1996, Proceedings of HICSS-29: 29th Hawaii International Conference on System Sciences.

[5]  Brad A. Myers,et al.  The impact of human-centered features on the usability of a programming system for children , 2002, CHI Extended Abstracts.

[6]  R. Abraham,et al.  How to communicate unit error messages in spreadsheets , 2005, WEUSE@ICSE.

[7]  Jinho Kim,et al.  An Efficient Approach for Providing multidimensional Data on Relational DBMSs , 2007 .

[8]  Gregg Rothermel,et al.  A Methodology to Improve Dependability in Spreadsheets , 2007, End-User Software Engineering.

[9]  Abhinav Gupta,et al.  Advanced SQL modeling in RDBMS , 2005, TODS.

[10]  Jing Li,et al.  On Reducing the Pre-release Failures of Web Plug-In on Social Networking Site , 2009, ICSP.

[11]  Marc Stadelmann.  A spreadsheet based on constraints , 1993, UIST '93.

[12]  A. Karimi,et al.  Master‟s thesis , 2011 .

[13]  Walter A. C. A. J De Hoon.  Designing a spreadsheet in a pure functional graph rewriting language , 1993 .

[14]  Johan Malmström,et al.  Haxcel A spreadsheet interface to Haskell written in Java. , 2004 .

[15]  Guijun Wang,et al.  Solving display-based problems , 1996, Proceedings 1996 IEEE Symposium on Visual Languages.

[16]  Andrew P. Wack.  Partitioning dependency graphs for concurrent execution: a parallel spreadsheet on a realistically modeled message passing environment , 1996 .

[17]  Gregg Rothermel,et al.  End-user software engineering , 2004, Commun. ACM.

[18]  Brad A. Myers,et al.  Six Learning Barriers in End-User Programming Systems , 2004, 2004 IEEE Symposium on Visual Languages - Human Centric Computing.

[19]  Alan G. Yoder,et al.  Observations on Spreadsheet Languages, Intension and Dataflow , 1994 .

[20]  Fabian Nuñez,et al.  An extended spreadsheet paradigm for data visualisation systems, and its implementation , 2000 .

[21]  Damianos Chatziantoniou.  Evaluation of ad hoc OLAP: in-place computation , 1999, Proceedings. Eleventh International Conference on Scientific and Statistical Database Management.

[22]  Margaret M. Burnett,et al.  Forms/3: A first-order visual language to explore the boundaries of the spreadsheet paradigm , 2001, Journal of Functional Programming.