The Apache POI project provides a free open-source library for creating, reading and manipulating Microsoft Office documents. The functionality for working with Excel files is pretty mature and is quite feature-complete. Lately, I was confronted with a problem concerning formula evaluation. I had a pre-existing Excel template file that had some cells with placeholder texts. [...]