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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Bhargava, H.K., Sridhar, S., Herrick, C.: Beyond spreadsheets: tools for building decision support systems. IEEE Comput. 32(3), 31–39 (2002)
Ditlea, S.: Spreadsheets can be hazardous to your health. Pers. Comput. 11(1), 60–69 (1987)
Brown, P.S., Gould, J.D.: An experimental study of people creating spreadsheets. ACM Trans. Office Inf. Syst. 5(3), 258–272 (1987)
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)
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)
Cullen, D.: Excel snafu costs firm $24Â m. The Register (2003)
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)
Rothermel, G., Burnett, M., Li, L., DuPuis, C., Sheretov, A.: A methodology for testing spreadsheets. ACM Trans. Soft. Eng., 110–147 (2001)
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., 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, 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
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., Rothermel, G.: Integrating automated test generation into the WYSIWYT spreadsheet testing methodology. ACM Trans. Softw. Eng. Methodol. 15(2), 150–194 (2006)
Abreu, R., Hofer, B., Perez, A., Wotawa, F.: Using constraints to diagnose faulty spreadsheets. Soft. Qual. J. 23(2), 297–322 (2015)
Author information
Authors and Affiliations
Corresponding authors
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer Nature Singapore Pte Ltd.
About this paper
Cite this paper
Yang, B., Yu, Q. (2018). An Approach of Test Case Generation for Spreadsheet Cells. In: Park, J., Loia, V., Yi, G., Sung, Y. (eds) Advances in Computer Science and Ubiquitous Computing. CUTE CSA 2017 2017. Lecture Notes in Electrical Engineering, vol 474. Springer, Singapore. https://doi.org/10.1007/978-981-10-7605-3_3
Download citation
DOI: https://doi.org/10.1007/978-981-10-7605-3_3
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-10-7604-6
Online ISBN: 978-981-10-7605-3
eBook Packages: EngineeringEngineering (R0)