An Approach of Test Case Generation for Spreadsheet Cells

  • Bo YangEmail author
  • Qian YuEmail author
Conference paper
Part of the Lecture Notes in Electrical Engineering book series (LNEE, volume 474)


Spreadsheet is one of the most commonly programming environment, widely adopted for data processing, template building and decision making. However, using spreadsheet often leads to serious consequences because of all kinds of errors in it. This paper presents a tool for test case generation based on data mutation and code smells. Including two steps, detecting sheets types and spreadsheet cells test cases generation. And we perform an experiment with our method, the result demonstrates the effectiveness of our test case generation method. At last, the future work of spreadsheet debugging technology is proposed.


Spreadsheet Test cases generation Error detection Data mutation Code smells 


  1. 1.
    Bhargava, H.K., Sridhar, S., Herrick, C.: Beyond spreadsheets: tools for building decision support systems. IEEE Comput. 32(3), 31–39 (2002)CrossRefGoogle Scholar
  2. 2.
    Ditlea, S.: Spreadsheets can be hazardous to your health. Pers. Comput. 11(1), 60–69 (1987)Google Scholar
  3. 3.
    Brown, P.S., Gould, J.D.: An experimental study of people creating spreadsheets. ACM Trans. Office Inf. Syst. 5(3), 258–272 (1987)CrossRefGoogle Scholar
  4. 4.
    Lerch, J.F., Mantei, M., Olson, J.R.: Skilled financial planning: the cost of translating ideas into action. In: ACM Conference on Human Factors in Computing Systems, pp. 121–126 (1989)Google Scholar
  5. 5.
    Rajalingham, K., Chadwick, D., Knight, B., Edwards, D.: Quality control in spreadsheets: a software engineering based approach to spreadsheet development. In: 33rd Hawaii International Conference on System Sciences, pp. 1–9 (2000)Google Scholar
  6. 6.
    Cullen, D.: Excel snafu costs firm $24 m. The Register (2003)Google Scholar
  7. 7.
    Abraham, R., Erwig, M.: AutoTest: a tool for automatic test case generation in spreadsheets. In: 2006 IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC 2006, pp. 43–50. IEEE (2006)Google Scholar
  8. 8.
    Rothermel, G., Burnett, M., Li, L., DuPuis, C., Sheretov, A.: A methodology for testing spreadsheets. ACM Trans. Soft. Eng., 110–147 (2001) Google Scholar
  9. 9.
    Rothermel, G., Li, L., Burnett, M.: Testing strategies for form-based visual programs. In: Proceedings of the 8th International Symposium on Software Reliability Engineering, pp. 96–107 (1997)Google Scholar
  10. 10.
    Rothermel, G., Li, L., DuPuis, C., Burnett, M.: What you see is what you test: a methodology for testing form-based visual programs. In: Proceedings of the 20th International Conference on Software Engineering, pp. 198–207 (1998)Google Scholar
  11. 11.
    Rothermel, K.J., Cook, C.R., Burnett, M.M., Schonfeld, J., Green, T.R.G., Rothermel, G.: WYSIWYT testing in the spreadsheet paradigm: an empirical evaluation. In: Proceedings of the 22nd International Conference on Software Engineering, June 2000Google Scholar
  12. 12.
    Fisher, M., Cao, M., Rothermel, G., Cook, C., Burnett, M.: Automated Test Case generation for spreadsheets. In: Proceedings of the 24th International Conference on Software Engineering, ICSE 2002, pp. 141–151 (2002) Google Scholar
  13. 13.
    Fisher, M., Rothermel, G.: Integrating automated test generation into the WYSIWYT spreadsheet testing methodology. ACM Trans. Softw. Eng. Methodol. 15(2), 150–194 (2006)CrossRefGoogle Scholar
  14. 14.
    Abreu, R., Hofer, B., Perez, A., Wotawa, F.: Using constraints to diagnose faulty spreadsheets. Soft. Qual. J. 23(2), 297–322 (2015)CrossRefGoogle Scholar

Copyright information

© Springer Nature Singapore Pte Ltd. 2018

Authors and Affiliations

  1. 1.College of Computer ScienceNorth China University of TechnologyBeijingChina

Personalised recommendations