https://bugs.documentfoundation.org/show_bug.cgi?id=120689
Bug ID: 120689
Summary: FILESAVE Roundtripped XLSM opens with recovery in
Excel
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: ba...@caesar.elte.hu
Blocks: 104839, 108908
Created attachment 145818
--> https://bugs.documentfoundation.org/attachment.cgi?id=145818&action=edit
Sample XLSM
The attached Excel XLSM contains a simple function called from a couple of
fields.
Save it in Calc, and open it in Excel.
=> Excel opens the file with recovery, after which it claims named range from
/xl/workbook.xml has been removed.
It appears Calc saves this in /xl/workbook.xml that wasn't in the original, and
is removed with the recovery:
<definedNames>
<definedName function="true" hidden="false" name="TEST" vbProcedure="true"/>
</definedNames>
After removing these manually, and rezipping the XLSM, the file opens fine in
Excel.
Observed using LO 6.2.0.0.alpha0+ (2018-10-09,
425af6845ebe066c950b0b63f50563e067485f3e) / Windows 7.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=104839
[Bug 104839] [META] Saved XLSX files that MS Excel can't open
https://bugs.documentfoundation.org/show_bug.cgi?id=108908
[Bug 108908] [META] Visual Basic for Applications (VBA) macro issues
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs