Feature Envy

This smell occurs when there is a formula that is more interested in cells from another worksheet. In such a case, it would be better to move the formula to that worksheet. This will likely improve understandability, since the formula is then closer to the cells it is referring to.

Related smells: Feature Envy

Reference

F. Hermans, M. Pinzger, A. van Deursen, “Detecting and Visualizing Inter-Worksheet Smells in Spreadsheets”. ICSE 2012, pp. 441–451.


Spreadsheet Smells

Home

All rights reserved (c) Tushar Sharma 2017-23.