When using the XLSX report template, I have set the "Rows to repeat at top" in the Page Setup -> Sheet tab. This allows me to have certain rows to repeat on each page, when I print it in PDF. However, currently this is not copied to the result output XLSX file. I have analyzed the code and I think the XlsxFormatter needs to copy a defined name "_xlnm.Print_Titles", from the template file to the result output file, so that this setting is preserved/copied to the output.
Minimal reproducible example
Create an XLSX template and the "Rows to repeat at top" parameter in the Page Setup -> Sheet tab.
Generate the output XLSX file and check this setting again.
Expected behavior
It should have been copied over.
Environment
Description of the bug or enhancement
When using the XLSX report template, I have set the "Rows to repeat at top" in the Page Setup -> Sheet tab. This allows me to have certain rows to repeat on each page, when I print it in PDF. However, currently this is not copied to the result output XLSX file. I have analyzed the code and I think the XlsxFormatter needs to copy a defined name "_xlnm.Print_Titles", from the template file to the result output file, so that this setting is preserved/copied to the output.
Minimal reproducible example Create an XLSX template and the "Rows to repeat at top" parameter in the Page Setup -> Sheet tab. Generate the output XLSX file and check this setting again.
Expected behavior It should have been copied over.
Actual behavior It is missing.