openpyxl writes formulas. It never evaluates them — so your generated spreadsheet can be silently wrong.

Your test asserts the cell equals "=AVERAGE(B2:B13)" and passes. The customer opens the file and reads 1.6% where the truth is 3.25%. Here is why the usual test suite can't see it, why data_only=True doesn't save you, and what to assert instead.