Formulas in Excel are not output correctly. Formulas are output a few lines off.

It is possible that the template pattern is not supported by the application. Create a formula field in Salesforce and set it as a merge field.