As per summary, it seems not to be possible to save a spreadsheet as .xltx ( = a template file in .xlsx format ) I can open a file saved in Excel with .xltx extension and it'll correctly open as a new, untitled document, it's just saving into this format that is missing. It works with binary .xlt, as well as native .ots and, as far as I can see, it's always been like that (inherited from OOo)
confirmed. The same applies for dotx, dotm and potx, but not for potm :)
*** Bug 118462 has been marked as a duplicate of this bug. ***
If you want to see the trivial code to solve the issue look at bug 118462.
Name: [Content_Types].xml <?xml version="1.0" encoding="UTF-8" standalone="true"?> -<Types xmlns="http://schemas.openxmlformats.org/package/2006/content-types"> Test.xlsx\ <Override ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml" PartName="/xl/workbook.xml"/> Test.xlts\ <Override ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.template.main+xml" PartName="/xl/workbook.xml"/> Test.xlsm\ <Override ContentType="application/vnd.ms-excel.sheet.macroEnabled.main+xml" PartName="/xl/workbook.xml"/> Test.xltm\ <Override ContentType="application/vnd.ms-excel.template.macroEnabled.main+xml" PartName="/xl/workbook.xml"/>
Vasily Melenchuk committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/8cc29e7040ed02afd5f979e23c9ec154c0cb2c83%5E%21 tdf#99438: sc: support for .xltx export It will be available in 6.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Still no Excel 2007-2019 (macro-enabled template)(*.xltm). More than original issue but was marked as duplicate and closed so incorporated into this issue. Just to be clear - not expecting to write or run code, just save existing code if workbook template changed. One use case might be edit and save existing macro-enabled spreadsheet as macro-enabled template.
Same functionality is appropriate in other modules, especially Writer, and file type description should be exactly consistent across all modules.
(In reply to flywire0 from comment #6) > Still no Excel 2007-2019 (macro-enabled template)(*.xltm). More than > original issue but was marked as duplicate and closed so incorporated into > this issue. > see at bug 118463 I think this bug need to close as FIXED
Part fix in my opinion since same issue applies to writer and other modules. Do they really have to be listed as individual bugs?
Yes.
(In reply to flywire from comment #9) > Part fix in my opinion since same issue applies to writer and other modules. > Do they really have to be listed as individual bugs? FYI: https://gerrit.libreoffice.org/#/c/64947/ sw: support for saving into .dotx file
Thanks. PowerPoint 2007-2019 Template (*.potx) also implemented - I'm sure neither were there when I initially checked. Suppose Macro-Enabled Template interface could be enabled in response to Bug 118463.