According to Almeida et al. (2016), Google sheets and excel are some of the current spreadsheet applicationsthat provide inbuilt facilities such as statistical, arithmetic and financial operations.The application can be used byprogrammers to develop spreadsheet programs without training. These applications failto provide the errors in the program that can be misleading in the decision-making process in an organization.Almeida et al.
focused on an approach, to develop high-qualityspreadsheet programs that provide theprogrammer with the possible faults. Also,the authors proposed an SS-BDD framework fordeveloping and conducting spreadsheets test scenarios. The tests used arerelied on Behavior Driven Development (BDD) to test three differentspreadsheets which are taken from varioussources. The accuracy is also tested byinjecting some faults knowingly in the spreadsheets.
The primary elementsfollowed in the spreadsheet testing process are· The variousscenarios to which the spreadsheets areexposed and the values that are expectedfrom these conditions. · The testswhich are implemented are named as spreadsheets under test (SUT). · The testscripts communicate with the SUT input cells to verify that the output valuesare corresponding to the expected input values. · The execution isdone, and a report is prepared to focus on the results of executed tests.In 2016, Almeida et al.
conducted the test using three spreadsheetswith an SS-BDD framework with defined scenarios.The first scenario is error-guessing testcase design technique, in second scenario test script was implemented manually,and lastly,all the implemented test scripts were executed.During the execution of the test scripts,38 faults were detected as the output ofthe test.According to Almeida et al.
based on the challenges facedduring the test, the authors suggest thatinstead of implementing these tests, the end user programmers must be allowedto access the spreadsheets directly from the specified scenarios. Also, thespreadsheet applications such as Excel and Google sheets should be analyzed by incremental graphical feedbackthat is connected with the construction process.The proposed framework can efficiently identify the faultsrelated to spreadsheets by helping the end user programmers. The authors planto implement another technique in the future which generates test scripts andtest inputs with the existing test tools for spreadsheets. According to Ding et al. (2016), the tests identified do not evaluate all the statementsand other coverages such as modified condition/decision coverage(MC/DC). Also,the efficiency of metamorphic testing is verified using partial mutationtesting, by applying to one module of ADDA program that is linked to criticalcomputing task.
For a general idea, the testingwas performed with few mutants that are created by mutuation testing tools tocode manually. But, in this study the mutants were easily destroyed by simple testsdue to sceintific software complexity.The relations identified indirectlyon image data were relatively weak and because of uncertainity of the testoutput, testing was unsuccessful.
Ding et al. proposed that by focusing on MRs,the metamorphic testing can be performed and validated.