2005 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC'05)
Goal-Directed Debugging of Spreadsheets
Dallas, Texas
September 20-September 24
ISBN: 0-7695-2443-5
We present a semi-automatic debugger for spreadsheet systems that is specifically targeted at end-user programmers. Users can report expected values for cells that yield incorrect results. The system then generates change suggestions that could correct the error. Users can interactively explore, apply, refine, or reject these change suggestions. The computation of change suggestions is based on a formal inference system that propagates expected values backwards across formulas. The system is fully integrated into Microsoft Excel and can be used to automatically detect and correct various kinds of errors in spreadsheets. Test results show that the system works accurately and reliably.
Index Terms:
Spreadsheet, Debugging, Static Analysis, End-User Software Engineering
Citation:
Robin Abraham, Martin Erwig, "Goal-Directed Debugging of Spreadsheets," vlhcc, pp.37-44, 2005 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC'05), 2005