|Title||Automated refactoring of nested-IF formulae in spreadsheets|
|Authors||Jie Zhang, Shi Han, Dan Hao, Lu Zhang, & Dongmei Zhang|
Spreadsheets are the most popular end-user programming software, where formulae act like programs and also have smells.
One well recognized common smell of spreadsheet formulae is nest-
The previous research work has made very initial attempts in this aspect, while no effective and automated approach is currently available.
This paper firstly proposes an Abstract Syntax Tree (AST)-based automated approach to systematically refactoring nest-
A comprehensive evaluation has been conducted against a real-world spreadsheet corpus, which is collected in a leading IT company for research purpose. The results with over 68,000 spreadsheets with 27 million nest-
In addition, a survey involving 49 participants indicates that for most cases the participants prefer the refactored formulae, and agree on that such automated refactoring approach is necessary and helpful.
We refactor nested-
This circos visualization shows the scale of refactored formulae for each pattern of nested-