Inappropriate Intimacy

This smell occurs when a worksheet overly related to another worksheet. This is possibly unhealthy for several reasons. First, adapting one sheet likely requires inspecting the other worksheet, requiring the spreadsheet user to switch back and forth between the two worksheets, increasing the chance that errors are made. Secondly, since there is a strong semantic connection between the two worksheets, the fact that they are split could influence understandability.

Related smells: Inappropriate Intimacy

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.