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

openpyxl library writes formulas but doesn't evaluate them, leading to silent errors in generated spreadsheets. This can result in incorrect numbers that appear correct, making it difficult to detect issues. To avoid this, use a library that evaluates formulas or manually recalculate the workbook after generation. This issue can cause problems in finance and other applications where accuracy is crucial.