2014 · 46 citations · 25 references
ComputingComputer ScienceAlgorithmsKnowledge RepresentationNatural Language ProcessingData-flow AnalysisError DetectionSoftware DesignAutomated Bug FindingEmpirical EvaluationEnd Users
Spreadsheets are widely used by end users for numerical computation in their business. Spreadsheet cells whose computation is subject to the same semantics are often clustered in a row or column. When a spreadsheet evolves, these cell clusters can degenerate due to ad hoc modifications or undisciplined copy-and-pastes. Such degenerated clusters no longer keep cells prescribing the same computational semantics, and are said to exhibit ambiguous computation smells. Our empirical study finds that such smells are common and likely harmful. We propose AmCheck, a novel technique that automatically detects and repairs ambiguous computation smells by recovering their intended computational semantics. A case study using AmCheck suggests that it is useful for discovering and repairing real spreadsheet problems.
25
Oracle-guided component-based program synthesis
Susmit Jha, Sumit Gulwani, Sanjit A. Seshia et al. · 2010 · 479 citations
Synthesis of loop-free programs
Sumit Gulwani, Susmit Jha, Ashish Tiwari et al. · ACM SIGPLAN Notices · 2011 · 242 citations
Bug characteristics in open source software
Lin Tan, Chen Liu, LI Zhen-min et al. · Empirical Software Engineering · 2013 · 232 citations
Shan Lu, Soyeon Park, Chongfeng Hu et al. · 2007 · 217 citations