A decomposition-based approach to spreadsheet testing and debugging.
Symposium on Visual Languages and Human Centric Computing VL HCC(2017)
摘要
Spreadsheets serve as a basis for decision-making processes in many companies and bugs in spreadsheets can therefore represent a considerable risk to businesses. Systematic tests can help to locate such bugs, but providing test cases can be cumbersome and complex for large real-world spreadsheets. To make the specification of test cases easier, we propose to split spreadsheets into smaller logically connected parts (called fragments) which can be individually tested for correctness. We present an algorithmic approach to compute such fragments, which we validated with a laboratory study in the form of a spreadsheet debugging exercise involving 57 subjects. The results show that the fragmentation approach can help to significantly reduce the required efforts to test a spreadsheet.
更多查看译文
关键词
spreadsheet testing,bugs,systematic tests,real-world spreadsheets,algorithmic approach,spreadsheet debugging exercise,fragmentation approach,decomposition-based approach
AI 理解论文
溯源树
样例
生成溯源树,研究论文发展脉络