A new version has been released today.
Revision Details
Added support for Excel formula output.
Excel formulas can now be output. In the previous version, Office File Creator did not output formulas in Excel template files. In the new version, formulas are now output.
Version
Ver. 1.15 (both free and paid versions)
*Existing users of Ver. 1 have been upgraded.
Actions Required for the New Version
A Field for the system in the OFC_Template object have been added
A field of the OFC_Template object "TemplateUploadedPackageVersion" (API name: TemplateUploadedPackageVersion__c) has been added. Please grant reference and edit permissions to the field-level security for the administrator user.
If an existing template file contains Excel formulas
Excel formula output is applied to template files uploaded with the new version (Ver. 1.15) or later. Even if an existing template contains formulas, the formulas will not be output if the template file was uploaded with a previous version, so please upload the template file again with the new version.However, in the version upgrade on or after June 1, 2023, formulas will be output for all uploaded template files in all versions. For those who use Excel formulas in existing templates, the results of formulas that were previously output as blank will be output in versions released on or after June 1, 2023. Please upload the template file again with the new version and check the output contents.
Normal Excel formulas can be used, but please refer to the following article for pointers on setting up formulas in Office File Creator.
Setting Formulas in Excel Template Files with Office File Creator
