Using constraints to diagnose faulty spreadsheets
Using constraints to diagnose faulty spreadsheets
dc.contributor.author | Rui Maranhão | en |
dc.contributor.author | Hofer,B | en |
dc.contributor.author | Alexandre Campos Perez | en |
dc.contributor.author | Wotawa,F | en |
dc.date.accessioned | 2018-01-15T16:50:27Z | |
dc.date.available | 2018-01-15T16:50:27Z | |
dc.date.issued | 2015 | en |
dc.description.abstract | Spreadsheets can be viewed as a highly flexible programming environment for end users. Spreadsheets are widely adopted for decision making and may have a serious economical impact for the business. However, spreadsheets are staggeringly prone to errors. Hence, approaches for aiding the process of pinpointing the faulty cells in a spreadsheet are of great value. We present a constraint-based approach, ConBug, for debugging spreadsheets. The approach takes as input a (faulty) spreadsheet and a test case that reveals the fault and computes a set of diagnosis candidates for the debugging problem. Therefore, we convert the spreadsheet and a test case to a constraint satisfaction problem. We perform an empirical evaluation with 78 spreadsheets from different sources, where we demonstrate that our approach is light-weight and efficient. From our experimental results, we conclude that ConBug helps end users to pinpoint faulty cells. | en |
dc.identifier.uri | http://repositorio.inesctec.pt/handle/123456789/6205 | |
dc.identifier.uri | http://dx.doi.org/10.1007/s11219-014-9236-4 | en |
dc.language | eng | en |
dc.relation | 6415 | en |
dc.relation | 5609 | en |
dc.rights | info:eu-repo/semantics/openAccess | en |
dc.title | Using constraints to diagnose faulty spreadsheets | en |
dc.type | article | en |
dc.type | Publication | en |
Files
Original bundle
1 - 1 of 1