Skip to main content
Disciplines
Automotive Business IT + Informatics Construction + Real Estate Electrical Engineering + Electronics Energy + Sustainability Insurance + Risk Finance + Banking Management + Leadership Marketing + Sales Mechanical Engineering + Materials
Events
DE
EN
Books
Journals
Topic Page
Marketing
Start single access now
Access for companies
EXTENDED SEARCH
Log in
Top
Published in:
An Examination of the Effect of the Contextual UI Design Quality of Mobile Shopping Applications on the Loyalty of Users to the Applications Read chapter Read first chapter

2018 | OriginalPaper | Chapter

An Approach of Test Case Generation for Spreadsheet Cells

Authors : Bo Yang, Qian Yu

Published in: Advances in Computer Science and Ubiquitous Computing

Publisher: Springer Singapore

Log in

Activate our intelligent search to find suitable subject content or patents.

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.

Dont have a licence yet? Then find out more about our products and how to get one now:

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!

inform now

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!

inform now

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!

inform now
previous chapter Securing Intelligent Vehicular Ad Hoc Networks: A Survey
next chapter Bearing Fault Diagnosis Based on Convolutional Neural Networks with Kurtogram Representation of Acoustic Emission Signals
Literature
1.
Bhargava, H.K., Sridhar, S., Herrick, C.: Beyond spreadsheets: tools for building decision support systems. IEEE Comput. 32(3), 31–39 (2002)CrossRef
2.
Ditlea, S.: Spreadsheets can be hazardous to your health. Pers. Comput. 11(1), 60–69 (1987)
3.
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.
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.
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.
Cullen, D.: Excel snafu costs firm $24 m. The Register (2003)
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)
8.
Rothermel, G., Burnett, M., Li, L., DuPuis, C., Sheretov, A.: A methodology for testing spreadsheets. ACM Trans. Soft. Eng., 110–147 (2001)
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)
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)
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 2000
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)
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)CrossRef
14.
Abreu, R., Hofer, B., Perez, A., Wotawa, F.: Using constraints to diagnose faulty spreadsheets. Soft. Qual. J. 23(2), 297–322 (2015)CrossRef
Metadata
Title
An Approach of Test Case Generation for Spreadsheet Cells
Authors
Bo Yang
Qian Yu
Copyright Year
2018
Publisher
Springer Singapore
Book
Advances in Computer Science and Ubiquitous Computing

Print ISBN: 978-981-10-7604-6

Electronic ISBN: 978-981-10-7605-3

Copyright Year: 2018

DOI
https://doi.org/10.1007/978-981-10-7605-3_3