Multiple Operations

Analogous to a long method, a formula with many different operations will likely be harder to understand than a shorter one. Especially since in most spreadsheet programs, there is limited space to view a formula, causing long formulas to be cut off.

Related smells: Long Method

Reference

F. Hermans, M. Pinzger, A. van Deursen. “Detecting Code Smells in Spreadsheet Formulas”. ICSM 2012, pp. 409–418.


Spreadsheet Smells

Home

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