Using spreadsheet software, users may do some forms of programming using formula and function. However, formula definition is often considered correct after tested with only one or few inputs. This may be fine with simple formula, but for more complex ones, more testings should be performed, in order to prevent solution that riddled with errors. However, writing a formula test case in spreadsheet software is not a simple task, mainly because there is no standard way to do that. In this paper, a simple spreadsheet test case application is proposed. User can define a formula, with many input variants, along with expected results. After that, application will generate a spreadsheet document, with all the needed contents for testing, along with test result. That way, user may re-check the formula and make necessary modifications (then run the test, again). Using this method, a formula can be tested first, with many input as needed, before it put in real document. All of these will impact in more productive programmers, with less time spent for debugging.
Noprianto, Soewito B, Gaol D. F. L and Hendric S. W. H. L. (2017). Simple Spreadsheet Test Case Application to Test Spreadsheet Formula in End-User Software Engineering (SCOPUS). 2016 11th International Conference on Knowledge, Information and Creativity Support Systems (KICSS), 1-5. Yogyakarta, Indonesia: IEEE
spreadsheet, formula, spreadsheet test case, testing, end-user software engineering, end-user programming