A Comparative Study of Automated Testing Tools for Spreadsheets
Abstract
Organizations and industries use spreadsheet programs, such as MS Excel, for various tasks, such as accounting, financial calculations, and reporting. However, the number of spreadsheets that contain errors is very high. One primary reason is that different end-users develop spreadsheets without programming or software development training. Thus, researchers have proposed a variety of automated tools and techniques to support the end-users in finding and fixing errors in spreadsheets. The main objective of this paper is to study different automated tools in spreadsheet testing and classify them according to two criteria: how they work and the ability to find spreadsheet faults. For this purpose, we discuss various spreadsheet testing automated tools, techniques, and strategies. In addition, we highlight their performance and where they can be used so that they can be beneficial to both end-users and researchers. We then set out key directions for potential future works.
Full text article
Authors
Copyright (c) 2022 Journal of Pure & Applied Sciences
This work is licensed under a Creative Commons Attribution 4.0 International License.
In a brief statement, the rights relate to the publication and distribution of research published in the journal of the University of Sebha where authors who have published their articles in the journal of the university of Sebha should how they can use or distribute their articles. They reserve all their rights to the published works, such as (but not limited to) the following rights:
- Copyright and other property rights related to the article, such as patent rights.
- Research published in the journal of the University of Sebha and used in its future works, including lectures and books, the right to reproduce articles for their own purposes, and the right to self-archive their articles.
- The right to enter a separate article, or for a non-exclusive distribution of their article with an acknowledgment of its initial publication in the journal of Sebha University.
Privacy Statement The names and e-mail addresses entered on the Sabha University Journal site will be used for the aforementioned purposes only and for which they were used.