Skip to main content

2018 | OriginalPaper | Buchkapitel

An Approach of Test Case Generation for Spreadsheet Cells

verfasst von : Bo Yang, Qian Yu

Erschienen in: Advances in Computer Science and Ubiquitous Computing

Verlag: Springer Singapore

Aktivieren Sie unsere intelligente Suche um passende Fachinhalte oder Patente zu finden.

search-config
loading …

Abstract

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.

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Literatur
1.
Zurück zum Zitat Bhargava, H.K., Sridhar, S., Herrick, C.: Beyond spreadsheets: tools for building decision support systems. IEEE Comput. 32(3), 31–39 (2002)CrossRef Bhargava, H.K., Sridhar, S., Herrick, C.: Beyond spreadsheets: tools for building decision support systems. IEEE Comput. 32(3), 31–39 (2002)CrossRef
2.
Zurück zum Zitat Ditlea, S.: Spreadsheets can be hazardous to your health. Pers. Comput. 11(1), 60–69 (1987) Ditlea, S.: Spreadsheets can be hazardous to your health. Pers. Comput. 11(1), 60–69 (1987)
3.
Zurück zum Zitat Brown, P.S., Gould, J.D.: An experimental study of people creating spreadsheets. ACM Trans. Office Inf. Syst. 5(3), 258–272 (1987)CrossRef Brown, P.S., Gould, J.D.: An experimental study of people creating spreadsheets. ACM Trans. Office Inf. Syst. 5(3), 258–272 (1987)CrossRef
4.
Zurück zum Zitat 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) 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)
5.
Zurück zum Zitat 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) 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)
6.
Zurück zum Zitat Cullen, D.: Excel snafu costs firm $24 m. The Register (2003) Cullen, D.: Excel snafu costs firm $24 m. The Register (2003)
7.
Zurück zum Zitat 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) 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)
8.
Zurück zum Zitat Rothermel, G., Burnett, M., Li, L., DuPuis, C., Sheretov, A.: A methodology for testing spreadsheets. ACM Trans. Soft. Eng., 110–147 (2001) Rothermel, G., Burnett, M., Li, L., DuPuis, C., Sheretov, A.: A methodology for testing spreadsheets. ACM Trans. Soft. Eng., 110–147 (2001)
9.
Zurück zum Zitat 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) 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)
10.
Zurück zum Zitat 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) 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)
11.
Zurück zum Zitat 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 2000 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 2000
12.
Zurück zum Zitat 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) 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)
13.
Zurück zum Zitat Fisher, M., Rothermel, G.: Integrating automated test generation into the WYSIWYT spreadsheet testing methodology. ACM Trans. Softw. Eng. Methodol. 15(2), 150–194 (2006)CrossRef Fisher, M., Rothermel, G.: Integrating automated test generation into the WYSIWYT spreadsheet testing methodology. ACM Trans. Softw. Eng. Methodol. 15(2), 150–194 (2006)CrossRef
14.
Zurück zum Zitat Abreu, R., Hofer, B., Perez, A., Wotawa, F.: Using constraints to diagnose faulty spreadsheets. Soft. Qual. J. 23(2), 297–322 (2015)CrossRef Abreu, R., Hofer, B., Perez, A., Wotawa, F.: Using constraints to diagnose faulty spreadsheets. Soft. Qual. J. 23(2), 297–322 (2015)CrossRef
Metadaten
Titel
An Approach of Test Case Generation for Spreadsheet Cells
verfasst von
Bo Yang
Qian Yu
Copyright-Jahr
2018
Verlag
Springer Singapore
DOI
https://doi.org/10.1007/978-981-10-7605-3_3

Neuer Inhalt