i-nth logo

Authors

Noprianto, Benfano Soewito, Ford Lumban Gaol, & Harco Leslie Hendric

Abstract

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.

Sample

Simple spreadsheet test case application
Simple spreadsheet test case application

We want to make testing a formula in spreadsheet easier, by using an application that can be used to write test cases for spreadsheet formula.

This application does not require any spreadsheet software to be installed in the system, in order to generate test cases. It will run as standalone graphical user interface application.

To make it easier for users, it comes with simple user interface: the only needed inputs are the formula definition, where to put formula result, where to put comparison between formula and expected result, and one or more test cases along with expected result.

Publication

2016, International Conference on Knowledge, Information and Creativity Support Systems (KICSS), November

Full article

Simple spreadsheet test case application to test spreadsheet formula in end-user software engineering

Also see

Presentation